Automate Run DM package for Context changes

[Former Member]

Hi BPC Experts,

  When I change the context, automatically run DM package with same context changes

Please anybody tell how it is possible?

[Former Member]

Very very gOOD

[former_member186338]

Hi,

Yes, you can do this using AFTER_CONTEXTCHANGE event and

But what is the business requirement? Looks strange...

Vadim

[Former Member]

Hi Vadim,

Thanks for your reply…

My requirement is in my EPM context only 2 dimensions are there remaining all are locked.

Process chain is DEFAULT_FORMULAS

My prompt selection is same as context dimensions

When I click macro button automatically run DM package for context changes, No need to select again in DM package selection.

I hope now you understand my Question...

[former_member186338]

"When I click macro button" doesn't mean that "When I change the context, automatically run DM package"!

You want to run DM using macro attached to the button and you want context selection to be passed to DM without user having to select values.

Simple way - to use default values in the DM advanced script:

PROMPT(SELECTINPUT,%TIME%,,"Select Time:","TIME",,1)

1 at the end will result in selection of context member.

Complex, but fully automated:

Vadim

[Former Member]

Hi Vadim,

   Thanks for correcting me..

I resolved this problem using VBA Script.

[former_member186338]

Then close the discussion.

Vadim