Automate Package launch in save data

[former_member200880]

Dear all

we wanted a package to run automatically once clicking on save data in an input sheet.

we have made this thru vb code below

0----------------------------

Application.Run "EPMExecuteAPI", "SaveAndRefreshWorksheetData"

EPM.DataManagerRunPackage "testPackage", "foldername", ""

------------

the package launches after saving data, but it shows prompt of finish button to click on.

but for the end users this prompt shouldn't be required. they want this package to trigger automatically after clicking save data.

Any help is much more appreciated.

I have removed all the prompts in package already. But still the finish prompt used to come.

thanks

Prasad

[former_member186338 · Accepted solution]

Hi Prasad,

You have 2 options:

1. Move logic from this package to default.lgf

2. Implement complex VBA solution: How to Call a BPC Data Manager Package from VB | SCN

Vadim

[former_member200880 · Accepted solution]

hi Vadim

thanks for your reply.

moving logic to default logic is not possible.

2nd option has very complex vba code involved.

We just wanted to execute package after posting data.. The package launces from vba code well.

but we just dont want the prompt to click on finish button which is followed by packag run.

any other go?

thanks

prasad

[former_member186338 · Accepted solution]

Sorry,

But I mentioned only 2 options - not 3 or more

If "just dont want the prompt to click on finish button" then - option 2. The code can be reduced, because you don't need to pass parameters, but the rest have to be done.

Vadim