Filtering Out Rows in Bex Query

Hi Folks,

We have 2 Info Objects namely GL Account and BPC Account in the cube and these are being displayed in the Bex Report.

For any given month / period there is always one combination of GL account to BPC account and it can change from period to period. When a user runs a report and gets a selection screen

Which has input values of Audit period and comparison period and they can enter Jan and Feb in them respectively.

Most of the records will have the same GL and BPC account combination in most of the records(90%) for both the periods and only some records(10%) may have a different combination.

Requirement :

Now the requirement is to display only those records(only 10%) where BPC and GL Account has changed in two periods. Here is an example of how the records are coming out in the query and we need to display records which are explained in Section A and Section B records need to be filtered out.

Examples:

(A) For Eg: Time Period 1 - 2013.JAN and Time Period 2 - 2013.FEB

GL Account BPC Account Amount for Time Period 1 Amount for Time Period 2

1006.1000 FIXED Asset 2000

1006.1000 Standard Asset 5000

GL and BPC account combination has changed in Jan and Feb and so these need to be displayed

(B) For Eg: Time Period 1 - 2013.JAN and Time Period 2 - 2013.FEB

GL Account BPC Account Amount for Time Period 1 Amount for Time Period 2

1006.2000 CURRENT Asset 5000 8000

1006.3000 ACTUAL Asset 4000 5000

For Section B above the GL and BPC account combination has remained same and we do not want to show these two records. Please note the there are two records because of different GL account.

Please suggest if there is a possibility of putting some counter or some condition on say GL account because if it is appearing only once then that means the mapping has not changed and it needs to be filtered out.

There might be some other better solution for this.