Different disaggregation rules within the same key figure

[Former Member]

Hello All,

We need to apply different disaggregation rules within the different levels of the same key figure.

As an Example:

Key Figure: SALES VOLUME

Level1: Market

Level2: Segment

Level3: Model

We want to define such rules:

1- Disaggregate from Market Level to Segment Level using Historical Data

2- Disaggregate from Segment Level to Model Level using APODPNDANT (a key figure in which the input is supplied from business)

Does anybody know if this (defining two different rules within the different levels of the same key figure) is posssible?

Thanks in advance...

[former_member226466]

Hi Ergul,

I know that it is too late to ask. If in case you receive this message, can you please tell me how did you slove the problem you have asked here. In my case business has the same requirement.

thanks,

Neha

[Former Member]

Hi Ergul

Ideally its better to have APODPDANT to be the disaggregation KF at all levels

you can choose to manipulate the APODPDANT instead by making it an Editable Kf in the Planning book

To start with all levels can be based on the proportional KF calculation

By Loading the selections at the Segment to model level you can manually enter the values based on business input

you might need some macors to fix the totals and maybe to make sure the Sales volume is redisaggregated

i think its something that can be solved by a god business process and simple functionality in the way you see the data

[Former Member]

Ergul,

Within macros one can check for the 'level' (using function DET_LEVEL).

This may help.

Regards,

Bob Austin