Creating CELLPROPERTYGET formulas in the Edit OLAP Formula wizard

CELLPROPERTYGET is a cell properties formula.

  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 Cell properties as the formula type.
  3. Select the data connection to use.
  4. Select the cube to use.
  5. Define the data area by selecting from the Hierarchy and Selection columns.
  6. Select the cell property from which to return a value.
  7. Optionally, to make the formula writable, select Allow writeback.
  8. Click OK.