cancel
Showing results for 
Search instead for 
Did you mean: 

APO DP: Macro find out whether Key Figure is Fixed?

former_member243834
Active Participant
0 Kudos

Hi All,

I am working in APO DP 4.0.

Do you know any macro/statement which can check whether a key figure has been fixed manually in Demand Planning data view.

I need to check this fixing and when I copy other key figure to this fixed key figure then value should not be overwritten.

Thanks and Best Regards, Manoj

Accepted Solutions (1)

Accepted Solutions (1)

srinivas_krishnamoorthy
Active Contributor
0 Kudos

You should be able to do that by having the macro work on key figure's "F Fixed Values" instead of just values (which is the default). if a key figure is fixed you will get a >0 value for that key figure.

Message was edited by:

Srinivas Krishnamoorthy

srinivas_krishnamoorthy
Active Contributor
0 Kudos

corrected earlier msg

Message was edited by:

Srinivas Krishnamoorthy

former_member243834
Active Participant
0 Kudos

Hi Srinivas,

My requirement is that when user fixes that value of particular cell "either by double clicking or from context menu"...then this fixed value should not be changed when I copy another key figure to it. By your solution will I be able to achieve this?

Thanks and Best Regards, Manoj

former_member243834
Active Participant
0 Kudos

Hi Srinivas,

Excellent. Thanks a lot for the help.

Thanks and Best Regards, Manoj

Answers (0)