✒️SAP BI / BW BO Manejo de Características
SAP BI / BW BO Manejo de Características
When defining a query, you can restrict characteristics in the filter to single characteristic values, value ranges, hierarchy nodes, or characteristic value variables.
PrerequisitesYou have selected the characteristic in the filter and using the secondary mouse button, you have chosen Restrict in the context menu.
Procedure General Functions of Input HelpWhen 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 under Selecting Characteristic Values.
Selecting single values
Selecting value ranges
Displaying value keys
Values available in history
Saving values to favorites
Deleting values from the selection window
Searching for ValuesA search option is available in the input help dialog box. For more information, see Searching for Values.
Personalization of Input HelpYou can make various user-specific settings to personalize input help functions. For more information, see Maintaining User Settings for the Input Help Dialog Box.
Input Help Functions in the BEx Query DesignerIn 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 SelectionYou 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.
window.
If you want to undo the procedure, choose Include in Selection.
Selecting VariablesWhen 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 VariablesVariables.
Type, select the variable type (such as Characteristic Value Variable, Hierarchy Node Variable) from which you want to select the variable.
Selectionwindow.
Selecting Variable Value Range LimitsValue Ranges.
â—‹ Between
â—‹ Greater Than or Equal to
â—‹ Greater Than
Show →Variables.
Type, select the variable type (such as Characteristic Value Variable, Hierarchy Node Variable) from which you want to select the variable.
.
operator, two single values are required for the interval limits; the system automatically displays two dropdown boxes. In this case, repeat steps 3-5.
OK.
1. Choose Show → Value Ranges.
Between operator.
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 Historyfor selection. Select the required value and choose OK.
section above.
OK.
You can only use this function for characteristic value variables of the type Single Value.
Selection window.
Set Variable Offsets.
4. Choose OK.
You want to select the period of the last 5 years for your data analysis.
Show → Value Range and Between as the operator.
Current Calendar Year and copy it to the right Selection window using the right arrow.
Set Variable Offsets.
-5.
vi. Choose OK.
Selecting Fixed/Variable Hierarchies/Hierarchy NodesYou can also restrict characteristics by hierarchy or hierarchy node, on a fixed or variable basis. See Restricting Characteristics: Hierarchies.
ResultYou 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, see Variables.
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).
Sobre el autor
Publicación académica de Mary Galicia, en su ámbito de estudios para la Carrera Consultor en SAP BI / BW BO.
SAP Senior
Mary Galicia
Profesión: Ingeniero en Informatica - Venezuela - Legajo: JZ82V
✒️Autor de: 47 Publicaciones Académicas
🎓Egresado del módulo:
Disponibilidad Laboral: FullTime
