A Dashboard Prompt combined with a Presentation Variable provides a centralized runtime control that can be reused by multiple analyses on the same dashboard. Oracle defines a presentation variable as a variable whose value is populated from a column prompt or variable prompt. Each time the user changes the prompt selection, Oracle updates the presentation variable with the newly selected value.

The dashboard analyses can reference that variable in their filters or expressions. Consequently, the user selects Department once, and all appropriately configured content responds using the same runtime value. This avoids duplicating prompt logic within each individual analysis and improves maintainability.

Applying separate filters manually would require maintaining similar logic in every analysis. Creating distinct dashboards for each department creates unnecessary duplication and version-management overhead. Multiple analysis-level prompts would also produce a fragmented user experience when a single dashboard-level selection is required.

Oracle's documentation explicitly states that presentation variables can be created through prompts and that their values change when users make new prompt selections. Therefore, the recommended architecture is one Dashboard Prompt that sets a Presentation Variable consumed by the related analyses.

Reference Topic: Designing, Creating, and Enhancing Dashboards — Dashboard Prompts and Presentation Variables

===============