key figure values differing in data views

[Former Member]

Hi,

We have a strange issue is SAP APO.We have got two data views u201CAu201D and u201CBu201D of same planning book. In data view A, there are three key figures where e=c+d. The summation is done by a macro. "eu201D is a common key figure in both data views A and B. However after executing the macro we can observe values of u201Ceu201D in data view A but not in B.

After couple of days, there was some change in value of key figure u201Ccu201D. Now when macro was executed again , the value of u201Ceu201D reflected properly in both data view u201CAu201D and u201CBu201D.

Can somebody please provide why this might be happening?

BR,

Tushar

[aparna_ranganathan · Accepted solution]

Tushar

I think you must have created the macros at data view level. That is i think you have two macros (one for each data view) to calculate the value of e . You can check this by going to /n/sapapo/advm. Compare the macros in the data view and iam sure you will find something

Thanks

Aparna

[Former Member · Accepted solution]

Hello Aparna,

Thank you for the update. There is only one macro in data view A.

BR,

Tushar

[former_member187488]

Hello Tushar,

When you load data into a data view, the data is read from liveCache. So the data is already being saved to liveCache is a prerequisite if you want to read it into planning book.

If you run the macro in dataview A interactively, the calculated value will not be automatically saved to liveCache, unless you press SAVE button explicitly. If you load the data into dataview B without saving in dataview A, calculated result will not be loaded into dataview B, since it is not in liveCache yet.

But if the macro is run in background, save to liveCache is automatically performed.

You can make test on this.

Best Regards,

Ada

[sameer_karbotker]

Hi Tushar,

You can follow below steps for this issue.

1] Delete value of KF - ' E ' using Macro.

2] Run Consistency check on Planning Area. [/SAPAPO/TS_LCM_CONS_CHECK]

3] Execute Macro to calculate KF - E [E = C + D] in background and then check for value E in Data View A & B.

Pls note that you do not have Start Macro / Default Macro / Level Macro etc which would change value of E when you load data into Data View.

Hope this helps.

Regards,

Sameer