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.

 

You might also like