When defining a query, you can restrict characteristics in the filter to single characteristic values, value ranges, hierarchy nodes, or characteristic value variables.
You have selected the characteristic in the filter and using the secondary mouse button, you have chosen Restrict in the context menu.
General Functions of Input Help
When you select characteristic values in the query definition, you can use the same functions as those available in the input help in the executed query. For the following functions, see the descriptions underSelecting Characteristic Values.
Searching for Values
A search option is available in the input help dialog box. For more information, seeSearching for Values.
Personalization of Input Help
You can make various user-specific settings to personalize input help functions. For more information, seeMaintaining User Settings for the Input Help Dialog Box.
Input Help Functions in the BEx Query Designer
In contrast to calling the input help dialog box from the BEx Analyzer and the BEx Report Designer, the input help dialog box in the BEx Query Designer always appears with the full range of functions and with both screen areas. The right window, Selection, which displays the selected values, is always visible.
You can choose from the following additional functions in the query definition:
Excluding Values from the Selection
You use this function to select the values that you do not need for your report.
This function is only used with single values or single value variables.
If you want to undo the procedure, choose Include in Selection.
Selecting Variables
When you select characteristic values in the query definition, you can also select variables instead of fixed values. These act as placeholders and are only filled with fixed values when the query is executed.
When selecting variables, you can also define new variables, change variables, or delete variables. These functions are always available to the right of the selection of the variable type.
Selecting Variables
Selecting Variable Value Range Limits
Selecting Intervals with One Variable and One Fixed Limit
You can also select the values from your history in the dropdown box.
If you want to select another value, choose . The input help appears in a new dialog box and offers the corresponding single values under Show → Single Values or History for selection. Select the required value and choose OK.
Selecting Variable Offsets
You can only use this function for characteristic value variables of the type Single Value.
You want to select the period of the last 5 years for your data analysis.
Selecting Fixed/Variable Hierarchies/Hierarchy Nodes
You can also restrict characteristics by hierarchy or hierarchy node, on a fixed or variable basis. SeeRestricting Characteristics: Hierarchies.
You have now restricted a characteristic to certain characteristic values. Choose OK. You return to the query definition. Save your entries and execute the query.
If you have restricted a characteristic to variable values, before the query is executed a dialog box appears into which you manually enter variable values (provided that the variable is flagged as Ready for Input). For more information, seeVariables.
Enter the required values and choose OK. The query is now executed with the chosen values.
The query is calculated according to your selection criteria. The selected characteristic values are displayed to the right in the filter area, next to the corresponding characteristic. Only the selected characteristic values are included in the table (or in the chart or map).