Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Creating Dashboard Prompts

Dashboard prompts allow the end users to specify the data values for filters for some or all of the analyses embedded in the dashboard at runtime. Depending on how a prompt is set up, the filters can determine the content of all of the analyses contained in a dashboard, or all of the analyses on a specific dashboard page.

A prompt that is created at the dashboard level is called a dashboard prompt because the prompt is created outside of a specific dashboard and is stored in the catalog as an object, which can then be added to any dashboard or dashboard page that contains the columns that are specified in the prompt. A dashboard prompt can be a column prompt, variable prompt, image prompt, or currency prompt. Dashboard prompts are reusable, because you can create one prompt and use it many times. When the prompt object is updated and saved, those updates are immediately displayed in all dashboards where the prompt is used.

The following considerations apply when creating dashboard prompts:

  • The number of columns that you include in a prompt can affect performance. In general, you should limit the number of columns to as few as possible.
  • In most cases, a dashboard prompt can contain columns that are not included in an analysis in the dashboard. Any columns in the prompt that are not included in an analysis do not filter that analysis.

    However, if a dashboard prompt uses column prompts that do not set presentation variables, then all of the columns in the dashboard prompt must be included in the embedded analyses that you want the dashboard prompt to filter. In addition, a filter that has its operator set to Is prompted must be specified for each of the relevant columns in the analyses. The columns in the dashboard prompt do not need to appear in the Selected Columns pane.

To create a dashboard prompt

  1. Click the Analytics tab.
  2. In the Home page, in the Create section, click Dashboard Prompt.
  3. From the Select Subject Area menu, select the subject area for which you want to create a prompt.
  4. In the Definition Pane, click the New icon and select the type of prompt that you want.
  5. Complete the details for the prompt and then save it.

    For information about the details that you define for a prompt, see the following topics:


Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.