title: Clickable dropdown in Obiee
body: <p><em>background info:</em>
  OBIEE, Oracle BI answers.</p>
  
  <p>The business asked us to create an dashboard with clickable links as a menu.</p>
  
  <p>So in the dashboard we’ve created a presentation variable with multiple selection, this works as a variable for the report.
  In the report we’ve created sections for all the options in the menu that are activated by a condition. The condition report contains a filter that states: the variable from the menu is equal to ‘my filter’. That way it produces a row for the rowcount.
  The reports that are show in the section contain clickable links (drill through), that contain parameters as well, to another dashboard page. So this is all working well.</p>
  
  <p><em>actual question</em></p>
  
  <p>But now...
  they’ve requested to create a drop down menu in order to have a ‘shortcut’ to the drill through reports. 
  Problem is as far as I know there isn’t a possibility to create a prompt that can link to a report, nor can it pass parameters values.
  An other option could be to create a new variable and if that one is activated it redirects the page to the other ‘dashboard page’.
  What would guys you recommend?</p>