Scripting EPM BPC 10 HANA

[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?

[former_member186338 · Accepted solution]

Please read standard help for BPC 10.0: https://help.sap.com/http.svc/rc/saphelp_bpc10_nw/10.0.23.0/en-US/a1/532226947c49a5b2e2bd32450cb2d1/...

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!

[former_member186338 · Accepted solution]

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

I found this chain that better answer my question

EPMAddInAutomation submitting parameters

https://archive.sap.com/discussions/message/13838811#13838811

[former_member186338 · Accepted solution]

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

https://archive.sap.com/documents/docs/DOC-32636