1 Reply Latest reply: Jan 17, 2013 4:06 AM by Voltaire RSS

    Question on Dashboard prompts? OBIEE Version 11.1.1.6.2

    872653
      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
          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