Skip to Content

can i get database fields from BPC in excel via VBA

Nov 01, 2016 at 02:44 PM


avatar image

trying to figure out a way where I can get the database directly instead of creating the report in EPM.

for eg:-

I need profit center and projects into row axis and then revenue into the column axis.

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

2 Answers

Aecorsoft Inc Feb 08, 2017 at 09:12 PM

There are multiple ways to do this. If you don't mind SAPGUI, you can use the data provider from SAPGUI to achieve this. Check the SCN blogs here and here.

Notice SAPGUI is 32bit only though. You need to use 32bit Excel. If you want to avoid custom programming, you will have to consider third party integration solutions.

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

Sorry, but how it's related to access to BPC data?


My interpretation is the person does not want to use EPM add-in to query the dimensional models, but go to the database relational model directly. We all know it's nearly impossible to access the underlying DB directly, so the option I could think of is to write custom code to access the transparent tables and other objects at ABAP stack.

I don't know why EPM is not an option to OP, but it's not my concern....


To write abap code to replicate BPC data access? Looks absolutely strange...

Vadim Kalinin Feb 08, 2017 at 09:26 PM

I am unable to understand why the EPM report is not an option? Another, not recommended way is to use EPMRetrieve function...

10 |10000 characters needed characters left characters exceeded