RWAC
This function writes back the value of an attribute of an element, in a specified context. You cannot write back changes to the values of intrinsic attributes but you can write back changes to other attributes.
RWAC is the writable version of ROAC.
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 who is 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
=RWAC("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:
=RWAC("BestPracticesOLAP","Analysis","[product]",
"Regional Product Manager","[product].[all tires].[car tires all season]",
"[period].[all years].[2016]","[region].[all regions]")