Drilldown 

Definition

Drilldown is a command for stored views of query data in the Web template.

Use

Use this command to change the position of a characteristic or a structure for one or more views.

Structure

CMD

Expand

Parameter

Description

IOBJNM

Name of the characteristic/structure

Specify the technical name of the characteristic here (for example, 0COUNTRY) or the structure (25-place character sequence), which you want to bring into the drilldown.

AXIS (optional)

‘X’ = columns

‘Y’ = rows

’ ’ = Free characteristics (=remove drilldown)

Axis on which the characteristic / structure is to be based

If PARENT_IOBJNM is not specified, the characteristic/structure is brought onto the axis behind the other characteristics/structures. If you do not specify the parameter ‘AXIS’, the value ‘Y’ is used for characteristics, and ‘X’ for structures.

PARENT_IOBJNM (optional)

Name of a characteristic/structure on the axis

When you specify this parameter, you can drag a characteristic/structure behind a different one on an axis.

Examples

Drilldown view 1 by country

<SAP_BW_URL DATA_PROVIDER=’View 1’ CMD=’Expand’ IOBJNM=’0COUNTRY’ >

Drilldown view 1 by country and filter the calendar year to 2000

<SAP_BW_URL DATA_PROVIDER=’View 1’ CMD=’Expand’ IOBJNM=’0COUNTRY’ FILTER_IOBJNM=’0CALYEAR’ FILTER_VALUE=’2000’>

Drag periods 1, 2 and 3 (2000) from view 1 to the columns

<SAP_BW_URL DATA_PROVIDER=’View 1’ CMD=’Expand’ IOBJNM=’0FISCPER’ AXIS=’X’ FILTER_IOBJNM=’0FISCPER’ FILTER_VALUE_1=’2000001’ FILTER_VALUE_2=’2000002’ FILTER_VALUE_3=’2000003’>