Aggregation Issue

[former_member503200]

I got a KF C, which is sum of 2 other KF A + KF B, I execute the sum macro in Weekly buckets and when I check the data in monthly view, the data getting aggregated correctly for KF A and B but not KF C. All the KF aggregation setting is same. Disagg based on APODPDANT and Time based disagg Proportional allocation. I checked using 9ASTORAGE also. Your input is greately appreciated.

thx

Jeff

[former_member503200]

Problem is resolved.

thx

Jeff

[former_member503200]

Ankur,

The reason we cannot schedule it in background is, the user they want to see the updated results immediately in weekly and monthly, so that they can change the No. as needed. Thx for your input.

thx

Jeff

[former_member503200]

Sorry, The No.'s got disturbed. Pls check my explanation.

thx

Jeff

[former_member503200]

Thx for all your input. Here I am giving more explanation.

I got a default macro which calculates as below in weekly view.

W51 W52 W1 W2 W3 W4 W5 W6

KF A : 10 10 1 7 7 3 12 10

KF B : 15 15 19 18 18 17 18 20

KFC A+B: 25 25 20 25 25 20 30 30

View 9STORAGE:

12/31

other W51 W52 W1 W2 W3 W4 W5 W6

weeks

KF A 10 10 1 7 7 3 12 10

KF B 15 15 19 18 18 17 10 8

KF C : 2 25 25 7 20 25 25 20 22 19

MONTHLY VIEW:

12/07 01/08 02/08

KF A : 25 30 20

KF B : 30 82 48

KF C: 59 102 74

Monthly View with 9ASTORAGE:

12/31

other W51 W52 1/1 1/7 1/14 1/21 1/28 02/01

weeks

KF A : 10 10 1 7 7 3 12 6

KF B : 15 15 19 18 18 17 10 8

KF C: 5 25 25 4 16 25 25 20 16 59 DEC / JAN 102 /

The agg is happening correctly from weekly to monthly. But the problem is, in a selection profile, the user do some adj in weekly view and for some SKU’s in monthly level. In weekly view we got a default macro, so that they can check the total immediately. When they do adj for other SKU’s in monthly level, we got a executable macro, which they execute at monthly level for all SKU’s in selection. Which causes changes to the SKU’s they did adj in weekly level.( check the No. for 01/08, in monthly level it should be 112 instead of 102 ) As this is a promotion adj, the SKU changes every month, its not possible to execute the macro separately. Is there any way, that I can execute the macro in weekly level and monthly level and doesn’t change the No’s in either of the view. I tried with the option “Auto Column adj in macro”. It doesn’t work. Any help is greatly appreciated.

[srinivas_krishnamoorthy]

Do a little experiment. Just have numbers in weeks that are fully contained in the month and see if they are aggregating correctly at monthly level. Have zeroes in the weeks that cross over months, just as the first scenario. In the second scenario, just have numbers in the weeks that cross over months. Can you confirm if the summation is not happening in both the scenarios ?

[Former Member]

Can you zero out any entries for KF C in the monthly buckets before running the job in the weekly book. If there are preexisting proportions the Aggregation will not be based on proportional settings

can you give an example of the weeks, numbers and what the months and numbers are?

[Former Member]

Hi

As harish has rightly pointed out zeroing out the KF C is important to get the desired results. Also the following points need to be taken care of.

Macro execution in foreground sometimes gives erroneous results if it is not run at suitable drill downs. Reason might be large number of CVC's. To avoid this, create a background job of macro and schedule it at periods of minimal planning book access. Another advantage of doing this activity at background it that you have the option of selecting suitable detailing of macro execution viz. customer and material.

Once this sheduled activity gets over the aggregation should give perfect results

Do update us if doing this helps.

Regards

Ankur