EPM Filtering conflicts with report with shared rows

[Former Member]

Hello,

I have an issue with EPM filtering. In my sheet there is a main report, on which filtering should be performed, and a secondary report, which has shared row axis with the main one. The problem is, when I switch on filtering in the main report, ALL data in secondary report disappears, even if those rows are not affected by filtering and still remain in layout.

Please share your opinions about this problem.

[former_member186338 · Accepted solution]

Not clear without screenshots...

[Former Member · Accepted solution]

It looks like that without filtering(no tick on "Filter Data Using The Following Criteria"):

Filtering tab:

Report after filtering:

[former_member186338 · Accepted solution]

Please describe the column axis of the secondary report!

[Former Member · Accepted solution]

There are three dimensions in the secondary report: ACCOUNT,PARTNER, and FLOW, they are different from main report's dimensions: O_ACCOUNT,PARTNER,MEASURES(I added measures to match the number of dimensions in second report).

By the way, secondary report is built on a different model.

[former_member186338 · Accepted solution]

"I added measures to match the number of dimensions in second report" - not necessary!

OK, I will perform some tests...

Vadim

[former_member186338 · Accepted solution]

Looks like a real bug in case of multidimensional axis!

Test on IFRS kit:

Before filter:

After filter (remove 1 and 0):

Second report is empty! Please ask SAP support...

Vadim