OR function for filters in BEx

[Former Member]

Hi,

I have a query and in this i need to apply filter on two characters

Let's say i have Delivery indicator values "#" and "X" and   i have Invoice indicator values "#" and "X". when i select Delivery indicator "X" and Invoice Indicator "X" it is applying and giving result which is a normal behavior.

Now, what i want is when i select Delivery indicator "X" and invoice indicator "X" it should take as OR and get complete results.

Is there a way to do it?

Thanks

[Loed · Accepted solution]

Hi Kool,

I think you can do this in transformation level..

Let's call ZDEL_IND and ZINV_IND your delivery indicator and invoice indicator, respectively..Create a dummy characteristic, let's call it ZDUMMY..Then in transformation leve, map ZDEL_IND and ZINV_IND to ZDUMMY field..Then do this routine in ZDUMMY:

IF ZDEL_IND = 'X' or ZINV_IND = 'X'.

result = 'X'.

ENDIF.

***just replace ZDEL_IND and ZINV_IND with the correct field name..

In your query designer, just filter using the ZDUMMY field with 'X'..

Regards,

Loed

[Former Member]

Thanks Leslaw

[former_member194898]

Hi,

If those characteristics works in the way I suspect.  You can create zfield and load data from them (both) to it. Value X would appear in zfield whenever it is in first or second characteristic.

Then use zfield in the query.

Regards, Leszek

[swati_gawade]

Hi,

may be you can try as follows.

create 2 RKF's for your query for the key figure you want to display in the report.

do not apply any filter on Delivery indicator or invoice indicator at query level instead in the RKF.

now put all required characteristics in the rows and use the RKFs in columns.

I have not tried it but i think this will work. let me know if any issues.

-swati.