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:
|
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')