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

Which TM1 Server version is this function available for?

Version 11 and 12

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.