Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Step 3: Defining Analytics Prompts (Optional)

Previous Topic

Next Topic

Step 3: Defining Analytics Prompts (Optional)

To allow users to specify a filter value when they run an analysis, define a runtime prompt for the analysis. Runtime prompts are useful because analyses may need to be filtered differently based upon different users or the dates that analyses are run.

A runtime prompt differs from a prebuilt filter in that a filter is set up when the analysis is defined and cannot be changed without revising the analysis itself. For example, if you define a prompt on Account Type for the report, your employees are prompted to select which Account Type value to see when they run the analysis. If you define the prebuilt filter as a specific Account Type, such as Competitor, the filter is hard-coded and cannot be altered by the user at run time.

You can create the following types of prompts from the Prompts tab in the analysis editor:

  • Column prompt

    A column prompt provides general filtering of a column within an analysis. A column prompt can present all choices for a column, or, it can present constrained choices for a column.

    NOTE: You can create a maximum of one column prompt for any given column in an analysis.

  • Currency prompt

    A currency prompt allows users to change the currency type in analyses that contain a currency column.

  • Image prompt

    An image prompt provides an image that users click to select criteria for an analysis. For example, in a sales organization, users can click their territories from an image of a map to see sales information, or click a product image to see sales information about that product. Users who know how to use the HTML <map> tag can create an image map definition.

  • Variable prompt

    A variable prompt allows users to select a value from a set of values that you specify in the prompt.

You can create multiple prompts of the same type and multiple prompts of different types for a single analysis.

Related Topics

See the following topics for related information:
Published 6/21/2021 Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices.