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

[Former Member]

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_member186338 · Accepted solution]

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

[Former Member · Accepted solution]

Vadim,

Thanks for the answer. The thing is that these templates are heavy enough to crash excel if opened in parallel. But let's say we lightened them and were able to open them all at once and launch a massive parallel refresh. How could we do that? As far as I know the wider VBA refresh/save options end at an active workbook level.

Thanks,

Ignacio

[former_member186338 · Accepted solution]

Do you understand my "multiple Excel instances" ? Only multiple Excel instances will run in parallel...

[former_member186338 · Accepted solution]

But anyway multiple Excel instances will use the same processor and will work slowly... May be it's better to create vba macro to execute refresh sequentially like open the file, refresh, save, close the file...

[Former Member · Accepted solution]

Thats what we currently have in place. The amount of executions and the size of the files makes it impossible to manage, thats why I'm wondering if there is a way to execute these excel files without opening them through VBA.

I've seen Java sripts calling excels, changin the value a particular cell and returning the result of the calculations. But I'm afraid Java won't be able to control EPM. What I want to know is if there is a wey through BPC or BW to open these files in the background and control EPM. Have you ever heard of something like this?

[former_member186338 · Accepted solution]

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

[Former Member · Accepted solution]

Thank you, your answers have been very helpful.