Nested Filter

[Former Member]

Hi Everyone,

I am stuck with a nested filter, below is what i want to do:

and (

          ( ( b.auto_renewed_counter > 0) and (B.OPEN_EFFECTIVE_DATE between '02-aug-2015' and '25-aug-2015'))

              or

              (

                  TO_DATE(CASE

                   WHEN A.ACCT_OPN_DATE <= TO_DATE('01-AUG-2015', 'DD-MON-YYYY') THEN

                    A.ACCT_OPN_DATE

                   ELSE

                    B.OPEN_EFFECTIVE_DATE

                 END) between '02-aug-2015' and '25-aug-2015'

              ))

is there any way to implement this on BI.

Thanks in advance.

Best Regards,

Mithun

[amitrathi239]

Hi,

If you want to implement on Webi level then use IF ELSE condition to do this.

Amit

[Former Member]

Hi,

If then else is the best way to achieve your requirement just i will give outline to do for your requirement,

(

          ( ( b.auto_renewed_counter > 0) and (B.OPEN_EFFECTIVE_DATE between '02-aug-2015' and '25-aug-2015'))

              or

              (

                  TO_DATE(CASE

                   WHEN A.ACCT_OPN_DATE <= TO_DATE('01-AUG-2015', 'DD-MON-YYYY') THEN

                    A.ACCT_OPN_DATE

                   ELSE

                    B.OPEN_EFFECTIVE_DATE

                 END) between '02-aug-2015' and '25-aug-2015'

              ))

try like this,

create

variable1 as if(A.ACCT_OPN_DATE <= TO_DATE('01-AUG-2015', 'DD-MON-YYYY') then A.ACCT_OPN_DATE else B.OPEN_EFFECTIVE_DATE

variable2 as if(( b.auto_renewed_counter > 0 and B.OPEN_EFFECTIVE_DATE  ) or variable1) then

Regards,

Ragoth.C