Category Archives: Excel
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) or Cognos Analysis for Excel (CAFE) onto a client computer and connect to an IBM Cloud version of Planning Analytics (TM1).
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!
DBRW is an Excel based function for use with TM1 that retrieves a value from a specific intersection of a cube TM1. Example I have a Sales Analysis cube with the following dimensions: Year, Month, Customer, Product, Measures. I want the intersection of: 2015 (Year), Oct (Month), The Corner Cafe (Customer), Coffee (Product) and Sales $ (Measure). If I open Architect and navigate to this intersection, it says $1,230.00. I now want to … Continue Reading
DBRA is an Excel based function for use with TM1 that retrieves the value of an Attribute from a Dimension in TM1. It is roughly equivalent to using a ATTRS in a Rule or TI. Example For example if I have a dimension called Customer with an attribute called Channel. An element of this dimension is called “Fred Bloggs” (he’s a customer) and his Channel is “Retail”. In this case “Retail” would … Continue Reading
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
I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon included in Excel. So I thought I would do a quick blog about how to enable it. What this does is then automatically add the Perspectives addin to Excel on your PC so that TM1 automatically opens each time you … Continue Reading
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use a combination of attributes and ATTRS rather than this function. Please see our warning below. Syntax The syntax is: ELPAR(dimension, element, index), where: dimension is a valid dimension name, and element is the name of an element within the dimension or … Continue Reading