DP Macro

[Former Member]

Hello ,

I am creating a DP Macro, I have this below questions.

If User is on Drill down level at Location, he can change a value for particular keyfig.

But while Save, it has to be checked that Total value remains same even after change.

It means - User can shuffle the values for Location, Increase (or) decrease but Total should remains the same.

How can I check this in Macro ?

Thanx.

[former_member187488 · Accepted solution]

Hi,

It would be very hard (or impossible?) to achieve this by macro, since macro step works on one planning object of certain level each time. It does not have interaction with other planning objects and other planning levels.

You can use fixing functionality, that is, fix the total row. With this, if a detailed row is changed, other detailed rows will be adjusted to keep the total value unchanged.

BR, Ada

[Former Member · Accepted solution]

I have tried with Fix_Calc() macro syntax, it's not doing anything here.

Do we have any prerequisites to use this ?

My Keyfigure is not maintained as Fixable yet but it has Fixed Keyfigure at infoobject level.

This Keyfigure will also take some input from external system.

What difference it makes between Fixable Keyfigure & Fixed Keyfigure at infoobject ?

Can i Create a Keyfigure as Fixable Keyfigure & Fix the Row by using some Macro syntax ?

Thanx.

[former_member187488 · Accepted solution]

Hi,

It is not useful to have fixed key figure at info object level. The key figure should be a fixable key figure in planning area configuration.

Do we have any prerequisites to use this ?

-> Key figure should be fixable. You should fix the total row first.

My Keyfigure is not maintained as Fixable yet but it has Fixed Keyfigure at infoobject level.

-> No use.

What difference it makes between Fixable Keyfigure & Fixed Keyfigure at infoobject ?

-> Fixable key figure can really be "fixed" in liveCache. Fixed key figure at infoobject level can be used in extraction. But it is not relevant at all for fixing functionality in APO planning book.

Can i Create a Keyfigure as Fixable Keyfigure & Fix the Row by using some Macro syntax ?
-> Yes.

BR, Ada