Hi,
You can restrict the key figures of an InfoProvider for reuse by selecting one or more characteristics. The key figures that are restricted by one or more characteristic selections can be basic key figures, calculated key figures, or key figures that are already restricted.
1. In the InfoProvider screen area, select the Key Figures entry and choose New Restricted Key Figure from the context menu (secondary mouse button).
If a restricted key figure has already been defined for this InfoProvider, you can also select the Restricted Key Figures entry and then choose New Restricted Key Figure from the context menu.
The entry New Restricted Key Figure is inserted and the properties for the restricted key figure are displayed in the Properties screen area.
2. Select the New Restricted Key Figure entry and choose Edit from the context menu (secondary mouse button.
The Change Restricted Key Figure dialog box appears.
You can also call the Change Restricted Key Figure dialog box from the Properties screen area by choosing the Edit pushbutton.
You make the basic settings on the General tab page.
The text field, in which you can enter a description of the restricted key figure, is found in the upper part of the screen.
You can use text variables in the description (see Using Text Variables).
Next to that, you can enter a technical name in the Technical Name field.
Underneath the text field, to the left of the Detail View area, the directory of all objects available in the InfoProvider is displayed. The empty field for defining the restricted key figure (Details of the Selection) is on the right-hand side of the screen.
3. Using drag and drop, choose a key figure from the InfoProvider and restrict it by selecting one or more characteristic values. See Restricting Characteristicss.
You can also use variables instead of characteristic values. However, note that you cannot use the following variable types in restricted key figures for technical reasons,
Variables with the process type Replacement with Query (see also Replacement Path: Replacement with Querys)
Variables that represent a precalculated value set (see also Detailss)
You can use these variable types to restrict characteristics in the rows, columns, or in the filter.
4. Make any necessary settings for the properties of the restricted key figure on the other tab pages. See Selection/Formula Propertiess.
5. Choose OK. The new restricted key figure is defined for the InfoProvider.
When you change a restricted key figure, these changes are effective in all queries that use this restricted key figure.
You can see where the restricted key figure is used. Choose Where-used List from the context menu of the restricted key figure (secondary mouse click).
1. In the InfoProvider screen area, select the restricted key figure and choose Edit from the context menu (secondary mouse button).
You can also call the Change Restricted Key Figure dialog box from the Properties screen area by choosing the Edit pushbutton.
2. Make the required changes to the definition and, if required, in the properties on the corresponding tab page.
3. Choose OK.
Properties for the restricted key figure
1. Select the restricted key figure. The properties dialog box is displayed in the Properties screen area.
2. Make the required settings for the description, number format, and currency translation for the restricted key figure. See Selection/Formula Propertiess.
You have defined a restricted key figure for reuse. You can now use this restricted key figure in all queries based on this InfoProvider by moving the key figure into the rows or columns of the query using drag and drop. The restricted key figure is not an actual element in this query, but a placeholder referenced to the restricted key figure in the InfoProvider.
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 have chosen Restrict from the context menu (secondary mouse button).
When you select characteristics in the query definition, you can use the same functions as for input help in the executed query. For the following functions, see the descriptions under Restricting Characteristic Values.
Selecting single values
Selecting value ranges
Displaying value keys
Values available in history
Saving values in favorites
Deleting values from the selection window
A search option is available in the input help dialog box. For more information, see Searching for Values.
You can make various user-specific settings to personalize the functions of input help. For more information, see Maintaining User Settings for the Input Help Dialog Box.
Functions of Input Help 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 in 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.
1. Select the desired value in the right Selection window.
2. Choose Exclude from Selection.
If you want to undo the procedure, choose Include in Selection from the context menu (secondary mouse button).
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 the variables it is also possible to define new variables, change variables, and delete them. These functions are always available to the right of the selection of variable type.
1. Choose Show ® Variables.
2. Under Type, choose the variable type (such as Characteristic Value Variable, Hierarchy Node Variable) from which you wish to choose the variable.
3. Select one (or, in exceptional cases, more than one) variable from the list of available variables and add it (using the right arrow) to the right Selection window.
Selecting value range limits
1. Choose Show ® Value Ranges.
2. Select your required operator from the dropdown box. You have the following operators:
Between
Less Than or Equal to
Greater Than or Equal to
Less Than
Greater Than
3. Choose the required value or the required values for the value range and choose : Input help appears in a new dialog box and provides you with the selection of variables under Show ® Variables.
4. Under Type, choose the variable type (such as Characteristic Value Variable, Hierarchy Node Variable) from which you wish to choose the variable.
5. Select the required variable and choose OK.
6. For the between operator, two single values are required for the interval limits; the system automatically offers you two dropdown boxes. In this case, repeat steps 3-5.
7. After you have set the value range, choose OK.
8. Add the selection to the right Selection window using the right arrow.
Selecting intervals with one variable and one fixed limit
1. Choose Show ® Value Ranges.
2. Choose the Between operator.
3. Choose the fixed limit:
The values from your history can also be selected in the dropdown box.
If you want to choose another value, choose . The input help appears in a new dialog box and offers the associated single values under Show ® Single Values or History for selection. Select the required value and choose OK.
4. Select the variable limit by following steps 3-5 from the Selecting Value Range Limits section above.
5. After you have set the value range, choose OK.
6. Add the selection to the right Selection window using the right arrow.
Selecting variable offsets
You can only use this function for characteristic value variables of the type single value.
1. Select the required variable in the right Selection window.
2. Choose Set Variable Offsets.
3. Enter the required offset value.
4. Choose OK.
i. Choose Show ® Value Range and Between as the operator.
ii. Choose the variable Current Calendar Year and copy it to the right Selection window using the right arrow.
iii. Select the variable and choose Set Variable Offsets.
iv. For the lower limit, enter the offset 5.
v. Do not enter an offset for the upper limit.
vi. Choose OK.
Swapping interval limits
If you are using variables in the interval limits, you can swap the limits. In the Set Variable Offsets dialog box, choose the function Swap Intervals.
Selecting fixed/variable hierarchies/hierarchy nodes
You can also restrict characteristics by hierarchy or hierarchy node, on a fixed or variable basis. See Restricting Characteristics: Hierarchies
You have now restricted a characteristic by 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 a variable value, before the query is executed a dialog box appears for you to enter variable values manually (provided that the variable is flagged as ready for input). For more information, see Variables.
Enter the required values and choose OK. The query is now executed with the chosen values.
The query is created according to your selection conditions. The selected characteristic values are displayed in the filter pane, on the right, next to the corresponding characteristic. Only the selected characteristic values are included in the table (or in the chart or map).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.