on 09-17-2014 1:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.