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.
The magical way to put your username into a cell or string.
I’ve seen shapes placed on Excel sheets used to activate an Excel VBA. A more elegant solution is to use text hyperlinks.