In this short ‘How-to’ I’d like to illustrate the ease of reporting on a BEx query inside the BPC 10 EPM Add-In.
First off, we’d have to create our BEx query:
Simply log on to BEx Query, found in programs:
Secondly, Create a new query, be certain to query your BPC InfoProvider:
Right, you should now have a query saved.
The final step in the process is adding the SAP BW OLE connection via EPM Add-in
Open Excel, go to EPM Add-In -> log on
After the connection dialogue box pops up, hit the ellipses dots to the right
Then select create. We will be adding our own connection to BW.
After selecting you should see the following:
For the selection prompt ‘Connection Type’ select local.
You will notice that several connections are now available to you. Select SAP BW OLE DB connection.
The next window should pop up
These prompts are details of your local BW installation, Application Server, System Number and Client can be found when logging on to your SAP GUI BW instance and as well as under the properties in your BW connection.
Stepping through the wizard will now prompt you for a few log in credentials (including browsing the BEx query created , and hey presto, you now have an active connection via BPC 10 to your cube)
Hope this short blurb helps (please excuse brevity)