Salesforce gives you a lot of flexibility. At times you need pointers to customize your App the way you imagined. One such example is customizing the layout of a new record page. I’ll show you exactly how to accomplish that.
Here are some useful Salesforce SOQL queries for reporting that isn’t easily available otherwise.
TM1 does not offer a native IRR function. After three years of on-again/off-again thinking through and researching online how to construct a proper TM1 rule-based IRR calculation, I’ve built this methodology which has been used in a production environment for several years.
You can use the ExecuteFunction PAX API method to execute a TI process using Excel VBA. There are several limitations. I took the challenge and created my own RunProcess subroutine to solve for these limitations.
Here’s how to create links to IBM Planning Analytics Workspace (PAW) books with filters within the URL.
With Excel, users have to click “Enable Contents” when they first open a file with VBA embedded. This function allows you to check if they did so.
Find the correct path to Google Chrome, which depends on your device.
Move an Excel file from one location to another, and even change the filetype.
Create a folder and all necessary parent folders.