BPC Report - Column Axis with Local member

[Former Member]

Hello All,

I am having challenge with BPC EPM report in which I need to have 2 reports with shared column axis with Local members. Shared local member for second report doesn't refer/point to second report row reference.

Please find the attached sample report structure where column axis is shared between Report1 and Report2. In Report1, the Variance formula start at C6-D6. Since the axis shared, the Variance formula in the second report is also starting from C6-D6 instead of C13-D13. How to correct the issue. Please advise.

[former_member186338 · Accepted solution]

Why not to read EPM help???

https://help.sap.com/viewer/46f83019d80d4a0787baa7e49f3f95af/2.6.0.0/en-US/f9bdca036faf1014878bae8cb...

Example 3

[Former Member]

Thanks Rekha and Vadim. It worked.

[former_member623]

Instead of excel referrence in local member formula you can use epmposition

=EPMPOSITION(001)-EPMPOSITION(002)