cancel
Showing results for 
Search instead for 
Did you mean: 

Combining 2 Filter conditions

Former Member
0 Kudos

Hi,

I need to create a pre-defined filter condition in BO-BW universe so that users can drag the filter into report .

I need to create a filter where Sales Org = 1000 and Plant = 5000.

I tried to use the below code , getting error message saying syntax is not right.

However if i use each filter condition Separately, it is working fine. So my syntax to combine 2 conditions is not correct.

Any suggesstion what is wrong in my syntac.

<OPERATOR VALUE=u201DANDu201D>

<FILTER KEY="[0SALESORG].[LEVEL01].[[20SALESORG]].[Value]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="1100"></CONSTANT></CONDITION></FILTER>

<FILTER KEY="[0PLANT].[LEVEL01].[[20PLANT]].[Value]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="5000"></CONSTANT></CONDITION></FILTER>

</OPERATOR>

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Your suntax seems to be correct.

I suggest that you actaivate Web Intelligence traces then create the filter you need in Web Intelligence.

Finally copy and paste the filter definition from the WebI traces in your universe.

Regards,

Didier

Answers (0)