TM1 Forum

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

If you mean a report in Perspectives, use DBRA worksheet function.
As DBRA works like DBRW, which means displays the value, but also enables user to change it from Perspectives level I sometimes use:
This way such a cell is "read-only".

HTH

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.

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