Skip to Content
Feb 05, 2019 at 01:45 AM

Full automation using EPMAddinAutomation


Hi all,

Could you kindly tell me about the automation of end-user task?

My company is running SAP BPC 10.1 for NetWeaver Standard edition.

Currently, many end-users have to import their flat files into BPC manually so they annoyed. We would like to completely automate importing their files into BPC by the most easiest and the earliest way.

To achieve that, I believe one option is to utilize VBA, especially the functions FPMXL.EPMAddinAutomation and FPMXL.EPMAddinDMAutomation.

I'm thinking of creating VBA to realize it then running it with windows job scheduler.

I searched for a lot but I couldn't find enough information.. Let me ask two questions below.

Is there any documentation about this?

Is it possible to automate user task completely by excel VBA? Or a few clicks will be remained after implementing VBA?

Thank you in advance.