Using NULL and NOT NULL in prompted filters

[Former Member]

Dear all,

While trying to grap the concept of prompted filters in sap bo web intelligence, I had a question whether why we cannot use NULL and NOT NULL while creating a prompted filters in our report.

[former_member203850]

Didn't get your question...Can you please elaborate...

Regards,

Pranay

[amitrathi239]

Hi,

What is your question?

You can use "is null" and "is not null" in the webi query filters.Both are available.

Amit

[Former Member]

My question is why can we not use 'Is Null' and 'Not Null' while creating 'prompted filters'?

[amitrathi239]

HI,

'Is Null' and 'Not Null' are the predefined functions in webi which only eliminate the null values or considering only null values.

'Is Null' and 'Not Null' are itself predefined functions that why you are not getting  prompts.

Null values are standard across the databases so this is defined  as a function in webi to specific eliminate the null values.

If something is not standard then there is option in the webi to use different operator with static values or with prompts.

More more information on Null see the Null wiki page.

Null (SQL) - Wikipedia, the free encyclopedia

Amit