Topics
This chapter includes the following sections:
The two differences between inline prompts and dashboard prompts is where they are stored and their runtime behavior.
A prompt that is created at the analysis level is called an inline prompt because the prompt is embedded in the analysis and is not stored in the Oracle BI Presentation Catalog and, therefore, cannot be added to other analyses. Inline prompts allow the end users to specify the data values that determine the content of the analysis. An inline prompt can be a column prompt, variable prompt, image prompt, or currency prompt. When you create an inline prompt, you select the columns and operators for the prompt and specify how the prompt is displayed to the users and how the users select the values. The user's choices determine the content of the analyses that are embedded in the dashboard. An inline prompt is an initial prompt, meaning that it only displays when the analysis is rendered. After the user selects the prompt value, the prompt fields disappear from the analysis and the only way for the user to select different prompt values is to re-run the analysis.
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. Dashboard prompts allow the end users to specify the data values that determine the content of all of the analyses and scorecard objects contained on the dashboard. 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. A dashboard prompt is a specific kind of filter that, when created, saved, and applied to a dashboard or dashboard pages, can filter all or some of the analyses and scorecard objects that are embedded in a dashboard or analyses and scorecard objects that are embedded on the same dashboard page. A dashboard prompt is interactive and is always displayed on the dashboard page so that the user can prompt for different values without having to re-run the dashboard. Users can create and save dashboard prompts to either a private folder or to a shared folder.
For a dashboard using a column that was renamed in the Business Model, the existing dashboard prompts based on the renamed column do not work with newly created analyses. The workaround for this issue is to use Catalog Manager to rename the column in the catalog.
A column prompt is the most common and flexible prompt type.
A column prompt enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters. Column prompts can be created for hierarchical, measure, or attribute columns at the analysis or dashboard level.
You can create intelligent prompts that are specialized for the user's business needs and roles so that the user can quickly and accurately find the appropriate data that is needed to make a key business decision.
Oracle BI Enterprise Edition also enables you, as the content designer, to create currency prompts, image prompts, and variable prompts. See Other Prompt Types.
How Do Column Prompts and Selection Steps Interact?
Selection steps allow the user to provide or refine the data from attribute columns and measures columns and to provide a kind of filter for hierarchical columns. Selection steps are applied after data aggregation. When you create selection steps for a column, you have the option of overriding one step of the selection with a dashboard or analysis column prompt. All selection steps before and after the override step are processed as specified, and the override step is processed using the user-specified data values that are collected by the column prompt. Column prompts that are created for hierarchical columns allow you to include only the Choice List input option.
See What are Filters and Selection Steps?, Working with Selections of Data, and Overriding a Selection Step With a Column Prompt.
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. The Currency Prompt option is available only if the administrator has configured the userpref_currencies.xml
file. See Configuring Currency Options in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition. 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. 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. See Creating a Variable Prompt.
At design time, you must specify the prompt's user interface component.
The user interface component enables the user to enter a prompt value at runtime. You can select from several user input options. The Radio Button option enables the user to specify only one prompt value. The Check Boxes, Choice List, List Box, and Text Field options allow the user to select either one or multiple prompt values. The Slider option enables the user to select multiple values by specifying a range of values, or all values that are lesser than or greater than a specified value (for example, include everything equal to 200 and greater). The available input option types depend upon the column type that you are working with.
Check Boxes
The Check Boxes input option provides the user with a visible list of all prompt values where a small, selectable box displays before each value item. This input option is suitable for a prompt that contains a smaller set of data. The List Box input option is suitable for a prompt that contains a larger set of data. This user input type automatically enables the user to select one or more prompt values. To select a specific prompt value, the user scans the list and clicks the box that corresponds to a particular item.
The following illustration shows an example of the Check Boxes user input option for a column or variable prompt. The column being prompted is D51 Area, and each value option (Africa, Central, and East) is displayed next to a small box. To select a value, the user clicks the small box that is adjacent to the prompt value. This example shows that Africa and Central are selected, which illustrates that the user can select multiple prompt values.
Choice List
The Choice List input option provides the user with a collapsed list of all prompt values. This option is useful for a long list of values where you want to provide the user with the ability to search for a specific value. You can set up this user input type to accept only one prompt value or multiple prompt values.
This input option provides a field and list that, when the user clicks the down-arrow button, expands and contains a list of all prompt values. To select a specific prompt value from the expanded list, the user scrolls through the list (or searches the list) and clicks the box that corresponds to a particular value. If you are using this input option with hierarchical columns, then a search dialog is displayed where the user can search for the prompt values.
The following illustration shows an example of the Choice List user input option for a column or variable prompt. The column being prompted is D51 Area. The user accesses the list of values by clicking the down-arrow button next to the D51 Area field. After accessing the list of values, each value option (Africa, Central, East, Eastern, Europe, and Middle East) is displayed next to a small box. To select a value, the user clicks the small box that is adjacent to the prompt value. This example shows that Africa and Central are selected, which illustrates that the user can select multiple prompt values. The user can also click Search at the end of the list of values to search for a specific value.
List Box
The List Box input option provides the user with a visible list of all prompt values. This input option is suitable for a prompt that contains a large set of data. The Check Boxes input option is suitable for a prompt that contains a smaller set of data. You can set up this user input type to allow the user to select only one prompt value or multiple prompt values by using Ctrl+ click or Shift+ click.
To select a specific prompt value, the user scans the list and selects the prompt value name (for example, Chicago), similar to how a user would click a hyperlink. The List Box option is very similar to the Check Boxes option, but the List Box option does not include a box before each value item.
The following illustration shows an example of the List Box user input option for a column or variable prompt. The column being prompted is D51 Area. The list contains each value option (Africa, Central, East, Eastern, and Europe). To select a value, the user clicks a value. This example shows that Central is selected.
Radio Buttons
The Radio Buttons input option provides the user with a visible list of all prompt values where a Radio Button is displayed before each prompt value. This option type is useful for short lists of values where the user is to select only one prompt value. To select a prompt value, the user scans the list and selects the radio button that corresponds to a particular item.
The following illustration shows an example of the Radio Buttons user input option for a column or variable prompt. The column being prompted is D51 Area. The list contains each value option (Africa, Central, East, Eastern, Europe, and Middle East). To select a value, the user clicks a radio button that corresponds to the value. This example shows that the Central radio button is selected.
Slider
Note:
The Prompt Width option, which sets the prompt's field size and the Wrap Label to Fit Prompts page setting option cannot be specified for or applied to a Slider.You can use the Slider input option for numeric data values only. Depending upon the operator that you select, this option enables the user to select multiple values by specifying a range of values, or all values that are lesser than, greater than, or equal to a specified value. You select the Slider option to provide the user with a number line representation of the range of prompt values. The number line displays the prompt values in a range, for example 10,000 to 20,000. To select a prompt value, the user can either click a value on the number line or click and drag the thumb to select the desired value. A spinner box is also provided with up and down-arrow buttons that the user can click to select the desired value. If you selected the Slider option and the is between operator for the prompt, then the user can click and drag two thumbs to select the desired range of values for the prompt. Two spinner boxes are provided where you can either type or use the up and down-arrow buttons to specify a range of values.
The following illustration shows an example of the Slider user input option that accepts a range of values for a column prompt. The column being prompted is 7-Shipped Amount. The slider itself is a number line and on the left end is the number label 500K, in the middle is the number label 750K, and on the right end is the number label 1M. There are also two spinner boxes above the number line. From these spinner boxes, the user can specify either a single number (for example, 500000 in the first spinner box and 500000 in the second spinner box) or two numbers to specify a range of numbers (for example, 500000 in the first spinner box and 750000 in the second spinner box). To specify numbers in the spinner boxes, the user can either type the value or use the box's up and down arrows to scroll to the desired value. To select a value from the number line, the user clicks and drags the thumb to the desired value or clicks and drags both thumbs to specify the desired range of values. This example shows that a range of values from 500000 to 750000 is selected.
Text Field
The Text Field input option provides the users with a field into which they can type a specific prompt value. You cannot use this option for multiple prompt values. Only the field and the field label display for this option. This option is useful in instances where the user knows the prompt value and does not have to search for it, or for prompts with numeric values. The prompt value that you enter must match the column's value. For example, if a column's data values include AMERICAS (in all capital letters), then the user must type AMERICAS into the text field. Numeric values cannot contain commas. If your repository is configured for double columns, and you are creating a prompt on a display column and specify Text Field, then filtering occurs on display values, not on code values.
The following illustration shows an example of the Text Field user input option for a column or variable prompt. The column being prompted is D52 Area. The field next to the D51 Region label is blank. In this field, the user enters the name of the Region (for example (AMERICAS, APAC, and EMEA). This example shows that the AMERICAS was entered into the text field.
While prompts function the same way on a mobile device—viewed in the Oracle BI Mobile application—they render differently and users interact with them differently.
Any customizing of prompt labels that is done in the desktop version of Oracle Business Intelligence has no bearing on prompts as displayed in Oracle Business Intelligence Mobile. All properties related to the formatting of prompts are ignored in Oracle BI Mobile.
You can combine and wire prompts in various ways to create dashboards and reports that allow users to request precise, meaningful data.
Combining and wiring prompts enables you to specify how dashboard prompts interact with analysis prompts. Currency prompts and variable prompts cannot be combined or wired.
For example, you can create analysis A that contains information about the amount of product that is sold by region and to the Region column add the Is protected option and then add a Region prompt. You can then create analysis B that contains information about sales person by region and analysis C that contains information about city by region. You then create and save a dashboard prompt for Region. When you create a dashboard and add analyses A, B, and C and the Region dashboard prompt and run the dashboard, the dashboard prompt input drives only what is displayed in analyses B and C. In this scenario, analysis A does not use the Region value that is specified in the dashboard prompt because you set analysis A's Region column filter value to Is protected. Therefore, the only way that analysis A accepts a prompt value is if the user specifies a prompt value in Region A's prompt fields.
There are various ways that you can combine and wire prompts. This table describes each method.
Wiring Method | Description |
---|---|
Auto wiring |
Oracle BI Enterprise Edition's auto wiring functionality assumes that you intended to create a functioning prompt for the column and, therefore, activates and applies the prompt. Oracle BI EE applies the auto wiring method when you create an analysis and add a column prompt or image prompt. This auto wiring method does not require the is prompted filter operator. Any unprotected filter can be used. Setting the filter operator to is prompted provides a more precise level of control between prompts and filters than the auto wiring method. For more information, see the Filter operator is set to is prompted row in this table. |
Constrained Prompts |
Use this method with several columns in a prompt to constrain the user's prompt choice based on subsequent choices. Constrained prompts can be set up on the Prompt options dialog to specify which prompt narrows the choices. For example, if one column filters on region and the next column filters on city, then the city column can be constrained to show only cities in the selected region. |
Filter operator is set to is prompted |
Use this method to build complex prompts that interact with filters. When you use this method, you have full control over how the dashboard prompts, inline prompts, and filters are applied to the embedded analysis. |
Selection steps Override with Prompt option |
Use this method to use an analysis or dashboard column prompt to provide the data choices for a specific member selection step on a hierarchical or attribute column. Since you cannot use filters with hierarchical columns, selection steps are the only way that you can use prompts with hierarchical columns. Only one selection step per column selection step set can be overridden with a prompt. All selection steps before and after the overridden step are processed as specified. See What are Filters and Selection Steps?, Working with Selections of Data, and Overriding a Selection Step With a Column Prompt. |
Protected versus Unprotected filters |
Use this method to determine whether the dashboard prompt can supply the inline prompt's value when the corresponding column's filter value is set to something other than Is prompted. The unprotected and protected filter settings can be used when a dashboard prompt and inline prompt reside on the same dashboard and both prompts were created for the same column. When the column's filter value is unprotected, the dashboard prompt value determines the analysis' results. If the filter value is set to something other than Is prompted (for example, Is equal to/is in) and the filter is set to protected filter, then the dashboard prompt cannot determine the report results. See the Filters pane. |
Because prompting enables you to build flexible dashboards and analyses, it is important to understand how Oracle BI EE initiates a complex dashboard's prompts. The following list presents the order in which, at runtime, Oracle BI EE applies prompts with default values:
Hidden prompts whose scope is the dashboard page. See Adding a Hidden Dashboard Prompt to a Dashboard or Dashboard Page.
Hidden prompts whose scope is the whole dashboard.
Prompts whose scope is the dashboard page. The precedence order of dashboard page prompts is unspecified.
Prompts whose scope is the whole dashboard.
Prompts, either inline or named, whose scope is the analysis.
Auto-complete functionality is available for specific types of prompts.
Oracle BI EE provides auto-complete functionality for prompts, which, when enabled, suggests and highlights matching prompt values as the user types in the prompt selection field.
Auto-complete is only available for the Choice List prompt type when the prompt designer selected the Enable User to Type Value option in the New Prompt dialog. Auto-complete is not available for hierarchical prompts.
The administrator configures the auto-complete functionality to be case-sensitive or case-insensitive, and then specifies the matching level. The matching level determines how Oracle BI EE matches the column's values to what the user types. There are three different ways that the administrator can set up auto-complete matching:
Starts With — As the user types, Oracle BI EE suggests the column values that begin with the letter or text that the user is typing. For example, if the administrator configured auto-complete to be case-insensitive and the matching level to Starts With and the user types m, then Oracle BI EE suggests Micropod and MP3 Speakers System.
Word Starts With — As the user types, Oracle BI EE suggests the column values that contain any words who's first letter matches what the user is typing. For example, if the administrator configured auto-complete to be case-insensitive and the matching level to Word Starts With and the user types c, then Oracle BI EE suggests ComCell, MPEG Camcorder, and 7 Megapixel Digital Camera.
Match All — As the user types, Oracle BI EE suggests the column values that contain any letter that the user is typing. For example, if the administrator configured auto-complete to be case-insensitive and the matching level to Match All and the user types l, then Oracle BI EE suggests LCD 36X Standard, LCD HD Television, 7 Megapixel Digital Camera, and Plasma HD Television.
When the administrator properly configures the prompts setting in the Oracle BI EE instance configuration file, the auto-complete functionality highlights matching values when the user accesses the Select Values dialog to search for a prompt value. However, the matching level is not determined by the preference set by the administrator. Instead, the user selects the matching level in the Select Values dialog.
The prompts auto-complete functionality is enabled by the administrator at the system level, but the dashboard designer can exclude the auto-complete functionality from dashboards, and user can turn auto-complete off by using the My Account dialog. Consider the following relationships between auto-complete settings:
System Setting — The administrator modifies the system configuration file to enable the auto-complete functionality for Oracle BI EE. When this functionality is turned on, all users can access the auto-complete prompts functionality. If this functionality is turned off, then all auto-complete fields are disabled on the Oracle BI EE user interface. For more information, see Configuring for Prompts in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Dashboard Setting — If auto-complete is enabled for Oracle BI EE, then the dashboard designer can remove the auto-complete functionality from individual dashboards by setting the Prompts Auto-Complete field to Off in the Dashboard Properties dialog. However, the auto-complete prompts functionality will be available for other dashboards where the Prompts Auto-Complete setting is set to User Preference.
User Preference Setting — If auto-complete is enabled for Oracle BI EE and for individual dashboards, users can disable the auto-complete prompts functionality for their accounts by setting the Prompts Auto-Complete field in the Preferences tab of the My Account dialog to Off. Setting this option to Off overrides the system and dashboard settings, and no auto-complete functionality will appear for the user.
A column prompt enables users to select the values to populate a column in a dashboard or analysis.
Use the following procedure to create a named column prompt that you can apply to one or more dashboards, or to create an inline column prompt that is embedded in an analysis. This procedure does not include information about selection steps or hierarchical columns. See Overriding a Selection Step With a Column Prompt and Editing Prompts.
Use the following procedure to create a selection step with a column prompt override.
You can override a selection step with either a dashboard or an analysis prompt. For example, you can specify that the Products.Brand selection step be overridden with a column prompt specifying the BizTech and FunPod members.
The following list provides examples of overriding selection steps with prompts when the user selects groups or column members:
One or more groups, such as My Regions and My Cities, can override a selection step only of the Add type.
One or more members, such as Central and Eastern, can override a selection step of any type.
One or more groups and one or more members, such as My Regions and Central, can override a selection step of any type. However, groups are ignored and members are supported.
For more information about using a column prompt to override a selection step, see the following topics:
An image prompt provides users with an image that contains sections or areas that they can click to select a specific prompt value.
For example, an image prompt can be a map of the United States with sections that represent the North, South, East, West, and Central sales divisions. Users can then click the divisions that correspond to the sales information that they want to view in the dashboard or analysis.
You can apply image prompts to one or more dashboards, or embed them in analyses. Use the following procedure to create or edit an image prompt. See Editing Prompts.
A currency prompt enables users to change the currency type that is displayed in the dashboard or analysis.
When applied to a dashboard or embedded in an analysis, the prompt provides users with a list where they can select a currency. The currency types in this list are specified by the administrator in userpref_currencies.xml
. The same list of currencies is displayed in the Preferences tab of the My Account dialog.
Use the following procedure to create a currency prompt that you can apply to one or more dashboards, or to create a currency prompt that is embedded in an analysis. See Editing Prompts.
You can create a variable prompt that you can apply to one or more dashboards, or to create a variable prompt that is embedded in an analysis.
A variable prompt is not dependent upon a column, but can still use a column. For example, you can use variable prompts to enable the user to specify existing data to perform sales projections. You might 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.
See Other Prompt Types, Using Variables, and Editing Prompts.
You can edit a saved dashboard prompt or inline prompt, to propagate its changes to wherever the prompt is used.
For example, you can edit the prompt for the Brand column to change the user input to a choice list. This change is propagated to the Brand Revenue analysis where the prompt is used
If you edit and save a named prompt, the changes that you make to the prompt are propagated to wherever the prompt is used.
Adding dashboard prompts to dashboards or dashboard pages allows the user to interact with the dashboard.
You can add a hidden dashboard prompt to a dashboard or dashboard pages.
At runtime, the hidden dashboard prompt sets the default values for all of the corresponding prompts on the dashboard or dashboard page, and the unprotected inline prompts that are located on the analyses on the dashboard or dashboard page. You can add one or more hidden dashboard prompts to the dashboard or dashboard page.