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.
Note: The Programs feature was deprecated in 23.5 and is planned for removal in 26.4. Oracle recommends that customers move their reports to projects or shells.

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 Thursday, December 4, 2025