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")