Show TOC

Individually Configured FiltersLocate this document in the navigation structure

Use individually configured filters if you want to use more than one OData service to configure your filters.

The following video shows how to configure filters:

For each filter, you can configure the following:

  • The property for which a filter is displayed
  • The values that are listed in the value help for the property

    You may have to configure a value help request to generate the list of values that the user can choose from to filter the data.

    You can also maintain the values manually if you don’t have a service available that produces the desired values.

  • The values that are preselected in the value help.

When you launch your APF-based application from a Smart Business KPI tile, you must also consider whether an additional filter is handed over with the Smart Business context and how that affects the filter you are configuring.

Note

Do not define a filter for URL parameters. For example, if you configure SAPClient as URL parameter, you cannot define an additional filter for SAPClient because this may result in an empty data response.

You can use the fields listed in the following table to configure a filter. Not all of the fields are relevant for each use case. For example, you can configure a value help request to determine the entries in the value help list. A filter resolution request is necessary if the Smart Business context contains not only single values, but also other operators. The filter resolution request then resolves the context into a list of single values. This is necessary because a filter can only display single values. For details about possible use cases, see Use Cases for Configuring Filters.

Field Explanation
Basic Data Filter Title The label displayed for the filter at runtime.
Property The property for which you want to configure a filter. This property is also used as the property displayed in the filter if an alias is not defined. Values that the user selects in the filter are handed over to the entire analysis path as filter.
Do Not Show Filter at Runtime

Select this checkbox if you do not want to expose this filter at runtime. This is useful when a request requires a mandatory filter or parameter that is not coming in from outside APF, for example, with the Smart Business context, and if it is not necessary that users see or change the filter.

Note

When you select this checkbox, any information you may have entered for value help request and filter resolution request is deleted. When you decide later on to show the filter at runtime, you must fill in this information again as required.

Selection Mode Choose whether you want to allow single selection or multiple selections.

Default Values

Default Value Mode

Select Automatic Values if you want the system to determine the default values automatically. In case of single selection, the first entry in the value help of the filter is selected by default. In case of multiple selection, all values are selected by default.

Select Fixed Values if you want to list specific values that are preselected in the value help.

Note

Do not enter sensitive data as default values for filters. Other APF users can read the configuration and thus have access to this data.

Select Function if you want to specify a JavaScript function that calculates the default values. This function must be included in the Business Server Pages (BSP) application.

Note

Using a function to calculate the default values is not possible if you use the generic APF runtime application.

Default Values/Function

Depending on the default value mode, either specify the fixed default values or a function.

Note If a context is handed over from a Smart Business KPI tile for this filter property, this context replaces the default values. The default values are used as a fallback only. This is necessary because it is not possible to have an empty filter.
Value Help

Value Help Mode

Select Value Help Request if you want to specify a request to generate the list of values in the value help.

Select Configured List of Values if you want to enter the values for the value help manually.

Select None if none of the above options applies. The values in the value help can then result only from default values or from a context that is handed over from outside, for example, from a Smart Business KPI tile.

Values

Manual list of values for the value help. Displayed only when you select Configured List of Values.

The following fields are displayed only when you select Value Help Request.

Service

The path to the OData service root of the request that determines the values that are displayed in the value help. If you use ABAP CDS views or BW OData queries, select a service from the value help, which lists all services available on SAP Gateway. If you use calculation views, you must enter the service manually.

Entity Set Entity set that corresponds to the SAP HANA view. This field is mandatory if a service has been entered.
Properties

The properties that determine the values in the value help. Select at least the filter property or the alias property. You can also select further properties. For example, you can select CompanyCode and Revenue so that the value help lists those company codes for which revenue exists.

If you select both a filter property and the corresponding text property, for example, CompanyCode and CompanyCodeName, a concatenation of key and text is displayed in the filter at runtime and you can search for both of them.

Alias

The property displayed in the filter. It is used if the field name of the filter’s property is different in the value help request. If the property and the alias are the same, the alias can be omitted.
Filter Resolution Use Value Help Request

You can configure the same request for both value help and filter resolution by selecting the Use Value Help Request checkbox in the filter resolution request.

When you select the checkbox, all filter resolution fields are filled with the same entries as the corresponding value help fields and cannot be edited. When you deselect the checkbox, the value help entries remain but can now be edited.

If you change the value help entries, the filter resolution entries are updated accordingly.

Service

The request used for resolving a context into single values for the value help. If you use ABAP CDS views or BW OData queries, select a service from the value help, which lists all services available on SAP Gateway. If you use calculation views, you must enter the service manually.

You should specify a filter resolution request if there is a possibility that a Smart Business context is handed over that does not contain single values.

If you did not specify a filter resolution request, but a filter resolution is necessary to be able to display the values in the value help, the filter for the corresponding property is not displayed on the UI. Instead, the context is applied to the analysis path in the background.
Entity Set Entity set that corresponds to the SAP HANA view.
Properties The properties that determine which values are preselected in the filter. Select at least the filter property or the alias property. You can also select further properties.