BPC10 NW - Link BPC report to Excel Worksheet

[Former Member]

Hello Gurus,

I am having an issue with linking a report in BPC 10 NW.

In an excel workbook, I have a BPC report in the first tab.  In the second tab, I have excel formulas such as "=A2", etc. that refer to the data in the first tab.  However, when I refresh the BPC report, the data in the second tab disappears and I get a "#REF!" error.  I am not sure if I am configuring the data links, member links, etc. correctly.

I request your expert guidance to troubleshoot this issue.

Thanks for all your help.

Regards...

[Former Member]

Hi,

Is the second also a BPC report or just a normal excel sheet?

How is the report in the first sheet created?

[Former Member]

Hi Nilanjan,

The first BPC report is a dynamic report (all the dimensions in the row/column and page axes are dynamic).

The second report is a different tab in the same excel worksheet with formulas such as "=Sheet1!A2", etc.  that is directly built in excel. 

However, when I change the dimension members in the first tab, the information in the second tab changes to "#REF!" in all the cells.  I even tried to create a "data link" for the data part of the report and a "member link" for the dimension part of Sheet 2, but am having no luck...

Any help is greatly appreciated!

Thanks....

[former_member190501]

Hi,

Can you try excel function INDIRECT.

Hope it works...

regards,

Raju

[Former Member]

Hi Raju,

The INDIRECT function did not help....  Any other thoughts?

[former_member20068]

Hi Everybody,

I am facing exactly the same problem. Did anyone solve this problem or any ideas for the solution?

Thanks in advance..

Cigdem

[former_member186338]

Hi,

The INDIRECT function will work, because it will hardcode the link to the cell as a text parameter:

=INDIRECT("Sheet2!A1")

The issue is that it will be a static link to the particular cell. But for some reports this approach is ok.

B.R. Vadim