Skip to Content
0
May 07, 2010 at 11:44 AM

FILTER EXPRESSION

66 Views

Hi fellow developers,

Got a question, im strugling to build a predefined filter using a filter expression iso the normal filter key.

Basically I want the user to be prompted to use one or the other InList filtering, so i was thinking to build a filter along this line of thought;

(promptvalue=1 and condition1) or (promptvalue=2 and condition2)

It didn't work and i stripped down the condition to the faulty part being the filter expression.

So now I created a filter that should always be true using that

<FILTER EXPRESSION="@Prompt('code?','N',,Mono,Free)" >
<CONDITION OPERATORCONDITION="Equal" >
<CONSTANT CAPTION="@Prompt('code?','N',,Mono,Free)" />
</CONDITION>
</FILTER>

In the trace I can see it evaluates to this after filling the prompt with 1

<FILTER EXPRESSION="1" >
<CONDITION OPERATORCONDITION="Equal" >
<CONSTANT CAPTION="1" />
 </CONDITION>
</FILTER>

Which is always true in my book, but never true according to BW...

Anyone had any luck using filter expressions in the SAP BW environment?

We are on the latest patch level btw...

Thanks for any insights,

Marianne