WBA

This function writes values to an attribute table. You cannot write back to intrinsic values.

Syntax

=WBA(value,"data_connection","cube","hierarchy_name","attribute_name", "element_name")

The first argument of the formula is the value to write to the attribute table. The last argument is the element to accept the value. Both arguments can be replaced by cell references.

You cannot write back a value in the cell containing the WBA function. Instead, you enter the values in an unprotected blank cell and reference that cell in the formula.

You can use the WBA formula in an Edited Cell action. The changed attribute is written back when it is entered in the cell.