GETATTR

Returns the content of a specified field in an attribute table.

Syntax

GETATTR(DimName, ElemName, ATabID, FieldName)

DimName is the name of the dimension containing the attribute table. ElemName is the element the attribute is attached to. ATabID is the ID of the attribute table containing the attributes. FieldName is the name of the column in the attribute table containing the attributes.

Example

If the APRODUCT field for the Car Tires Summer element in attribute table 1 of the Product dimension contains the text "Tanja.Saarbruecken@Genesis.com" then:

GETATTR('Product', 'Car Tires Summer', 1, 'APRODUCT')

Returns Tanja.Saarbruecken@Genesis.com.

The GETATTR function is analogous to an external cube reference in a cube rule. For example, if you want to write the above rule as a rule for all products, you substitute !Products for Car Tires Summer in the second argument of the function.