on 11-22-2007 4:22 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bob,
I'm quite sure this could be done with advanced macros... did you have a try at this ?
Fabrice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.