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.