Oracle Analytics Cloud and Server

Home› Oracle Analytics› Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Required Prompt Returns Data When No Value Chosen

Received Response
1
Views
3
Comments
Dennis Hancy
Dennis Hancy ✭✭✭✭
edited August 13 in Oracle Analytics Cloud and Server

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

Answers

  • Jerry Casey
    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
    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
    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.