When you create a basic report, the system first displays the screen Variables where you specify characteristic values for the characteristics contained in every aspect (fixed characteristics):

• Fiscal year
• Period (from/to)
• Plan/Actual indicators
• Version

On the screen Characteristics , the system displays a list of the characteristics in the aspect chosen and you select those which you wish to analyze. If you specify a characteristic group on this screen, the system displays the characteristics which belong to that group. You specify those which are of interest to you for evaluation. In this way, you define the dimensions of the data model which will be used later during drilldown. When you choose the characteristics, you automatically define the sequence of characteristics; however, you can alter the sequence by choosing Extras ® Sort orders ® Sort characteristics . The sequence represents the hierarchy in which you can drill down in the report. In the following example, a basic report is created which contains the characteristics Company , Division , Country and Customer group, in that order.

On the screen Specify Characteristic Values , you can then specify the characteristic values which interest you. If, for example, you specify the characteristic value Chemtech for characteristic Company , you can limit the report to this particular characteristic value. If you do not yet know which characteristic values you wish to evaluate in the report, you can create a variable. (This example does not contain any variables.)

The next stage is to specify the key figures you wish to analyze and which will later appear in the columns of the basic report. On the screen Key Figures , the system displays a list of the key figures that relate to the chosen aspect, or to the selected key figure group. In the example, the key figures Revenue , Contribution margin 1 ( CM1 ), Sales deductions , Fixed manufacturing costs and Variable manufacturing costs have been chosen. You can find further information on creating a report in the section Creating a report

After you have made the entries indicated above, you must save the report (Report ® Save) before you can execute it (Report ® Execute).

After you have executed a drilldown report, a drilldown list appears by default. The characteristic values of that characteristic that has not had values chosen for it during the creation of the report, and that appears first in the sort order ( Division in the example), appear in the rows. The values of the selected key figures appear in the columns. If the detail list is to be displayed first, you can set this when creating a report by choosing Extras ® Initial list.

In order to fulfill the information needs of different users, there are three levels of functionality when executing reports in drilldown reporting. If you have the appropriate authorization, you can select another functional level under Extras ® Additional functions. You can find further information on this topic in the section Executing a report In level 1 you carry out the navigation functions by placing the cursor on a row and then choosing the desired function in the Navigate menu. If you have the correct authorization you can select another level by choosing Extras ® Additional functions. Both possibilities for selection of navigation functions are described in this example.

By selecting Division or choosing Navigate ® > Country , you can display the values of the division by country in our example. The selected division is then displayed in the report header:

By double-clicking further on Country or by choosing Navigate ® > Customer group in the example, you can display a breakdown by customer group .

By clicking on the icon or choosing Navigate ® Country , you return to the next highest level.

With a single click on the icon next to a division already chosen (in the report header) or if you choose Navigate ® Deactivate characteristic , the system displays the values for the countries totaled over all the divisions . With this you have switched the evaluation hierarchy and set the characteristic country over the characteristic division .

If you wish to perform drilldown independently of the predefined sort order, select a row and choose Navigate ® Choose next level , or select the row and the characteristic Customer group in order to break down the values for a country by customer group . This means that you can navigate freely through a particular data area.

Sometimes the width of the screen is not sufficient to display a large number of selected key figures. Besides scrolling through the columns , you can also click on the icon at the start of a row and the icon , or position the cursor on a row and choose Navigate ® Detail list, to display all the key figures for the object selected.

In a basic report, the detail list contains only one column.

Further navigation functions are explained in the section Executing a Report and in the online handbook Drilldown Reporting.