Skip to Content
avatar image
Former Member

DP Run Interactive Macro / write result in past (read only)


I work with SCM7.0

In my planning view DP I didnot authorize to modify data in the past columns (/SAPAPO/MSDP_ADMIN).

Problem is the following one : I have a interactive macro in this planning view, which fullfill my sales (in the past).

It does not work anymore because cells in the past of my planning view cannot be modified.

1) If there a way to unlock my planning view at the beginning of the macro, and at the end, locked the cells back ?

2) Other solution : do you know a way how to block row only in the past ?

Row_input(0) has an effect in past and future...

Thanks a lot for your help


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 17, 2014 at 10:05 PM

    does the setting in PB for visible and input wont help?

    looking at your requirement, i understand it should be....

    so you don't allow input in the past and allow in future if required.

    sorry if i misunderstood your requirement.

    Pravin M

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Pravin,

      Thanks for your reply.

      I confirm that I blocked input in the past in the PB.

      But in the past, for one row, I need to allow input beacause my macro needs to write a result in the past.

      How can I manage to allow input for only 1 row in the past ?



  • avatar image
    Former Member
    Sep 26, 2014 at 10:46 AM

    Hi Pierre,

    Try to create a different Data View in the same Planning Book only for that Keyfigure Row whose data you want to edit in the past.

    Make the past data visible in your new Data View.Perform the calculation you want to do for this row with the help of a macro. Save the results.

    This new data for the KF row will reflect into your Detailed Data View row of this KF also.

    This is the functionality of the Livecache in APO.


    Nitish Panchal

    Add comment
    10|10000 characters needed characters exceeded