The following are uses of a prompted filter:
- The Prompts dialog box allows you to specify the data that is selected and displayed in the report, allowing you to focus on a specific part of the information available.
- A prompted filter allows multiple users viewing a single document to specify different subsets of the data and display them in the same tables and charts in the report.
- You can use a prompted filter to define a question that displays whenever the data in the document is refreshed. The users can answer the prompt either by entering or by choosing values, depending on the parameter properties which have been specified for the prompt in the Query Panel. For example, you can use the prompted query filter to produce a report that shows sales revenue per state and prompts the user to choose a product category at each refresh. This way, you do not restrict the data displayed to a single product category, such as Jewelry. Instead, users choose the product category that interests them at that moment.
- You can define prompts on any dimension, measure, or attribute object listed in the Universe outline in the Query Panel.
Add a Prompt
You build a prompt in the Query Panel.
Prompt Properties
Prompt Properties dialog box features:
The following parameters can be configured:
| Option | Description |
|---|---|
| Prompt text | Enter the text that you want to display to prompt the user to select a value. This text displays each time the document is refreshed. |
| Prompt hint | This hint is displayed when the user must answer these prompts in the Prompts dialog box. It can be used by document designers to help their users answer these prompts |
| Prompt with List of Values | Choose this option to display all the values for the object and allow the user to choose from those values. |
| Select only from list | Choose this option to prevent users from entering values that do not exist in the database. |
| Keep last values selected | Choose this option to display by default the value chosen at the previous refresh. The user can change the value or use the previously chosen value. |
| Optional prompt | The optional prompt uses the Between operator and allows the user to enter two values to set the limits of a range, but the user enters only the lower end of the range. As a result, the generated query updates the operator from Between to Greater than. When a prompt is made optional, the user can choose to ignore the prompt. The result is that everything is returned in the report. For example, if you make a year prompt optional, all years are retrieved in the report if the user chooses not to answer the prompt. |
| Set default values | Choose this option to define the default values that displays in the prompt. Define the default values using one of the following methods:
|
Procedure: To Create and Configure a Prompt
Follow these steps to create and configure a prompt:
- In the Query section of the toolbar, choose Edit.
- Drag the object you want to filter with a prompt and drop it in the Query Filters pane.
- Open the Operators list.
- Select an operator from the list.
- Open the Operand list.
- Select Prompt.
- Choose Prompt Properties to display the Prompt Properties dialog box.
- Adjust the settings.
- Choose OK.
- Choose Run.
Prompt Variant Sets in the Prompts Dialog Box
You can save a group of most used variable value sets as a prompt variant in the Prompts dialog box.
After the Web Intelligence document query is created, run, and saved for the first time, when you refresh or open the document, you can see the available prompt variants options in the Prompts dialog box. Once you have selected the values for each prompt in the Prompts Summary UI, you name and save the variable value set as a prompt variant. It is subsequently available in the Prompts dialog box from the available prompt variants list.
Variant Parameters
The following parameters can be configured:
| Option | Description |
|---|---|
| Save variant | This feature is available after you have created, run, and saved the Web Intelligence query in the SAP BI Platform Repository for the first time. A button that allows you to create (or save) a prompt variant. |
| Variants management | This feature lists any prompt variants you have saved |
| Delete | A button that allows you to delete an existing prompt variant. |
| Public | To share it so that it can be used by any users |
