can i get database fields from BPC in excel via VBA

[Former Member]

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.

[former_member186338]

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

[Former Member]

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.

[former_member186338]

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

[Former Member]

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....

[former_member186338]

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