Show TOC

To define prompt valuesLocate this document in the navigation structure

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.
  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

    You can select multiple members as the prompt values for this dimension.

    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.

    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
    • >= Greater Than or Equal To
    • > Greater Than
    • < Less Than
    • <= Less Than or Equal To
    • [] Between
    • ![] Not Between
    • * Contains Pattern / !* Excludes Pattern

      The use of this operator must be enabled in the registry. 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.

Related Information