Skip to Content
0
Former Member
Nov 21, 2012 at 05:06 PM

Predefined filter...

33 Views

Hi All,

I am trying to create a predefined filter in the webi report.

I have a column called CFI Flag wihch consists of values Uand N.

Now user dont want to give U or N as input, they want to give it as only CFI part or All Parts i.e U or U and N respectively.

I have created a usecase for this as

CASE WHEN CFI_FLG='U' THEN 'INCLUDE ONLY CFI PARTS'

WHEN CFI_FLG='N' and CFI_FLG ='U' THEN

'INCLUDE ALL PARTS' END

However, when i select include "only CFI parts" it is working fine, but wheb i select "Include all parts" then i am getting only values of 'N'

Please help me.

Thank you.