Skip to Content
avatar image
Former Member

Mainting BPC and BW connection in a Single Workbook

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 25, 2017 at 07:47 PM

    Former Member

    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!


    Add comment
    10|10000 characters needed characters exceeded