Local Member issues – Multiple report with shared row/column axis
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.
10.0 SP16 Patch 1 .NET4