ROAC

This function returns the value of an attribute of an element in a specified context.

ROAC is the non-writable version of RWAC.

If dynamic attributes are built into an OLAP data model, the values of 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 the driver dimensions.

Syntax

=ROAC("data_connection","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.

Example

This example is based on the Sample application, which has the dynamic attribute Regional Product Manager on the Product dimension. The Period and Region dimensions are driver dimensions. That is, the value of the Regional Product Manager attribute depends on which elements are selected from the Period and Region dimensions:

=ROAC("BestPracticesOLAP","Analysis","[product]", "Regional Product Manager","[product].[all tires].[car tires all season]", "[period].[all years].[2016]","[region].[all regions]")