ATTRS

ATTRS returns a string attribute for a specified element of a dimension or a dimension hierarchy.

This function is valid in both rules and processes.

Syntax

ATTRS(dimension, element, attribute)

Argument

Description

dimension

A valid dimension name.

element

An element of the dimension or a hierarchy/element pair.

If specifying a hierarchy/element pair, you must use this syntax: 'hierarchy_name:element_name'. Note that the hierarchy name and element name are enclosed in one set of single quotes.

attribute

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

Example

In this example, the function returns the string value of the Currency attribute of the 10100 element in the EMEA hierarchy of the plan_business_unit dimension.

ATTRS('plan_business_unit', 'EMEA:10100', 'Currency')