APO DP Macrobuilder - setting row values from a column value in another row

[Former Member]

I am using APO DP V5 MacroBuilder.

I have a key figure row x with column n set to a value, for example 1000.

I need a macro statement to populate <u>all columns</u> of another key figure row y with the value from column n of key figure row x, ie all columns of row y should be populated with 1000.

Any ideas on how best to do this?

Thanks, Bob Austin

[Former Member · Accepted solution]

HI Bob.

How about:

Step 1: 1 Iteration

Row: y period n =

Row: x period n

Step 2: n Interations

Row: y period n+1 =

Row: y period n

Hope this helps.

Mark

[Former Member · Accepted solution]

Mark,

Thanks for this.

I think this covers future periods beyond period n, but what about periods before period n.

Regards,

Bob.

[Former Member · Accepted solution]

HI Bob.

Same approach could be used:

Step1: 1 Iteration.

Row y. Period z (1st period of your horizon) =

Row x. Period n

Step2: Iterations for total horizon - 1

Row y. Period z+1 =

Row y. Period z

Hope this helps.

Mark

[Former Member · Accepted solution]

Hi Bob.

Is there ever only going to be 1 value in Row x in your example?

If so a more robust approach would be to use the MAX function in Step 1.

M