DBRA

DBRA retrieves the value of a specified member attribute.

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

Syntax

DBRA(server:dimension, element, attribute)

Argument

Description

Required/Optional

server:dimension

The name of the TM1® Server Application folder and the name of a dimension.

Required
element

A member of the dimension.

Required

attribute

The attribute for which you want to retrieve a value. This argument must be an attribute of the member.

Required

Example

In this example, the TM1 Server Application folder name is GO_New_Stores and the dimension name is Month. The function retrieves the value of the startdate attribute for Jan.
DBRA("GO_New_Stores:Month", "Jan", "startdate")

Example

In this example, the TM1 Server Application folder name is SData and the dimension name is Model. The function returns the value of the Engine Size attribute of the L Series 1.6 L Sedan member.
DBRA("SData:Model", "L Series 1.6 L Sedan", "Engine Size")