Optional filter becomes required

[bi4business]

Hi All,

I have a Report with a Prompt page and a optional prompt.

When I run the report the filter is optional.

When I create a data item in the Query and use the optional prompt like:

IF ( ?PROMPT_FIELD? is missing )
THEN ( 1 )
ELSE ( 2 )

And use this data item in my list, the prompt filter becomes required.
Is this normal, or is our evironment (10.2.1.1) not ok?

BI4BUSINESS

[Lynn]

This is normal behavior. Once you reference a prompt within the expression of a data item then the prompt is required.

Perhaps you could provide a default value for your prompt instead.