Question Re: EPM Filtering conflicts with report with shared rows in Financial Management Q&A https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334592#M196609 <HTML><HEAD></HEAD><BODY><P>Please describe the column axis of the secondary report!</P></BODY></HTML> Mon, 02 Nov 2015 11:13:23 GMT former_member186338 2015-11-02T11:13:23Z EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaq-p/11334589 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an <SPAN style="font-size: 13.3333px;">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. <BR /></SPAN><BR />Please share your opinions about this problem.</P></BODY></HTML> Mon, 02 Nov 2015 08:17:07 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaq-p/11334589 Former Member 2015-11-02T08:17:07Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334590#M196607 <HTML><HEAD></HEAD><BODY><P>Not clear without screenshots...</P></BODY></HTML> Mon, 02 Nov 2015 08:47:58 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334590#M196607 former_member186338 2015-11-02T08:47:58Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334591#M196608 <HTML><HEAD></HEAD><BODY><P>It looks like that without filtering(no tick on "Filter Data Using The Following Criteria"):</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822681" width="450" /></P><P>Filtering tab:</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822682" width="450" /></P><P>Report after filtering:</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822696" width="450" /></P></BODY></HTML> Mon, 02 Nov 2015 10:18:23 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334591#M196608 Former Member 2015-11-02T10:18:23Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334592#M196609 <HTML><HEAD></HEAD><BODY><P>Please describe the column axis of the secondary report!</P></BODY></HTML> Mon, 02 Nov 2015 11:13:23 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334592#M196609 former_member186338 2015-11-02T11:13:23Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334593#M196610 <HTML><HEAD></HEAD><BODY><P>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). <BR /><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822747" width="450" /><BR />By the way, secondary report is built on a different model. </P></BODY></HTML> Mon, 02 Nov 2015 11:25:03 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334593#M196610 Former Member 2015-11-02T11:25:03Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334594#M196611 <HTML><HEAD></HEAD><BODY><P>"I added measures to match the number of dimensions in second report" - not necessary!</P><P></P><P>OK, I will perform some tests...</P><P></P><P>Vadim</P></BODY></HTML> Mon, 02 Nov 2015 11:28:30 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334594#M196611 former_member186338 2015-11-02T11:28:30Z Re: EPM Filtering conflicts with report with shared rows https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334595#M196612 <HTML><HEAD></HEAD><BODY><P>Looks like a real bug in case of multidimensional axis!</P><P>Test on IFRS kit:</P><P></P><P>Before filter:</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822936" height="141" width="274" /></P><P></P><P>After filter (remove 1 and 0):</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/822937" height="125" width="273" /></P><P></P><P>Second report is empty! Please ask SAP support...</P><P></P><P>Vadim</P></BODY></HTML> Mon, 02 Nov 2015 15:01:24 GMT https://community.sap.com/t5/financial-management-q-a/epm-filtering-conflicts-with-report-with-shared-rows/qaa-p/11334595#M196612 former_member186338 2015-11-02T15:01:24Z