Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member

Unfortunately your idea is not possible. EPM addin execute code in foreground. No magic. The only thing you can do is to use multiple pc's to perform refresh

P.S. And there is no difference between JavaScript or VBA to start refresh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question