Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 5, 2013 3:06 PM by
Can ONE selection in a Dashboard Prompt set TWO Column Variables.
Feb 20, 2013 12:33 PM
I would like the user to select one Column Variable via a Dashboard prompt but then set 2 Column Variables based on the first selection.
Is there any trick to accomplish this ?
This content has been marked as final.
Show 1 reply
Re: Can ONE selection in a Dashboard Prompt set TWO Column Variables.
Mar 5, 2013 3:06 PM
in response to
You may define the 2 different values and pass in the report based on select.
Try to look for possible values using Criteria->Column->Filter->Advanced button->Convert filter to SQL.
Since you are using SQL here I dont think you have limits to do... :)
So using a single variable is enough and this would be the easy way correct me if I'm wrong.
If helps mark
Any updates on this?
Edited by: Srini VEERAVALLI on Mar 5, 2013 3:05 PM