This content has been marked as final. Show 1 reply
which version of bi publisher you were using?1 person found this helpful
11g. you create multiple data sets ( say EMP,DEPT,OFFICE) for a data model and use it as a data model for multiple reports but you cannot conditional limit the data set execution.
we cannot use multiple data models for a report but can use multiple data sets for a data model as far as i know.
but you may can skip the query execution using package method
like say you have indicator as an option IND LOV values EMP,DEPT,OFFICE
lets say they selected IND = 'DEPT'
so in the package level you can check the IND value and skip the query execution of emp and office and only dept data is populated in xml. like that for all the three sections you need write conditional block in package .
as a work around you can do like this but you need to have an indicator as parameter so that you can know user selected which report and which query needs to be executed. ( need to use before report triggers for using packages).
Assign some points if helpful.