on 12-04-2010 12:27 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.