RWA
This function gets attributes from an attribute table and writes it back. You cannot write back changes to the values of intrinsic attributes but you can write back changes to other attributes. To write back to dynamic attributes, use RWAC.
Note: ROA is the non-writable version
of RWA. To disable write back in a cell values formula, change RWA to ROA or
clear the option in the Edit OLAP
Formula dialog.
Syntax
=RWA("data_connection", "cube", "hierarchy_name",
"attribute_name", "element_name")
Example
=RWA("BestPracticesOLAP","Sales","[Product]","Att2_German","[Product].[All
Tires].[Car Tires All Season]")