Category Archives: Excel
SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel report or form and open the subset editor to select elements.
Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.
The Control Tab in Excel is a great way to keep system relevant variables for your TM1 Excel based reports.
Need to create a dynamic print area in a TM1 Dynamic Report or Active Form? Here are detailed instructions of exactly how to do this really easily!
Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.
Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.
How to install IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots.
Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we run through how to get it all sorted!
Dynamic Subsets in TM1 and Planning Analytics allow you to create sets of elements that always contain all relevant elements. For example, all children of a parent, or all level 0 elements. They are extremely useful in Dynamic Reports as with them you can be sure that all elements are displayed.