TM1 Report Column on Element Attribute

[ravi]

Hi
Is it possible to display an element attribute in a report? are there amy function that can call the attribute directly in a report column.



For example: The Expenditure Type element has an Attribute called Expenditure Category. We would like to show the category in a report.

Expenditure Category Expenditure Type
Labor Labor Regular



Please advise.
Ravi

[jstrygner]

If you mean a report in Perspectives, use DBRA worksheet function.

Code: Select all

=DBRA("ServerName:DimensionName";"DimensionElementName";"AttributeName")

As DBRA works like DBRW, which means displays the value, but also enables user to change it from Perspectives level I sometimes use:

Code: Select all

=""&DBRA("ServerName:DimensionName";"DimensionElementName";"AttributeName")

This way such a cell is "read-only".

HTH

[David Usherwood]

One word of warning - I noticed the delimiters in your example are ; . I'm guessing that this is a function of your version of Windows, or of Excel, or of your language settings. I'm based in the UK and I would see , used as delimiters.

[jstrygner]

Yes, that is my Excel setting I use, probably comas are more common around the world.