Skip to Content

Refresh EPM Input sheet in Background

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Mar 13, 2017 at 07:11 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 09:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 17, 2017 at 12:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 03:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 06:55 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20, 2017 at 07:34 AM

    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.

    Add comment
    10|10000 characters needed 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 :)

  • Apr 05, 2017 at 09:38 AM

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

    Add comment
    10|10000 characters needed 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!

  • Jan 17 at 06:41 AM

    Hi Uma

    Did you find any solution? We are having same issue

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 17 at 09:23 AM

    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

    Add comment
    10|10000 characters needed 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.