Trigger Macro from one Planning Book for Another Planning Book

[Former Member]

Hi All,

How to trigger the Macro of another planning book from one plannig book,data view.

If this Macro execution is to be done with some characteristics change dynamically , how it can be controlled ? Pop up screen for this characteristics selection also can be done , how to do it?

Regards

Aniruddha

[Former Member]

Hey Aniruddha,

From what I understand, your requirement is to use a particular KF value in a data view, whose value is pre calculated in a different data view.

As everyone has already said, this is not possible.

The workaround could be to calculate the value of this KF in your existing data view only. As in, why dont you add the necessary KF's required to calculate this value and hide them. You can then precalculate this KF and then proced as you had planned. From a user perspective, as the KF is hidden, the user will be completely oblivious to this.

I may be totaly missing what the issue is

Cheers!

Abhi

[Former Member]

Hi,

Triggering a macro from one planning book to another is not possible.

But your second question on dynamically running a macro based on some input characteristics can be achieved using LAYOUTVARIABLE_SET () function. This function can be used to capture the user input. However it is adviced to take the input directly from planning table, rather than through users if it involved characteristics values. Lets say you want to capture the current planning object selected in the planning table and trigger a macro only when its material, then you can write the macro as follows,

LAYOUTVARIABLE_SET( "PRODUCT" ; ACT_PLOB )

Now the value of PLOB is stored in product (ex 9AMATNR)

Make a if statement against this product and trigger your macro.

Thanks,

Rajesh Manoharan

Edited by: RAJESH MANOHARAN on Nov 10, 2009 10:48 AM

[Former Member]

Hi Aniruddha,

In general, the macros will be assigned to the planning book/Data view.

So, you it is advisable to use macro from the planning book where it is

assigned.

If you want to use the macro for some other planning book, you need to

copy/assign the macro to the planning book using Macro workbench

using the option IMPORT MACROS.

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi,

One of the KF is common in the both Planing Book / Data view. In one planning book , the the KF is result of Some macro operations & Other Planning book /data view that KF is being used to calculate other calculations using start macro, therefore your option could not be done.

Best Regards

Aniruddha

[Former Member]

Hi Biswas,

As Senthil said you have to create macro for specific dataview.

KF which you are saying sholud change dynamically then create a auxillary KF and use it.

If you are having different macro's for the same auxillary KF also it will not be a problem.

You can view that differently in different data views.

Hope this serves your problem.

Regards,

Kishore Reddy.