Multiple Conditions in BEx 3.5 Query

[Former Member]

Hello All,

I am using BEx 3.5 and I have two single line conditions in my query. One is set to "All Characteristics in the Drilldown Independently" and the other is set to "Single Characteristics or Comginations of Characteristics". Each Condition works when only one is active. When both are active, the one set to "All Characteristics in the Drilldown Independently" does not work. It has a check in front of it indicating that it is active, but it does not work properly. Is it possible to have two conditions active at the same time when one is set to "All ....." and the other is set to "Single....".

Any help would be appreciated!!

Thanks!

Tina

[Former Member]

HI Tina,

2 conditions at same time can't work on one characteristic in 2 different way. this is something like finding 1 red apple or 2 green apple in a pack up 4 apples say. which is not possible either you have 1st search for 1 and then for 2 or 1st 2 and then for 1.

when both the conditions are active i think the condition "Single Characteristics or Comginations of Characteristics" was after the condition "All Characteristics in the Drilldown Independently" in the designer and thats why its overwriting the other. you may decide logically which condition should be applied 1st and then from that out come, if the other condition is applicable then if it works for the desired out put. else you can make both the condition of same type either All char or single char.

i think you should put the condition "all char" for both and it should work.

you can also decide one primary condition and apply that one only and the other condition you can achieve using a RKF.

hope this helps.