Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    DBSA function for IBM Planning Analytics (TM1)

      DBSA is used to send a value to a dimension attribute. Depending on the attribute type, the value sent can be either a string or numeric.

      In the video, the DBSA function will be used to Populate the attribute Active Status from the Product Type dimension.

      Where can the DBSA function be used?

      Excel

        Which TM1 Server version is the DBSA function available for?

        Version 11 and 12

          What is the syntax for DBSA?

          DBSA(Value, TM1Server:Dimension, Element, Attribute)

          • Value = The value to be sent (string or numeric)
          • TM1Server = Name of the TM1 Server
          • Dimension = Name of the Dimension
          • Element = An element within the dimension of 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

          • DBRA = retrieve and write back a value or text to a dimension’s attribute.