Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

EPM Addin

10.0 SP16 Patch 1 .NET4

Build 8669

Thank you

Best Regards

Sona

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question