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 Allow writeback of attributes 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]")