TM1 Function for Excel, DBSA
DBSA is used to send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the attribute type.
Where can the DBSA function be used?
Excel
What is the DBSA function?
DBSA is used to send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the attribute type.
What is the syntax for DBSA?
DBSA(Value, TM1ServerName:Dimension, Element, Attribute)
Value = The value to be sent – string or numeric
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 send the value to. This argument must be a valid attribute of the element above.
A demonstration on how to use DBSA
Populate the attribute, Active Status, from the Product Type dimension.