Here are some useful batch scripts for IBM Planning Analytics for Excel (PAFE) Operations. Can use this as baseline to automate install / setup / deployment / configuration of IBM PAFE to end users. If you don’t want to run in Windows Command Prompt or Batch file, you can review the below and navigate directly to the appropriate registry keys or directories and adjust manually.
It’s possible to simultaneously create a child element and specify its position under a parent element using TM1 REST API.
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.
The TM1 Transaction Log records the history of changes to cube values in your database. I’ve taken the liberty to build a Transaction Log Excel App that works with PAFE.