ROAC

Gets the value of an attribute of an element in a specified context.

If dynamic attributes are built into an OLAP data model, the value attributes that are assigned to elements can change according to the context in which those elements are reported. For example, to prevent fraud, the color of car parking permits might be different in the context of the year of issue. Or, the manager assigned to a product might change in the context of different stages of production. That is, changes to the attributes 'Color' and 'Manager' are driven by the elements that are selected from a 'Time' dimension and a 'Production Phase' dimension. In these examples, the 'Time' and 'Production Phase' dimensions are 'driver dimensions'.

Syntax

=ROAC("database alias", "cube", "hierarchy name", "attribute name", "element name", "context", "context...")

The context arguments are references to an element of a driver dimension. For example, a reference to a cell or variable that contains an element of a driver dimension.