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.