Skip to Content
0

Refresh EPM Input sheet in Background

Mar 13, 2017 at 04:31 AM

268

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

9 Answers

Vadim Kalinin Mar 13, 2017 at 07:11 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 17, 2017 at 09:40 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 17, 2017 at 12:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 20, 2017 at 03:36 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 20, 2017 at 06:55 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 20, 2017 at 07:34 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

"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 :)

0
avatar image
Former Member Apr 05, 2017 at 09:38 AM
0

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 ......

Show 1 Share
10 |10000 characters needed characters left characters exceeded

"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!

0
Amirkhan Kozhageldiyev Jan 17 at 06:41 AM
0

Hi Uma

Did you find any solution? We are having same issue

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0
Amirkhan Kozhageldiyev Jan 17 at 09:23 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0