Category Archives: Excel

How to Install Planning Analytics for Excel (PAx)

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).

This entry was posted in Excel, Planning Analytics, Planning Analytics Excel and tagged Excel, Excel Addin, Planning Analytics. Bookmark the permalink. | Tagged Excel, Excel Addin, Planning Analytics | Leave a comment

Errors when Connecting to Planning Analytics for Excel/CAFE

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!

This entry was posted in Errors, Excel, Planning Analytics and tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics. Bookmark the permalink. | Tagged Café, Errors, Excel, Excel Addin, PAX, Planning Analytics | 1 Comment

DBRW TM1 Excel Syntax and Use

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

This entry was posted in Excel. Bookmark the permalink. | 1 Comment

DBRA TM1 Excel Syntax and Use

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

This entry was posted in Excel. Bookmark the permalink. | 1 Comment

Display TM1 Attributes in Excel

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

This entry was posted in Attributes, Excel. Bookmark the permalink. | Leave a comment

How to Enable the TM1 Excel Addin and TM1 Perspectives Ribbon in Excel

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

This entry was posted in Excel, Installation. Bookmark the permalink. | Leave a comment

ELPAR TM1 Function: Syntax and Use

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

This entry was posted in Excel. Bookmark the permalink. | Leave a comment