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.