This lesson develops Dashboards, Prompts, Variables, and Navigation within Oracle BI 12c: Create Analyses and Dashboards Ed 2.
The work is anchored to a reporting team building a trusted executive dashboard from governed subject areas and reusable catalog assets, so each decision is connected to a measurable operational result and an accountable owner.
The instructor models dashboard pages, sections, embedded content, and layout control, then connects it to column and variable prompts, presentation variables, request variables, and scope. The demonstration captures the exact configuration, transaction, command, query, log, or screen evidence needed to prove intended behavior and the applicable control boundary.
Learners work through a role-based scenario involving column and variable prompts, presentation variables, request variables, and scope and actions, guided navigation, drill links, master-detail events, and context passing. The exercise introduces a realistic exception related to prompt defaults, hidden state, cache effects, and dashboard acceptance checks and requires a reversible correction supported by before-and-after evidence.
Acceptance requires accurate handling of actions, guided navigation, drill links, master-detail events, and context passing, traceable proof for dashboard pages, sections, embedded content, and layout control, and a repeatable recovery path for prompt defaults, hidden state, cache effects, and dashboard acceptance checks. Results must be understandable to both implementers and operational support teams.
Learners compare symptoms, logs, state, dependencies, and recent changes when prompt defaults, hidden state, cache effects, and dashboard acceptance checks occurs. The final diagnosis must separate the immediate fix from the preventive control.
The completed output is a tested dashboards, prompts, variables, and navigation implementation or analysis, with validation evidence, troubleshooting notes, rollback guidance, and a concise operational handover.