Useful Salesforce SOQL Queries
Here are some useful Salesforce SOQL queries for reporting that isn’t easily available otherwise.
TM1 Rule-based Approach for Internal Rate of Return (IRR)
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.
RunProcess in PAFE
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.
Filter PAW Elements using URL
Here’s how to create links to IBM Planning Analytics Workspace (PAW) books with filters within the URL.
VBAEnabled: Did User Click “Enable Contents”?
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.
PathToChrome: Get the Correct Path to Google Chrome
Find the correct path to Google Chrome, which depends on your device.
MoveExcelFile: Moves an Excel File
Move an Excel file from one location to another, and even change the filetype.
CreateFolderStructure: Create Multiple Layers of Folders
Create a folder and all necessary parent folders.
PutUsername: Dynamically Put Username Into String
The magical way to put your username into a cell or string.