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

Keyfigure fixing at aggregate level

HI,

I am using APO V4,

1. I am planning to fix my keyfigure only at aggregate level, My keyfigure is open at all levels like plant or material group or material, i can enter the data at any point manually. but when come to keyfigure fixing, i want to fix the keyfigure only at aggregate level, i mean if the keyfigure is at material level i need fix, any other level it should not allow me to fix.

I was thinking for a drill down macro, but my keyfigure should open at all levels irrespective of keyfigure fixing, is it manageable any how that keyfigure can only be fixed at material level?

2. this is a different issue from above, i have fixed the keyfigure for a month, after that i had run a copy macro to the fixed key figure, but the fixed values are overwritten once the copy job is completed, and when i check in the planning book, it is visible as fixed agian. do i need to have any macro specific setting for this during the copy macro?

Thanks in Advance

ARUN R Y

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2008 at 05:15 PM

    Hi Arun,

    I think you misunderstood the concept of fixing. When drilled down, fixing allows you to fix either total or one or more details rows to manage your numbers. See [Fixing Key Figure Values|http://help.sap.com/saphelp_scm50/helpdata/en/02/7650c7353611d398290000e8a49608/frameset.htm] for details on how it works. You may be aware of it.

    Fixing is property of a key figure, you can either make it fixable or not but as far as I know you can not fix total level and let loose the details or vice versa.

    Also to your second point, fixing does not avoid overwrite while copying. You can use the function IS_FIXED() in your copy macro to check if the key figure is fixed and say copy only if the Key figure is not fixed.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Venkat,

      For copying of macro, i found the solution my self,

      if suppose the fixed cells should not overwrite while copying means, in the macro it slef, we have a option at result level RETAIN EXISTING VALUES, this will help us to aviod overwriting of the values.

      but my first issue still alive, any how thanks for efforts

      ARUN R Y

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2008 at 12:06 PM

    Hi Arun,

    We had a similar requirement wherein the aggregate value should remain the same but the drill down's should be adjusted with reference KF.

    1. You can control this by designing a default macro which will have FIXCALC() function. You can define the controlling KF as an argument in the FIXCALC function. I'm sure your scenario can be addressed.

    2. Macro execution date ranges can be controlled and this should be used for updation during any copy job.

    Is this what you are looking for. If yes, then i can provide specifics.

    Respond if further help needed

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ankur,

      I have the exact same requirement "aggregate value should remain the same but the drill down's should be adjusted with reference KF". Can you please provide the macro steps and the KF settings for forecast and reference KF?

      This will resolve my issue!

  • author's profile photo Former Member
    Former Member
    Posted on Feb 12, 2009 at 09:49 AM

    Thanks for all your help

    Add a comment
    10|10000 characters needed characters exceeded

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.