How to automate parallel execution of multiple EPM templates with SAP BPC?
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,