Skip to Content
0
Former Member
Jul 30, 2008 at 01:59 PM

Facing Problem with the Disaggregation Logic

52 Views

Hi,

I am facing problem with the Time based Disaggregation logic. I am trying to Enter some value on a yearly basis and when I change the time period to Monthly its not disaggregating based on the Historical disaggregation logic.

Here is my requirement:

I want that my yearly annual Sale Target should get split to monthly based on my historic data (disaggregation).

But every time its disaggregate based on Fixed Proportions but not according to detail proportions.

I try out the below option:

1) I change the calculation type for that Key Figure to P=Based on Different Key Figure (Historic date) and Time Based Disaggregation to K=based on another key figure(Historic data).

2) I even try out with the Calculation type S and Time based Disaggregation to P and then Calculate Proportional Factors and provided Key figure for Historic data and date from the past 1yr.

I try out all the permutation and combination with Calculation type and Time based Disaggregation. But every time its disaggregated equally.

Please do let me know where I am getting wrong and what is the solution for my problem.

Thanks & Regards,

Amit