DBSA

DBSA sends a value to a specified member attribute.

The value sent can be either a string or numeric value, depending on the attribute type.

Syntax

DBSA(att_value, server:dimension, member, att_name)

Argument

Description

Required/Optional

att_value

The value you want to send. To send the value as a string, use double quotation marks. For example "1.8" is sent as a string value while 1.8 is sent as a numeric value.

Required

server:dimension

The name of the TM1® server and a dimension name.

Required

member

A member of the dimension.

Required

att_name

The attribute to which you want to send a value. att_name must be an attribute of the member specified by the member argument.

Required

Example

In this example, the TM1 server name is Planning Sample. The function writes Jane Smithers to the Manager attribute of the UK member of the business_unit dimension.
DBSA("1.8", "SData:Model", "L Series 1.8 L Sedan", "Engine Size")

Example

In this example, the TM1 server name is SData. The function writes 1.8 to the Engine Size attribute of the L Series 1.8 L Sedan member of the Model dimension. The value, 1.8, is in double quotation marks because the Engine Size attribute is a text attribute. If the data type of the Engine Size parameter was Numeric, the function would be:
DBSA(1.8, "SData:model", "L Series 1.8 L Sedan", "Engine Size")