Wednesday, November 17, 2010

Demantra 7.3: Engine split based on series

Whas is NEW ?:
Demantra 7.3 has come up with quite few features which customers have been wishing to see. One of these is ability to split statistical forecast which generated at aggregated level to split down to lowest level based on user defined/controlled proportions. Prior to 7.3 this split was always based on historical proportions and there was no workaround for it. These historical proportions were calculated based on every product and location combinations historical monthly sales averages using proport procedure. Split by series option allows user to pick a series which dictates weights for dis-aggregation of baseline forecast.

How we USE it?
1. Define a new series with server expression, the server expression gets used in weight calculation.
2. Using Business modeler setup parameter: ENGINE > PROPORT tab > parameter name "ProportionSeries" shall be populated with the internal name of the above series.
3. Select combinations/population to use SPLIT MECHANISM by using series "Engine Proportion Method" in a worksheet. The series has two dropdown values, Matrix Based Proportions which is the default and Series Based Proportions which is the value required for series based split.

No comments:

Perspectives on Managing through Difficult Times