Filtering 

Definition

Filter is a command for a view in a Web Template.

Use

You set filter values for characteristics and structures within a view. It is possible to set several filters for the same characteristic / structure, or the same filter for several different characteristics / structures. Filter is a generic command, which means you do not have to set the ‘CMD’ parameter.

You are able to add the filter parameters to any other command !

The actual filtering process is carried out at the end of the operation.

Structure

Parameter

Description

FILTER_IOBJNM

FILTER_IOBJNM_N (optional)

Name of the characteristic / structure that you want to filter by

Specify the technical name of the characteristic (0COUNTRY, for example) or the structure (25 characters) here.

FILTER_COLLAPS (optional)

 

 

‘X’ = Yes, ‘ ’ = No

Removing filter characteristics from the drilldown

The characteristics that are specified under FILTER_IOBJNM, are removed from the axes after the filter has been applied. If you do not specify the parameters, the system assumes you want to use the value ‘X’ = Yes.

FILTER_VALUE

FILTER_VALUE_N

Filter Value

Value, according to which you want to filter, in internal display, for example, 12242000 for 12.24.2000, or G for Germany.

FILTER_NODE_IOBJNM (optional)

FILTER_NODE_IOBJNM_N (optional)

Name of the Node Characteristic

You have to specify the name of the node characteristic if you want to filter according to hierarchy nodes. With characteristic nodes and text nodes, you have to specify the characteristic name (0HIERNODE).

FILTER_VALUE_TYPE_N

(optional)

Type of value specified under FILTER_VALUE

‘VALUE’ : Key for a characteristic value

‘VARIABLE_EXIT’ : Name of an exit variable The filter is set using the values returned by the variable exit. Variables for parameters, intervals, and selection options are supported.

If the FILTER_IOBJNM_N entry is missing from an index n, the value from FILTER_IOBJNM is used, if available.

Examples

Filter view 1 according to the country Germany

<SAP_BW_URL DATA_PROVIDER=’View 1’ FILTER_IOBJNM=’0COUNTRY’ FILTER_VALUE=’DE’>

Filter all views according to costs, and the countries Germany and the USA

<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM_1=’DRB9ZVVMBCHVX4F04Z1JGKYVC’ FILTER_VALUE_1=’DTG057U7OQ8K2ALKCMR2AWM14’ FILTER_IOBJNM_2=’0COUNTRY’ FILTER_VALUE_2=’DE’ FILTER_IOBJNM_3=’0COUNTRY’ FILTER_VALUE_3=’US’>

Filter all views according to the current month

<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM=’0CALMONTH’ FILTER_VALUE=’0CMONTH’ FILTER_VALUE_TYPE=’VARIABLE_EXIT’>