Use the spread measure to edit scenario values

This measure (as defined in the worksheet parameter) is used to spread the modified values of a measure, that is not specified in rv_measure_calc, to an aggregate level. To edit the scenario values, in a worksheet, using a spread measure:

  • The worksheet must be part of a cycle-module combination with the Report Source type set to Embedded.
  • The measure must be included in rv_measure_editable (a set of measures that are editable). If not specified, all measures in rv_measure_passed can be edited.
  • The period element is not specified in the rv_period_lock set (the parameter contains a set of periods to lock or disable editing); or is not an ascendant or descendant (parent or child) of any of the periods in the parameter set.

    For example, if the rv_period_lock set is [FY 14 Qtr1], the FY 2014 and "Monthly Calendar" (ascendant) and the FY14 M01, FY14 M02, FY14 M03 (descendant). The elements are locked and cannot be modified.

Note: The data in a cell for the scenario can be modified, only if formatted with an underline.

When you directly edit a cell and use the Recalculate option to update the changes to the OLAP server, these are the possible scenarios:

  • If you edit an existing value (original value <> 0), and the current measure is not defined in rv_measure_calc, the new value is directly updated to OLAP without the special commands. If the cell is a base cell, OLAP generates a new value. If not, the existing value is spread across the data.
  • If the current measure is not defined in the rv_measure_calc, and you are specifying a new value (original value = zero):
    • If editing a base cell, the value is directly updated to OLAP without using the special commands.
      Note: The pivot attributes are used as part of the definition of a base cell. For example, selecting a base item, location, and period with the "All Class" pivot in the slicers area, the aggregate of the class pivot attribute is used, indication the current cell is not a base cell.
    • If the cell is a not a base cell, the #LIKEFULL new_value like_measure or rv_measure_spreadlike command is used. If rv_measure_spreadlike is not defined, the modified data cannot be saved.

The rv_measure_calc measure allows you to define the edit rules for the calculated measures. However, if a measure exists in the set, you must check the target, weight, and spread rule to revert the data.