When a measure appears in multiple worksheets, you must change the loaded or input values for the measure, not the calculated values derived from them. Otherwise, the changes are not propagated to loaded or input values for the same measure in other worksheets, and calculation problems may occur. Similarly, when you change a measure value that is summarized at higher levels in a dimension hierarchy, you must make the changes to the leaf (lowest) level in each hierarchy.
For example, assume that values for the measure Projected Sales are loaded based on fiscal calendar months. When you change values for Projected Sales, you must change the monthly values. If you change yearly values, the changes will not be propagated to lower levels in the hierarchy, and calculation problems may occur.
In most cases, before you begin an analysis, you will know with which measures in which worksheets to work. An administrator can determine which measure values are loaded, input, or calculated in a worksheet by looking at measure definition XML files.
To change a measure value in a planning worksheet, select the cell containing the value, edit the value, and press Enter.