This discussion is archived
1 Reply Latest reply: Jan 17, 2013 2:06 AM by Voltaire RSS

Question on Dashboard prompts? OBIEE Version 11.1.1.6.2

872653 Newbie
Currently Being Moderated
Hi,

Is it possible to refresh the dependent Dashboard prompts when its parent prompt is selected?

For example, I have got Country and State prompts in my dashboard and State prompt values are limited by Country prompt i.e if India is selected as Country, only Indian states will appear in the State prompt. My requirement is when a country is selected, first value of the State prompt should be selected (displayed) automatically.

How to achieve it? Thanks in advance.
  • 1. Re: Question on Dashboard prompts? OBIEE Version 11.1.1.6.2
    Voltaire Journeyer
    Currently Being Moderated
    Hi,

    As you already have the cascade setup between Country and State set the default value for the state with SQL. The way to do it is use a presentation variable for country and use that variable in the state default sql as a filter. Sort the values and pick the 1st value in the sql. This would return the 1st value in the State prompt.

    Let me know if this worked.

    Regards,
    Jay

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points