<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>
Cubewise EDU
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    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