Customizing Forecast Method

This method can handle all sorts of Calculated Measures, which can be different in different views. A Calculated Measure can be used to take, for example, an average of several alternative histories and use it as demand or several forecasts and simply copy it in as a final forecast.

However, using this method takes more CPU performance and allocates additional memory. This can also be complex to understand.

  1. Access the Favorite View Properties dialog box.
  2. On the Calculated Measures tab, define a Calculated Measure with a formula.
  3. Click New.
  4. Specify this information:
    Name
    Specify a name for this Calculated Measure.
    Description
    Optionally, provide a description for the Calculated Measure.
    Calculation Formula
    Specify the Calculation Formula. See About Measures.
    This is a sample Calculation Formula:
    IIF( EQ( 
ISNULL( OFFSET(-13,[Sales History]) ) + 
ISNULL( OFFSET(-12,[Sales History] ) ) + 
ISNULL( OFFSET(-11,[Sales History] ) ) , 
0) , 
AVERAGE( 3, OFFSET(-11, [Sales History]) ), 
SELF(-1) 
)
  5. Click OK.

Setting up Forecast Method

You can setup Forecast Method to copy the formula directly.

  1. Access Forecast Method Properties dialog box.
  2. On the Demand tab, select Measure by Column name.
  3. Specify the name of the Calculated Measure.
  4. Click OK.