Oracle Analytics Server Report Levels

There two major levels for an Oracle Analytics Server report.

Project level, which means the report is running in project or 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)

Last Published Friday, April 11, 2025