## 4.2.1  To define prompt values
## Procedure
1. Open the Prompts dialog.
In the Prompts Summary area, you see a list of all available prompts in the query and the selected values. In the Specify Value for Prompts area, you can expand single prompts to define values. The mandatory prompts are marked with an asterisk. If default values for the prompts are defined in BEx Query Designer, they are displayed as selected in the prompting dialog.
If you have selected to not merge the variables for this workbook on the Components tab in the design panel, the prompts are displayed separately for each data source and you can define different values for the same prompt for the corresponding data sources.
2. In the Display list box, select whether all prompts, no prompts or only the mandatory prompts are expanded in the Specify Value for Prompts area :
- Select Hide All if all prompts should be displayed collapsed.
- Select Show All if all prompts should be displayed expanded. This is the default option.
- Select Hide Optional Prompts if only the mandatory prompts should be displayed expanded.
- Select Show Technical Names if the technical names should be displayed additionally.
3. Define values for the expanded prompts.
You can define values for the following prompt types. Depending on the prompt definition in BEx Query Designer, you have various options:
## Prompt Type Value Definition
| Dimension*   | Single value You can select one member as the prompt value for this dimension.                                                                                                                  |
|--------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Dimension*   | Multiple value can select multiple members as the prompt values for this dimension.                                                                                                             |
|              | You                                                                                                                                                                                             |
|              | Press the + button, to add a field for additional values. Press the Filter button if you want to select multiple values in a list at once. To remove a selected member, press the red X button. |
## Dimension* Value range
You can select a start and an end member to define a range of values for this dimension.
You can also enter the start and end member manually in one field, separated with space-minus-space
- ( - ). When applying the values, Analysis moves the end member automatically to the second field. You can apply the values with selecting the tab key or selecting another field in the dialog.
## Dimension* Selection option
You can select an operator and corresponding members to define a selection for this dimension. The following operators are available:
- = Equal To
- != Not Equal to
## Prompt Type Value Definition
- &gt;= Greater Than or Equal To
- &gt; Greater Than
- &lt; Less Than
- &lt;= Less Than or Equal To
- [] Between
- ![] Not Between
- CP (Contains Pattern) / !CP (Excludes Pattern) The use of this operator must be enabled in the file system or in the Analysis backstage area (Technical Configuration). For more information, contact your IT administrator.
You can add multiple selections for this dimension. Press the + button, to add a selection. To remove a selection, press the red X button.
Definitions with other operators that are available in BEx Query Desinger 3.5, can be displayed and deleted but not edited.
| Hierarchy       | You can select a hierarchy from the list box to define a prompt value.                                                                                                                                                                                                                                 |
|-----------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Hierarchy node* | Single value You can select one hierarchy node as the prompt value for the selected hierarchy.                                                                                                                                                                                                         |
| Hierarchy node* | Multiple value You can select multiple hierarchy nodes as the prompt values for the selected hierarchy. Press the + button, to add a field for additional value. Press the Filter button if you want to select multiple values in a list at once. To remove a selected member, press the red X button. |
| Formula         | You can enter a numeric value. The numeric value is used for measure calculations defined in BEx Query Designer with prompts.                                                                                                                                                                          |
| Text            | You can enter a text. This prompt type can be used to assign text to columns or row headers or to change the description of a calculated measure.                                                                                                                                                      |
* For these prompt types, you can enter the values manually or using input help. When you open input help, no values are selected. You can search for members or select members directly from the list. You can also define if the members in the list should be displayed with key, text, or both. For hierarchical dimensions, you can define if the members should be displayed in hierarchies, at leaf level, or on a specific level.
4. Press OK to apply the selected values to your data.
The system validates all prompt values. If the validation is successful, the crosstab is displayed according to your selection.
## Results
The data in the worksheet is displayed according to your selection.
If you select a data source on the Information tab in the design panel, you can see the defined values in the Variables area. If you select the workbook on the Information tab in the design panel, you can see the defined values in the Variables area if the variables in the workbook are merged. If the variables are not merged, the message 'Variables are not merged' is displayed in the Variables ares.
The defined prompt values can be saved with the workbook and are then available to other users or in other sessions. To change the prompt values, open the prompting dialog again.
If you need to define new prompt values for a data source, you can select Clear All in the Prompts dialog to remove the defined values for all prompts and define new values.
## Related Information
To select workbook properties for prompting [page 167]