Skip to Content
avatar image
Former Member

How to automate parallel execution of multiple EPM templates with SAP BPC?

Dear colleagues,

I'm facing an unusual requierement and I need your expert's opinnion to build a sound answer. I'm being asked to implement a feature, but I'm not sure if there is a way to do it using SAP BPC. Let me explain:

What I have:

  • A large number of excel files with heavy and complex calculations
  • EPM connections on the files used to retrieve initial data and save the final results of the calculations

What I need:

  • To execure a full EPM cycle (refresh, let excel calculate, then save) of each of the files
  • To do it automatically, being an initial selection of the dimension members the only action performed by the user

I'd like to know if any of you have faced a similar issue or have the knowledge of how to parally execute multiple EPM templates using SAP BPC or BW features.

Thanks in advance,

BPC 10.0

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 08, 2016 at 08:40 AM

    In general you can open multiple Excel instances and launch refresh in parallel... It depends on MS Office version used.

    Add comment
    10|10000 characters needed characters exceeded