Refresh EPM Input sheet in Background

[UmaArjunan]

BPC Experts,

Is it possible to refresh EPM input sheet and the save data in Background ?

Please provide some possible way to achieve this business requirement.

Best Regards,

Uma

[amirkhankozhageldiev]

I have only one idea to solve this issue by abap programming using OLE Automation

Steps:

1. Create ole Excel object

2. Make connection (here I have problem, I don't know how to make connection with BPC model)

3. Open in background and call macros with Epm.Refresh and Epm.Save

[former_member186338]

The question author is not interested in answers anymore (last update - April 2017). And his question was a mix of different things including strange DM package.

I will not answer here - please open a new question and describe a full scenario of your case.

[amirkhankozhageldiev]

Hi Uma

Did you find any solution? We are having same issue

[former_member186338]

Solution for what? Please ask a new question and provide your requirements.

[amirkhankozhageldiev]

Hi Vadim!

I think Uma wrote the question clear about possibility to refresh and save Epm report or input schedule in background mode. And he gave scenario as good example, so if I ask new question it will be same as Uma's

[UmaArjunan]

DM is just used to capture the user selection to refresh those input templates , but agreed DM is not required , just an interface required to capture category selection wat user needs to refresh for .. Based on that all input sheets should be refreshed and saved . Pl. guide us through VBA steps for this requirement ......

[former_member186338]

"DM is just used to capture the user selection to refresh those input templates , but agreed DM is not required , just an interface required to capture category selection wat user needs to refresh for" - sorry, but I am unable to understand the DM role!

Please clearly explain the step by step scenario with all user actions and screenshots attached. We can spend endless time discussing theoretical things!

[UmaArjunan]

there is no calculations in the DM Package , it takes input from user ( Front end ) and to pass this to excel specific input sheet to replace the specific cell with user input selections and trigger as batch job. so the refresh and save can happen after the new selections

Excel calculations are more likely changeable. So not all the excel calculations are converted to custom logic BADI as involves transport for every formula changes. I m trying to link the excel object with the user selections.

In a way I m trying to skip " opening the specific input template " by selecting different time and category and trying to achieve by passing from DMP, as there are many input sheets to refresh and save. its a bit challenging and looking for some workaround solution.

[former_member186338]

"there is no calculations in the DM Package" - what do you mean by this statement??????

What this DM is used for??

Can you show advanced script of this DM package?

P.S. DM packages are always doing something with data in the models. But DM packages do nothing with EPM reports 🙂

[former_member186338]

There is one issue in your scenario:

The DM package is running in background (asynchronously) - you will not get trigger event when it's finished!

Looks like you are trying to combine calculations using DM package and Excel calculations. Try to calculate everything using DM (with script or custom logic badi)

[UmaArjunan]

sorry In a way i m trying to put everything together to automate this . Because this input sheet refresh should happen as when the user runs a DMP package selects with a different time and category. Steps are :

1. User selects time and category in the DMP selection

2. This input should be taken to open a specific input sheet , with the selected time and category

3. Refresh the input sheet

4. Save the data

5. Close the input sheet

From step 2 to step5 should not be visible to user , Step 1 is used an input passed from DMP to trigger step 2 till step 5

Step 2 should run in the background or scheduled as a job.

[former_member186338]

Sorry, but looks like you are mixing everything 🙂

Refresh

Save

Running DM packages

...

You have to provide VERY clear step by step scenario!

In general everything can be performed using VBA

[UmaArjunan]

Hi Vadim ,

The scenario is like this :

In the front end using EPM excel , user will refresh an input template based on time and category and saves the data to the BPC cube. This input template has few calculations, once the refresh is clicked , computation will happen for each selected period and category and data is saved in the BPC . this is manual

Since there are lot of Input sheets to refresh and save, business wants to automate this process , so the refresh and save should happen in the background .

User runs a Data Manager Package by selecting time and cateogry,

this input is used to open the input sheet to refresh and save the data to the BPC cube.

thanks

[former_member186338]

Please explain the scenario you want to achieve! Not clear what do you mean by "in Background"!