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.