Skip to Content

Mainting BPC and BW connection in a Single Workbook

Sep 25, 2017 at 05:34 PM


avatar image

Hi Experts,

I am using SAP BPC NW 10.0 EPM SP 21.

I am working on a BPC - BW reconciliation report. Where I have developed a BPC report in a worksheet and another report over a BW virtual infocube in another worksheet.

The reports are working fine individually but I am unable to switch connections between the worksheets. I tried using EPM SetActiveConnection function but that is not working as well.

Hence I seek advice on how to switch connections as we change worksheets.

Thanks a lot!

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

1 Answer

Mayank Kumar Sep 25, 2017 at 07:47 PM

Kalyan Dey

Hi Kalyan,

I saw your this reply to one of the old posts

“You many create a local connection to BW cube and a plannning and consolidation connection to BPC cube using EPM Add-in and get the data from both the cubes and reconsile.



Could you please let me know how did you manage to switch connections? The only thing I am doing differently is that I have an individual worksheet for both reports.

Await your response!


10 |10000 characters needed characters left characters exceeded