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

[Former Member]

Hello,

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

Pierre

[Former Member]

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.

Regards,

Nitish Panchal

[Former Member]

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

[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 ?

Thanks

Pierre