Creating ROA and RWA formulas in the Edit OLAP Formula wizard

  1. In Design Mode, click the cell in which to create the formula and then click Edit OLAP Formula on the Objects tool bar.
  2. Select Attributes as the formula type.
  3. Select the data connection to use.
  4. Select the cube to use.
  5. Select the hierarchy that contains the attribute to use.
  6. Select the attribute to use.
  7. Select the element for which the formula will return the attribute value.
  8. To create an RWA formula, select Allow writeback of attributes.
    Note: If you select one of the intrinsic attributes, Allow writeback of attributes is disabled.
  9. Click OK.