The Calculation Type page accepts input for the following items for a moving maximum calculation:
Measure
Select the measure for which you want to calculate a moving maximum.
Over
If there is more than one time dimension, then a box appears to allow the selection of the proper time dimension. Otherwise the default time dimension is used.
In
Select the hierarchy for the specified dimension.
Include previous
Enter the number of periods to be used for the calculation.
This formula is used to return the maximum value for a measure over a rolling number of time periods.
An example of this calculation is:
Moving maximum sales for the last 3 months = the largest Sales value for Jan, Feb, and March
Copyright © 2003, 2007, Oracle. All rights reserved.