APO DP SCM 5.0 Disaggregation issue + performance guide

[Former Member]

Hi All,

I am again facing a u201Dsmallu201D disaggregation calculation issue. What I am trying to do is to calculate Corrected sales history to the most detailed level through disaggregation.

KF1: Sales history

KF2: Correction

KF3: Corrected Sales history

Situation:

The calculation is performed via background job:

Aggregation level:

Country

Sales org.

Product

Selection:

Country: 001

Sales org: 2000

Product: 12 & 13

I use macro for the calculation:

Start

Step1: KF3 = initial

Step2: KF3 (redisaggregation) = KF1 (Values) u2013 KF2 (Values)

End

Planning Area:

KF3: I (if initial, based on a another keyfigure) u2013 KF1 , Time based disaggregation (not relevant)

How can I get KF1 based disaggregation for KF3? Is it even possible with the above solution or should I come up with a totally different approach to this? Calculating in the most detailed level is not possible because the system canu2019t handle so many CVCu2019s. Although I kind of wander that, the system is almost a beast and it can only calculate 50000 CVCu2019s in a 5 hour? Any suggestions on this one also?

Thanks in advance,

Juha

[m_manimaran · Accepted solution]

Hi Juha,

I assume, you enter the correction at the aggregated level.

Please try this.

In your planning area set KF3: P (based on a another keyfigure) u2013 KF1

You use the simple macro

KF3 = KF1 (Values) u2013 KF2 (Values)

and you execute the macro at aggregated level in background. (hope this will reduce the number of CVCs.

While coming back to planning book, anyway the newly calculated - aggregate level- KF3 will be disaggregated as per the planning area setting, i.e, based on KF1

Hope this will help you.

Regards,

Manimaran M.

[Former Member · Accepted solution]

Hi Manimaran and thank you for your quick reply,

I did change the keyfigure disaggregation rule but it did not resolve the problem. I unfortunately still get wrong values for the detailed level. As a side question does APO disaggregate automatically during background job (mass processing)? As I had this kind of problem before and one kind person instructed me to use disaggregation inside a macro calculation. It did work then but this time around the macro calculation is a bit different and now the same settings does not apply.

Any ideas on how to go forward with this?

Best regards,

Juha

[m_manimaran · Accepted solution]

Hi Juha,

Can you give us some example figures you got in your scenario?

Like:

Sales: At aggregation level 2000

At disaggregated level:

prod A: 1500

prod B: 500

Correction entered at aggregated level: 1000

So corrected Sales: at aggregated level: 1000 (using macro - run at aggregated level)

At disaggregated level

Prod A: 750

prod B: 250

If the scenario works fine, you have to get the above results..right?

Let me know, if my understanding is correct.

Regards,

Manimaran M.

Edited by: M Manimaran on Aug 12, 2011 11:09 AM

[Former Member · Accepted solution]

Hi Manimaran,

I just tested your suggestion and the results are:

Sales history KF1:

SUM: 1000

Product: A: 750

Product: B: 250

Product A for Customer 1: 325

Product A for Customer 2: 325

Product B for Customer 1: 125

Product B for Customer 2: 125

Correction KF2:

SUM: 1000 (automatically split via disaggregation, this number is inserted in planning view and after this the background job is executed)

Product: A: 500

Product: B: 500

Product A for Customer 1: 250

Product A for Customer 2: 250

Product B for Customer 1: 250

Product B for Customer 2: 250

Corrected Sales history KF3 (after background job and disaggregation):

SUM: 2000

Product: A: 1250

Product: B: 750

Product A for Customer 1: 625

Product A for Customer 2: 625

Product B for Customer 1: 375

Product B for Customer 2: 375

As I analyzed this it seems like it is disaggregating it evenly? I have checked that the planning area settings are:

KF3: P - (based on a keyfigure) Keyfigure: KF1

so on that basis there should be no even disaggregation. I also tried with different aggregation level settings but the results are the same.

BR,

Juha

Edited by: Juha Pajarinen on Aug 12, 2011 11:37 AM

[m_manimaran · Accepted solution]

Hi Juha,

From your results, the disaggregation happens correctly.

Please see the calculated quantity at Corrected Sales history KF3 at product level. It has been disaggregated as 3:1 and not proportionally.

At the customer level also it disaggregated correctly as 1:1, because at Sales history KF1 level also it is 1:1.

What is the specific point you are looking into?

Regards,

Manimaran M.

[Former Member · Accepted solution]

Hi Manimaran,

How come I was so blind, now it works perfectly. I really don't know what is wrong with my previous test data as it still gives weird results but the above example gives perfect results. I investigate this more and get back to you if something doesn't add up. For now though the disaggregation works like it should.

Thank you for your assistance and help.

BR,

Juha