Required Prompt Returns Data When No Value Chosen

Dennis Hancy

We have a requirement where one of our dashboard prompts is required.

When we first open the analysis, there is no default value specified for that prompt, so at the outset, there is no value selected there.

However, the report still runs showing all records.

How can I prevent that report from displaying any records until the user selects something?

I saw an article on this from 11 years ago that refers to using "Guided Navigation", but I don't see that anywhere in today's OBIEE version.  Is that still a "thing"?

Thanks,

Dennis

Jerry Casey

Hi Dennis,

If you are using a presentation variable instead of "is prompted" in the query filter, you can use a dummy default value that produces no results.

it may look like "Table"."Required Field"='@{varname}{XXX}'

In the "No Results" window you can insert a message like "Complete the required prompts"

Dennis Hancy

Thank you Jerry!

This is awesome.  It worked perfectly.  You've saved me a lot of time trying to research this

Dennis

Jerry Casey

Glad it helped!  The only drawback to this method is that when you have to edit the query you need to temporarily replace the "XXX" with a valid value.