Display TM1 Attributes in Excel
How do I display a TM1 Attribute in an Excel report?
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”.
x for DBRA is:
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.