DBSA function for IBM Planning Analytics (TM1)

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.