Skip to Content

Scripting EPM BPC 10 HANA

Jun 13, 2017 at 03:46 PM


avatar image
Former Member

We are new users of BPC 10.0 with HANA. I am trying to script a BPC Clear, Load and Recalc.

How should I look at performing this? Can I use the FPMXLClient and DataManager macros? Or do I use Microsoft SSIS and create a custom package? Is there any documentation on calling BPC packages and passing parameters? Or do I start from scratch? Any examples?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Jun 13, 2017 at 03:56 PM

Please read standard help for BPC 10.0:

There are number of standard packages with chains to copy, move and load.

May be a best thing for you is to get some basic training in BPC NW.

P.S. "Can I use the FPMXLClient and DataManager macros?" - yes, but the naming is incorrect, using Excel EPM Add-in you can launch DM packages using chains. There are chains dedicated to run script logic code. Script logic in BPC NW is different compared to BPC MS!

Show 3 Share
10 |10000 characters needed characters left characters exceeded

P.S. It's also a good idea to add tag:

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

to this question!

Former Member

I found this chain that better answer my question

EPMAddInAutomation submitting parameters


If you want to pass parameters for data manager prompts you have to use: