Other Prompt Types

In addition to column prompts, you can create currency prompts, image prompts, and variable prompts. The following list contains information about these prompt types.

For information about column prompts, see "What are Column Prompts?"

• Currency Prompt — A currency prompt enables the user to change the currency type that is displayed in the currency columns on an analysis or dashboard. For example, suppose that an analysis contains the sales totals for a certain region of Canada in Canadian dollars. However, because the users viewing the analysis reside in the United States, they can use the currency prompt to change the sales totals from Canadian dollars to US dollars. The prompt's currency selection list is populated with the currency preferences from the user's "My Account dialog: Preferences tab." Note that the Currency Prompt option is available only if the administrator has configured the userpref_currencies.xml file as described in "Configuring Currency Options" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition. For more information about creating a currency prompt, see "Creating a Currency Prompt."

• Image Prompt — An image prompt provides an image that users click to select values for an analysis or dashboard. 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. If you know how to use the HTML <map> tag, then you can create an image map definition. For more information about creating an image prompt, see "Creating an Image Prompt."

• Variable Prompt — A variable prompt enables the user to select a value that is specified in the variable prompt to display on the dashboard. A variable prompt is not dependent upon a column, but can still use a column. For example, you can use variable prompts to allow the user to specify existing data to perform sales projections. For example, you can create a variable prompt called Sales Projections and specify the variable prompt values as 10, 20, and 30 percent. Then you create an analysis that contains the Region and Dollars columns. Within the Dollars column formula, you select the multiply operator and insert the Sales Projection variable. When users run this analysis, they can select a percentage by which to recalculate the Dollars column. For more information about creating a variable prompt, see "Creating a Variable Prompt."