Selecting Filter Values 

Use

In your Web application, you can select filter values for characteristics and structures. The Web application is filtered according to these values.

If one of the queries on which the Web application is based contains variables, you select the variable values when you display the Web application.

You use the input help dialog box in both cases, that is, when you select filter values and when you select variable values.

Prerequisites

●      Selecting filter values:

In the context menu for a characteristic, structure, or structural component, you have selected Filter → Select Filter Value in the Web application. From the filter pane of the Web application, you can navigate to the relevant characteristic or structure by selecting Edit in the dropdown list box.

●      Selecting variable values:

If the query on which the Web application is based contains mandatory variables, the variable screen appears automatically when the Web application is called.

The Web application can also provide an option for navigating to the variable screen, for example, by providing a pushbutton that is linked to the command for calling the variable screen, or by providing a context menu option.

More information:

Working with the Variable Screen

Context Menu Functions

Procedure

Selecting Single or Multiple Filter Values

       1.      Choose Show Tool → Single Values.

The system displays all possible values for the characteristic or structure of a query view. By default, the first 1000 values are displayed in the list. You can change the number of values displayed by entering the required number in the Maximum field and choosing Refresh.

Depending on the setting for the query view, the values are displayed as keys and/or text. You can change how the values are displayed by choosing  with the quick info text Settings.

More information: Maintaining User Settings for the Input Help Dialog Box

You can select one or more values from the set of values displayed.

       2.      Choose Show View → All.

       3.      Select the required single value and choose Add.

You can also select more than one single value: Select the required single values one after another and choose Add.

Note that you can also enter a single value directly; you do not have to search in the list.

Under Enter a value for <...>, enter the required value in external format and choose Add. If you want to directly enter multiple single values, note that you need to adhere to the required syntax.

Note that the field for directly entering values is context-sensitive. You can only enter single values separated by semicolons (for example, 1; 25; 108); you cannot enter value ranges (for example, >3).

More information: Syntax for Directly Entering Values

       4.      If required, change the order of the selected values. To do this, select the required value in the right-hand window Selection and move the value up or down using the arrow keys under Change Order.

At runtime, you can sort the characteristic according to various criteria. For example, you can sort the characteristic according to the order of selected filter values selected here.

More information: Characteristic Properties in the Sorting section.

       5.      Choose OK.

Sorting the List

You can sort the specified values in ascending or descending order. To do this, choose the relevant arrow in the column header of the list of single values.

Filtering the List

You can filter the specified values, for example, to view only those values that begin with "A". Enter the filter criterion (such as A*) in the empty field next to the filter icon.

This function differs from the function for searching for values; when the list is filtered, the system only searches in the displayed values for the table and the table is then filtered accordingly. When searching for values, the system searches in all of the characteristic’s values.

More information: Searching for Values

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 required value in the right-hand Selections window.

       2.      Choose .Exclude.

If you want to undo this setting, choose  Include.

Selecting Value Ranges

You can define or exclude value ranges for filter values.

...

...

...

...

       1.      Under Show Tool and Show View, choose → Value Ranges.

       2.      Depending on whether you want to include or exclude a value range from the selection, choose either Include or Exclude under Sign.

       3.      Select the operator in the dropdown box and enter the relevant values:

○       If you want to specify an interval, choose Between and enter the lower limit of the interval in the first input field and the upper limit in the second input field.

○       For Equal, Greater, Greater or Equal, Lower, and Lower or Equal, choose the operator and enter the required value in the first input field.

You specify the values for the input field by choosing the input help icon (). A window appears in which you can select a single value appears. Select the required value and choose OK.

You can also enter the value range directly, without calling the input help to select the single values.

Under Enter a range for <...>, enter the required value range in external format and choose Add. Note that you need to adhere to the required syntax.

Note that the field for directly entering value ranges is context-sensitive. You can only enter value ranges (for example, 2-5); you cannot enter single values (for example, 2; 3; 4; 5).

More information: Syntax for Directly Entering Values

       4.      Choose Add and then choose OK.

Selecting Calendar Days

If you want to select individual calendar days or a period for a time characteristic, you are provided with a calendar rather than a value list.

Selecting Individual Calendar Days

...

       1.      Choose Show Tool → Single Values.

       2.      Select the required month from the dropdown box and enter the year (for example 2007) in the field to the right.

You can use the arrows to scroll the months forwards or backwards.

       3.      Click on the required calendar entry and choose Add.

If you want to select more than one day, click on the required days one after the other and choose Add.

If you want to deselect a day again, click on it again.

You can also enter the days directly under Enter a value for calendar day. Use the format DD.MM.YYYY, for example 01.01.2007.

       4.      Choose OK.

Selecting the Period

...

       1.      Choose Display Tool → Value Ranges.

       2.      Proceed as described under Selecting Value Ranges.

When selecting individual values (for the upper and lower interval limit, for example) you can use the calendar described above.

Click on a calendar day or enter it directly and choose OK.

       3.      Choose Add and then choose OK.

Highlighting Calendar Days

In the user settings for the input help dialog, you can restrict the number of values displayed in the input help dialog. You can use various criteria to do this:

●      Only Values with Posted Data in the Current Navigational State

●      Only Values in InfoProvider

●      Values in Master Data Table

During selection of the calendar days, you are not provided with a value list that you can restrict using these criteria. Instead, you have the option of highlighting the values that you want to see in the calendar.

To do this, select the checkbox Highlight Days According to the Currently Selected Access Mode for Filter Values.

The days are highlighted according to your settings. This can allow you, for example, to see which days were posted on.

More information: Maintaining User Settings for the Input Help Dialog Box

Selecting Hierarchy Nodes

If there is an active display hierarchy for a characteristic, you can filter the characteristic according to single values, hierarchy nodes, or hierarchy leaves.

...

...

...

●      To filter the characteristic according to single values, choose Show Tool → Single Values and proceed as described above.

●      To filter the characteristic according to hierarchy nodes or leaves, choose Show Tool → Hierarchy Nodes.

                            a.      Expand the hierarchy node and select the required node or leaf.

You can also use the search function to display the required nodes or leaves.

Enter your search term under Search and choose Start Search. The corresponding entries are displayed in the lower screen area; you can then select the required node or leaf. By choosing Reset, you can display all hierarchy nodes and leaves again.

You can search in keys or text within the hierarchy. You can change whether the hierarchy is displayed with the key or text as follows:

                                                  i.       Choose  Settings.

                                                ii.       On the General tab page, choose the required display type under Display.

                                               iii.       Choose OK.

                            b.      Choose Add and then choose OK.

If there is a display hierarchy for a characteristic and this display hierarchy has been deactivated, you can filter the characteristic according to single values, hierarchy nodes, and hierarchy leaves, as well as define value ranges.

●      To filter the characteristic according to single values, choose Show Tool → Single Values and proceed as described above.

●      To define value ranges for filter values, under Show Tool, choose Show View → Value Ranges and proceed as described above.

●      To filter the characteristic according to hierarchy nodes or leaves, choose Show Tool → Hierarchy Nodes and proceed as described above.

You cannot use hierarchy nodes and value ranges as filter values at the same time.