OBIEE backend query not having NOT IN operator

User_R93U9

Hi,

While adding a column filter with "not equal to / is not in" operator, OBIEEE backend query is generated like below.

     t552147.account_seg12_code <> '15501'

    AND

        t552147.account_seg12_code <> '15500'

    AND

        t552147.account_seg12_code <> '15504'

    AND

        t552147.account_seg12_code <> '15600'

    AND

        t552147.account_seg12_code <> '15601'

    AND

        t552147.account_seg12_code <> '15602'

Ideally it should be like "t552147.account_seg12_code not in ('15501','15500','15504','15600','15601','15602')

What could be possible reason? Please help

[Deleted User]

It all depends on the RPD and what kind of DB you are accessing HOW.

What database type is this? What call interface are you using?