Skip to Content
avatar image
Former Member

key figure values differing in data views


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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 23, 2011 at 04:53 PM


    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



    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2011 at 07:24 AM

    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,


    Add comment
    10|10000 characters needed characters exceeded

    • 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.