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.