TM1 Function for Excel, DBRA
DBRA is used to retrieve and write back a value or text to a dimension’s attribute
Where can the DBRA function be used?
Excel
What is the DBRA function?
DBRA is used to retrieve and write back a value or text to a dimension’s attribute.
What is the syntax for DBRA?
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.
A demonstration on how to use DBRA
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.