Skip to Content
author's profile photo Former Member
Former Member

DP Macro

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 ?


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 16, 2015 at 03:04 AM


    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.