Planning worksheets provide a view of measure values stored in cubes in the Integrated Operational Planning database. Measure values can be loaded, input, or calculated, depending on their original data source.
Calculated measure values are derived from formulas that take into account some or all of the following:
Cell Location—The location in the worksheet of the cell containing the measure value.
Hierarchy Level—The level to which a dimension hierarchy has been expanded or collapsed, which determines whether the measure represents a detailed or summarized value.
Time Period—The time period over which a measure value applies. Calculated and uncalculated measure values can also be summarized using aggregate functions.