Local Member issues – Multiple report with shared row/column axis

[sona_a]

Hi all ,

I have 4 reports in a sheet with shared Row/Column axis as below.

Report 000 –

In Rows: Nested Dimension- Audit id A and Accounts (A …D)

In Columns : Nested Dimension- Actual and Time(12 months)

Report 001 –

In Rows: Shared Row axis off Report000

In Columns : Nested Dimensions-  Plan and Time(12 months) in Column and Local member formula eg: SUM(H23:T23)

Report 002 –

In Rows: Nested Dimensions- Audit id B and Accounts (E …J)

In Columns : Shared Column axis off Report000 ie Actual and Time

Report 003 –

In Rows: Shared Row axis off Report002

In Columns : Shared Column axis off Report001 ie Plan and Time

When Refresh the expansion of Local member formulas in Report 003 is incorrect. System is picking the Local member formulas in Report 001 and repeating the calculation. Ie SUM(H23:T23) in Report 003 area.

Tried to create Local member formula in Report003  ie SUM(H60:T60) but after refresh system always repeating the Local member formula in Report001 ie SUM(H23:T23) not the one on Report003. This looks like a system bug to me because when placed the cursor in the Local member area next to Report003, the current report in Pane is showing as Report 001.

Any suggestions on this issues ? I want,local member formula to expend/execute dynamically in Report003 area.

EPM Addin

10.0 SP16 Patch 1 .NET4

Build 8669

Thank you

Best Regards

Sona

[former_member186338 · Accepted solution]

Hi Sona,

What is the reason to use 4 reports? The result will be slow!

Please read my document here:

Vadim

[sona_a · Accepted solution]

Hi Vadim,

Thanks for reply. Business want to view the data (Actual &Plan) feed into BPC from different system (using a different Audit id ).

Agree the retrieval will be slow on the template but we only have 4 rows in the second set of reports.

Implemented the solution without using axis sharing among the reports.

Best Regards

Sona

[former_member186338 · Accepted solution]

Please read my document how to work with asymmetric reports.

It's possible to have single report instead of 4.

Vadim