Issue with Key Figure Aggregation

[Former Member]

Hi All,

We have a key figure A, which is being calculated for different materials, in the planning book correct key figure value is displayed for each material but while displaying for group of materials the key figure does not sum up correctly. Please me know what exactly to be done for correcting this.

[Former Member]

Hi Sri,

pls check the macro related this planning book./sapapo/advm for macro builder.

/sapapo/msdp_admin -> right click our PA and select change -> select key figure aggregation tab and provide the details.

maintain the settings for aggregation process in Planning Area level.change the calculation type insted of S put P.

provide the APODPDANT key figure in time based disaggregation tab.

maintain header setings in IDP for this perticular Planning Book

Regards,

Pullaiah

[Former Member]

Hi All,

Thanks for all you help!

I have a question, it appears in this issue all the key figures are being calculated at the "Details All" level, so its going to be a big task of changing the macros in this planning book. Is there a possibility of populating the value of key figure from "Details All" level to "Total Level" without changing as the data is extracted from this level

or

Mapping the data to be extracted from "Details All" level to the output cube for this key figure, if this can be done, where exactly do I need to change the route.

[Former Member]

Hi Sri,

Too little information to give suggestions.

Check the following:

1. If you have any macros that ave logic that's conflicting

2. Check if you assigned the right aggregation type.

What version are you in? Check if the note 365353 is helpful. What is the aggregation type?

Give us an example of your issue and we will try to help you.

[Former Member]

Hi,

We are using SCM 5.0, we are using a macro for calculating a key figure.

Can you please help me with the steps on how to check the aggregation type.

The Problem:

The key figure A is common to materials 1, 2

1) Scenario 1: Planning book Display for Material 1

Jan 09 Feb 09 Mar09

Keyfigure A 2 3 5

2) Scenario 2: Planning book Display for Material 3

Jan 09 Feb 09 Mar09

Keyfigure A 3 4 5

3) Scenario 3: Planning book Display for Materials 1 & 2

It should display the sum of key figure for respective materials for those months as shown above but its showing completely different values

Jan 09 Feb 09 Mar09

Keyfigure A 9 12 17

[Former Member]

Please go to DP Administration workbench, double click on your Planning area, go to Keyfigure tab>click on details-> check if value 1 (Aggregate at group level, retain value at detail level) is maintained in the Aggregation column for that keyfigure.

And what is that Keyfigure you are having this issue. I had same issue with Safety stock keyfigure which was run by a macro

[Former Member]

Hi Sri,

As Sai said, please check the disaggregation type of the key figure from planning area in transaction /n/sapapo/msdp_admin. I can't guess of any aggregation type that sums 2 and 3 as 9.

A couple of things:

1. make sure that the numbers at the detailed ( material 1 and 2) level is same as the UOM you see at the aggregate level.

2. Make sure that you are loading data for only those two materials 1 and 2. If you have three materials loaded and you are trying to display the just 2 out of 3 materials using the details all (filter), it dsiplays the values at the detail level for materials 1 and 2 as usual but still show the total as the total of all 3 materials not just the two you drilled down (filter).

[Former Member]

Hi,

Actually Im working with APO DP, also the in that the Calc type is given as 'S' and Time based Disagg is used as 'P' for the key figure.

I have a question how to check whether a macro is being used for this calculation.

[Former Member]

Hi,

The key figure we are using is a custom key figure, is there any way to test if at all there is a macro for this or any other thing which is influencing this calculation.

[Former Member]

Hi Sri,

Go to the transaction /sapapo/advm. Here, you can go into your planning book/data view and see what's the macros. You have to check in each macro if the key figure is included.

Another short cut is in planning book maintenance, /sapapo/edp8b, go to key figures tab after the data view tab and see if the key figure in the left part of the window has a couple of wheels like icon. That shows the keyfigure is used in macro.

[Former Member]

Please go to macro workbench, select your planning book-->dataview -->macro (that calculates the keyfigure), double click on the macro and check if "All Planning Objects" radio button is checked in, if not please check it..save and activate it and run the macro again. you should see the aggregated value in the totals

[Former Member]

Hi,

I have made one observation, in the Planning Book(Transaction /SAPAPO/SDP94) after loading the data in to the planning book, if the header information settings for the Productis set to "Total" its giving me wrong values but, if we select "Details All" its giving me correct values.

[Former Member]

Hi,

This last observation of yours suggests that there is probably a macro in the data view which has execution defined as level change.

Could you check and confirm this.

Regards

Ankur

[Former Member]

Hi,

I see there are three Macros at level change and they are same as macros that at Start

[Former Member]

Hi All,

It appears the issue is with the execution of macros at the Total display level is causing the issue.

Could anyone help me with the addition of Macro execution at this level for correct calculation of the key figure or any alternate way of saving the values at "Details All " at the "Total" level

[Former Member]

Have you checked if "All Planning Objects" radio button is checked in the macro as suggested in my previous reply

[Former Member]

Hi,

I have an issue where the key figure where after execution of macros in the /SAPAPO/SDP94 transaction shows correct values at total level, but after the values are not getting saved here.its showing me wrong values after we login to SDP94 transaction after logging in again.