Connecting SAP BI 4 Web Intelligence to SAP BPC 10

[Former Member]

Hi,

We want to connect SAP BI 4 Web Intelligence to SAP BPC 10 cubes. I have previously visited this area in SAP BPC 7.5 and had used the ODBO connector which was atrociously slow so we extracted the data into SAP BW to connect to.

In the note "1731626 - Data source connectivity options between BusinessObjects BI tools and BPC" it states the below, that we can connect to SAP BPC 10 using BEx Query Designer. The question I have then are we now OK to create BEx Queries on BPC applications? Previously this was not supported?

Web Intelligence BI 4.0

Data source	Runtime connectivity requirements	Design time requirements
BPC 7.5 (MS, NW)	UNX  + XMLA	IDT
BPC 7.5 (MS, NW)	OLAP UNV +BPC ODBO 2.0	UDT
BPC 10 MS	UNX  + XMLA	IDT
BPC 10 NW	BICS / BEx Query	BEx Query Designer

[former_member181999 · Accepted solution]

Hello Leo,

Good news for you. The connection is possible (Between SAP BO <---> BPC <---> BW) and it is simple. Steps are as below.

1. SAP BPC model is a multi provider. Open the Query designer -->Select the multiprovider as source to create a Query (as needed)
2. Here is the 25 Page Step by Step Prodedure
3. Other URL's

Have a good day. Regards-Ashok

[Former Member · Accepted solution]

Hi,

Thanks for the info - I am comfortable in connecting SAP BI 4 to a BW source.

I just want to confirm it is fully supported. I know there were concerns with full optimisations causing issues due to techical name changes to providers in SAP BPC?

Cheers,

[former_member181999 · Accepted solution]

Hi Leo,

There are no issues (Technical/Functional/Performence). I've developed many BPC reports in BEX as well as in BO. User team like the BO report (As they are quick & better look.).

Thank you.

[former_member670196 · Accepted solution]

Thank you Ashok.

[Former Member]

Hi,

A very useful document found here...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0e85a95-378e-3010-d4bd-ecb37847b...http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0e85a95-378e-3010-d4bd-ecb37847b...

[Former Member]

If you don't need member formulas defined in BPC as well as BPC authorizations then this approach is fine. If you have any access restrictions you'll need to maintain BW authorization in addition to BPC authorization.

Cheers.