DBRA function for IBM Planning Analytics (TM1)

DBRA is used to retrieve and write back a value or text to a dimension’s attribute. By incorporating the DBRA function into your model, you can enhance reporting capabilities and create more interactive solutions.

In the video, the DBRA function will be used to retrieve each region’s currency.

Where can the DBRA function be used?

Excel

Which TM1 Server version is the DBRA function available for?

Version 11 and 12

What is the syntax for DBRA?

DBRA(TM1Server:Dimension, Element, Attribute)

TM1Server = 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.

Relevant Functions

DBSA = Send a value to a dimension attribute