You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Aggregation and disaggregation

Summary:

Our client has scenarios where forecast adjustments are made a different levels. For example- Adjustment being done at Customer and SKU level, Adjustments being done at SKU level, Adjustment being done at category/sub category level.

If they are doing adjustment at customer level, it get aggregated at SKU level. If they zero out the adjusted number at SKU level, it will also make adjustment being done at customer level to Zero.

How do we ensure the aggregation and disaggregation works but adjustment at each level shall be recorded as well without changing lower level adjustment to zero if higher level is adjusted to zero. Do we need to create custom measures at each level with their own aggregation and disaggregation rules.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!