In macro, can I initial one keyfigure and insert some value that kefigure??

[Former Member]

Hi gurus.

I need solution about macro.

I must make macro that has below steps.

1.Initialize Level2(keyfigures).

2.And Copy data from Level1 to Level2.

That's all.

I tried to make that macro.

But I had found that one keyfigure can changed one time in one macro.

So the result of upper macro,

initialize did not excute but only Level1 copy had excuted.

It is not problem if I make two macros.(One-Initialize, Two-Copy)

But I must make it by one macro.

Can you help me?

Thanks.

[Former Member]

Hi,

By initiliazing the key figure, you mean that you need to set the key figure value = 0 at that level of characteristic. Pls correct me if I am wrong.

My understanding of the issue is as follows:

There are 2 characteristics.

Eg Product and Channel.

Take product = XYZ and Channel = 10 & 20.

The requirement is as follows:

1. Intialize (zero) the Office level forecast for product = XYZ at Channel = 10 (level 1)

2. Copy Base line forecast at channel 10 (level 1) for Product XYZ to Office level forecast at channel 10 level.

This has to be done thru an executable macro.

You can try the following.

1st Macro

Macro name: Drill down at channel level

Step: Drill down (1 iteration: M2009.03; M2009.03)

Action box as a container

DRILL_DOWN( 'Characteristic infoobject name' )

2nd Macro

Macro name: Initialize & copy Office level forecast at channel 10 (lvl 1)

Step1: Initialize (1 iteration: M2009.03; M2009.03)

Condition: IF

Control statement: ACT_IOBJNM_VALUE( 'Characteristic info object name' ) = 'Characteristic infoobject level value'

Result row: OFFICE_FCST (From: M2009.03) =

0

ENDIF

Step 2: Copy level 1 Baseline forecast

Condition: IF

Control statement: ACT_IOBJNM_VALUE( 'Characteristic info object name' ) = 'Characteristic infoobject level value'

Result row: OFFICE_FCST (From: M2009.03) =

BASELINE_FCST (From: M2009.03)

ENDIF

Include both these above macros in a collective macro.

I have checked in my planning books, and it is working. (Provided I have understood your requirement correctly)

Let me know if this works in your case.

Warm regds,

Ashutosh

[Former Member]

Thanks Ashutosh.

I appreciate your reaction.

But 'Initialize' means that macro change mode's setted by 'initialization'.

Not means zero.

It must be setted for using calculation type 'I' in the Planning Area.

Would you know, how to solve them?

[Former Member]

Hi,

When the macro for intiliazing key figure is executed, please ensure that the macro is executed at detail level of level 1. If the macro is executed at aggregate level, please have a drill down at level 1 and then initialize the key figure.

Further, it would be better if you provide me the macro that is developed currently, so I can help you properly.

Warm regds,

Ashutosh

[Former Member]

Thanks Ashutosh.

I appreciate your reaction.

Macros that I have problems are bleow.

1.L1 Initialization

1st Step : ( 1 Iterations : M 2009.03; M 2009.03 )

ACTION : ( 6 Iterations : M 2009.03; M 2009.03 )

Row: OFFICE_FCST(L1) ( Frm M 2009.03 ) = Initial

2.BLF->L1 COPY

New step : ( 1 Iterations : M 2009.03; M 2009.03 )

Row: OFFICE_FCST(L1) ( Frm M 2009.03 ) =

Row: BASELINE_FCST ( Frm M 2009.03 )

I make collective macro include above two macros.

And Initialization macro setted by certain level(Level1).

But when I execute collective macro, initialization is not excute only 'OFFICE_FCST(L1) = BASELINE_FCST' is executed.

When I execute above two macros step by steps. They don't have problem.

But collective macro is not work.

How to solve them??

[Former Member]

Hello

Please create a collective macro, which includes the 2 macros that are working correctly. If user wants to execute this macro in interactive planning, you can assign this macro a button. User has to just click the button and the macro will be executed.

Hope this helps

Ashutosh

[Former Member]

Thanks Ashutosh.

Collective macro can excute multi macros by one button.

But the result is same.

Initialize did not excute but only Level1 copy had excuted.

Do you know another way?

Edited by: Jin Choi on Mar 4, 2009 10:56 AM