This discussion is archived
0 Replies Latest reply: Apr 15, 2010 3:08 AM by 766904 RSS

Oracle Business Intelligence How to choose data set based on a condition

766904 Newbie
Currently Being Moderated
Hi,

I am using Oracle Business Intelligence for creating reports, i am facing a situation where i have two quries (data sets in BI), one to display a Failure message and other to fetch data from the table to be displayed in the report.

The problem is i am unable to choose which data set to run based on a condition. How to use a condition based on which the dataset will be run

For example : i will read a table column value if it is 'S' means success, then i have to run the dataset to fetch the data from the table.

If the column value has 'F' then i have to run the dataset which will display failure message

Please let me know if any of you have any idea on this

Thanks in advance
Muthukumaran

Legend

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