Start of Content Area

Procedure documentation Selecting Characteristic Values  Locate the document in its SAP Library structure

Use

You can use the input help dialog to select characteristic values.

In the BEx Analyzer, you select filter values for characteristics in order to filter data. This displays the data for the characteristic values in which you are interested.

In the BEx Report Designer, you then select a characteristic value to apply formatting rules depending on the selected characteristic values. This allows you to specify that the data for each characteristic value is to be displayed with a different design.

Procedure

Calling Input Help

You have the following options:

      In the context menu in the BEx Analyzer, choose Select Filter Values.

      In the BEx Report Designer, open a report and select a cell in the report. The cell belongs to a group level to which an InfoObject is assigned. In the input help dialog box, you can select one of the characteristic values of the InfoObject in order to define the design for this characteristic value in this group level. You go to the input help dialog box with the following paths:

       In the Report Structure window, select the group header or group footer of the group level and select Conditional Formatting. in the context menu.

       In the menu, choose Format Conditional Formatting.

Selecting Single Values

       1.      Choose Show  Single Values. The system displays the available values.

Only those values for which there are data records in the InfoProvider and which you are authorized to use are displayed as available values.

If there are less than 1000 values for this characteristic, the values are displayed in a list. If there are more than 1000 values for this characteristic, the input help dialog shows the input template for the search. For more information, see Searching for Values.

If the characteristic has an active display hierarchy, the individual values are displayed hierarchically.

       2.      Select the required single value and choose OK. You can also select the required single value by double-clicking it.

You can also select multiple single values. Select the required single values by pressing and holding the SHIFT key.

Background documentation

Multiple selection and single selection depend on the context. For example, multiple selection is not allowed in the BEx Report Designer.

Selecting Value Ranges

Caution

This function is only available if the characteristic does not have an active display hierarchy. This function is not available in the BEx Report Designer.

Note

You can set the time interval for specific time characteristics in the SAP Reference IMG. The input help only offers those values that lie within this time interval. Choose SAP Reference IMG Customizing Implementation Guide SAP NetWeaver Business Intelligence Settings for Reporting and Analysis General Settings for Reporting and Analysis Set F4 Help and Hierarchies for Time Characteristics/OLAP Settings. On the General Settings tab page, you can set the required time interval under Time Interval.

...

       1.      Choose Show Value Ranges.

       2.      Select your required operator from the dropdown box. You can choose from the following operators:

       Between

       Equal to

       Less Than or Equal to

       Greater Than or Equal to

       Less Than

       Greater Than

       3.      Choose the required value or values for the value range:

You can also select the values from your history in the dropdown box. If you want to select another value, choose This graphic is explained in the accompanying text. The input help appears in a new dialog box and offers the associated single values under Show Single Values or History for selection.

Background documentation

For the Between operator, two single values are required for the interval limits; the system automatically displays two dropdown boxes.

       4.      After you have set the value range, choose OK.

Note

Intervals are formed using the key and not according to the displayed texts. For example, [] January – November also includes August.

Displaying Value Keys

You can also display characteristic values as value keys. By choosing the This graphic is explained in the accompanying text Display Key/Text icon, you can switch between displaying values as keys or as text. By choosing the small arrow This graphic is explained in the accompanying text next to the key/text icon, the following menu is displayed:

      (Standard)

      Text

      [Key]

      Text [Key]

      [Key] Text

Select the display type you want.

Values Available in History

The selected values are automatically saved for the user and the characteristic in a history. You can access the most recently selected values simply and quickly by choosing Show History.

Saving Values to Favorites

You can create and manage personal value lists as favorites.

Once you have selected values, choose Selection This graphic is explained in the accompanying text Save Selection from the right window. The values are now displayed under Show Favorites.

Note

If the system does not automatically display the right window, Selection, you can display this window by choosing More>>.

Deleting Values from the Selection Window

If you want to remove the selected values, select these values in the right window, Selection, and choose the arrow pointing to the left.

Uploading Data for Characteristic Values

This function is only valid for the BEx Analyzer:

You can optionally upload data for the selected characteristic value (such as variables or filter values) to use it in the executed query. This can be useful, for example, if you want to include identical data that is not yet updated in the BI system in the analysis of the query results in your workbooks. By uploading this data for a characteristic value, you save time and reduce the likelihood of errors that can occur if you enter the data manually.

You can also upload a file for multiple variables simultaneously. In addition, you can download data that you previously uploaded for variables and save it locally.

Result

You have selected the required characteristic value(s).

If you call the input help dialog again, the appearance of the dialog box changes. In addition, an area appears to the right that shows the values of the most recently made selection. By choosing More>> or <<Less, you can display the input help dialog with or without the extra area that shows the most recently selected values. The right-hand area is especially useful for obtaining a better overview when you have selected the values from different views, such as single values and value ranges.

 

End of Content Area