TM1 Function for Excel, DBRA
DBRA is used to retrieve and write back a value or text to a dimension’s attribute
DBRA is used to retrieve and write back a value or text to a dimension’s attribute.
DBRA(TM1ServerName:Dimension, Element, Attribute)
TM1ServerName = Name of the TM1 Server
Dimension = Name of the Dimension
Element = An element within the dimension from the Cube
Attribute = The attribute for which you want to retrieve a value. This argument must be a valid attribute of the element above.
In our General Ledger report we want to show what the Currency is for each country in the Region dimension. This can be obtained using the DBRA function.