0 Replies Latest reply: Apr 15, 2010 5:08 AM by 766904 RSS

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

    766904
      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