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 his Channel is “Retail”.

The syntax for DBRA is:

=DBRA(server:dimension,element,attribute);

So, in Excel to insert the attribute called Channel into a report I would enter:

=DBRA(“CXMD:Customer”,”Fred Bloggs”,”Channel” )

Importantly DBRA only accepts text as the element ID, so if your element is named using a numeric only sequence, you must ensure that you convert the numeric value to a text value. To do this insert TEXT(elementcell,”0″), where elementcell is the cell containing the numeric element ID.

 

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

This site uses Akismet to reduce spam. Learn how your comment data is processed.