Skip to Content
avatar image
Former Member

can i get database fields from BPC in excel via VBA

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    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.

    Add comment
    10|10000 characters needed characters exceeded

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

    Add comment
    10|10000 characters needed characters exceeded