Category Archives: Excel
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 go 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.
Using DBRW with TM1 in both Perspectives and Planning Analytics for Excel based reports to display the contents of a specific intersection of a TM1 cube.
Use, Syntax and Example of DBRA with TM1 and Planning Analytics for Excel based reports to display the contents of an Attribute in the Excel sheet.
Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA and refer to the control cube for the relevant dimension in the Excel formula. Example I have a dimension called Customer. In this dimension there is an attribute called Channel. There is an element called “Fred Bloggs” (he’s a customer) and … Continue Reading