Add child element to parent element while specifying its position using TM1 REST API
It’s possible to simultaneously create a child element and specify its position under a parent element using TM1 REST API.
TM1
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.
Accessing Planning Analytics Transaction Log in PAFE
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.