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.
Tagged:
0