Mainting BPC and BW connection in a Single Workbook

[Former Member]

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!

[Former Member]

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.

Regards,

Kalyan.“

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!

Thanks!