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

APO DP - copying of a key figure while respecting fixed values

I am using APO DP V5.

I have a key figure x in which I have some values which are fixed.

I want to have a macro which sets key figure x to key figure y, but respects any fixed values.

For example, suppose I have values for key figure x as follows:

10, 10, 20 (fixed), 10, 5, 10

And for key figure y, I have values as follows:

12, 12, 12, 15, 15, 15

I want result of key figure x = key figure y to be:

12, 12, 20 (fixed), 15, 15, 15

How can I achieve this result?

Thanks, Bob Austin, Atos Origin

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 23, 2007 at 01:41 PM

    Hi Bob,

    There is a function in Macro that you can use to check if a keyfigure is fixed. The following explains how to use the function:

    IS_FIXED()

    Syntax

    IS_FIXED( Key Figure )

    Key Figure: Row, column, or cell element (data source = row attributes)

    Description

    The IS_FIXED function returns the value 1 if the cell is completely fixed. (The column results from the current step iteration; the row is determined by the Key Figure parameter.) If the cell is not fixed or partially fixed, the return value is 0. The function is not available if the compatibility mode is activated for the macro book.

    Now you can write a macro some thing like this..

    Step 1: XXX iterations(From Date ; To Date)

    If Is Fixed(X Key Figure) = 0

    X Keyfigure = Y Keyfigure

    End If.

    X keyfigure and y Keyfigure are taken from the example you have given for better understanding.

    Best Regards

    Raghu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 22, 2007 at 06:52 PM

    While creating a Macro you can always create a result macro based Fixed Portion of a Key Figure. Under row attributes, you can check Fixed Value while developing the macro. (There have been similar queries in this very forum already that you may want to search)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 04:27 PM

    Hi Bob,

    I'm quite sure this could be done with advanced macros... did you have a try at this ?

    Fabrice

    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.