There two major levels for BI Publisher report.
- Project level which means the report is running in Project/Shell context.
- Program level which means the report is running in Program context.
For a Project or Program report, respectively, ensure that the following predefined Unifier parameters are applied on the "Where" clause as conditions in the query of the Data Set related to the Main view:
:uuu_p_context_project_id:uuu_p_context_program_id
The following are examples of the parameters used in a "Where" clause:
project_id = nvl(:uuu_p_context_project_id,project_id)program_id = nvl(:uuu_p_context_program_id,program_id)