Show TOC

Procedure documentationTutorial Part 4: Creating a Drilldown View

 

This tutorial explains the creation of tiles and dashboards in Dashboard Builder. In this step, you create a drilldown view for a tile that you have created in this tutorial. A drilldown view typically displays more detailed information about the tile, for example, the development of the displayed value over time.

Prerequisites

This procedure is part of a tutorial on Dashboard Builder.

You create this drilldown view within the Tutorial: Using BW Queries as a Data Source, in which, in Dashboard Builder, you create tiles and drilldown views that use BW queries as their data source.

Note Note

Ensure that you have already performed the preceding steps of the tutorial.

End of the note.

Procedure

Start Dashboard Builder, as described in Dashboard Builder, and in the dashboard Tutorial, call the tile Today's Costs, which you created in the second step of the tutorial.

Today's Costs by Subsidiary

A drilldown view displays details on the values of the associated tile. Since today's costs are displayed for all subsidiaries in the tile, useful detailed information would be today's costs broken down by subsidiary. To create this type of drilldown view, proceed as follows:

  1. After calling the tile Today's Costs - All Subsidiaries, in the relevant screen area, choose the pushbutton + (Add) next to the dropdown list box to open the configuration window for the drilldown view. The Add New KPI screen appears.

  2. Fill the input fields as follows:

    Field

    Entry

    Note

    Name

    Today's Costs by Subsidiary

    Data Source Type

    BW Query

    Jump to Generic Analytics Application

    Leave this indicator empty

    Data Source Name

    ZTUT_DASHBOARDBUILDER_1

    Visualization

    Bar Chart

    You choose the visualization with which the drilldown view is called. You also have the other visualizations available after calling the view.

    Jump to Application

    Leave this indicator empty

    By selecting this checkbox, you can jump to other SAP Solution Manager applications.

  3. After you have entered the name of the query, choose Enter. The query is read and other configuration options are displayed.

  4. The Available Fields list contains the characteristics that you defined as Free Characteristics when creating the query (Tutorial Part 1: Creating a BW Query). You want to display the costs for the current day; therefore, filter the Calendar Day field to the current day's date.

    To do so, from the context menu of the Calendar Day field, choose the entry Start of the navigation path Filter Next navigation step Select Filter Value End of the navigation path. Enter the current date as the filter value.

  5. The Filter table displays all filters, including the Calendar Day field with the current date. So that the values for this date are not displayed every day, rather that the values of each current date are displayed, convert the filter to a rolling time slot by choosing the pushbutton to the right of the date. Instead of the actual date, the value Today is output.

  6. The query filled the tables Rows (with the entry Source - this is the subsidiary) and Columns (with the entry Key Figures - these are the costs). Since you want to display the costs broken down by subsidiary, you do not need to make any changes to this setting.

  7. Save the drilldown view. If necessary, like for the dashboard, enter the assignment to a package and a transport request, and choose OK.

Costs of the Last 30 Days by Subsidiary

To present other options for the drilldown view, you will create another view, which outputs the costs of the last 30 days, broken down by the subsidiaries. This is a two-dimensional value set (day and subsidiary) for which the visualizations Stacked Bar Chart and Table are suitable.

For the correct display, the columns must also contain the Source and the rows must contain the Calendar Day (which is also filtered to the last 30 days). To create this type of drilldown view, proceed as follows:

  1. After calling the tile Today's Costs, in the relevant screen area, choose the pushbutton + (Add) next to the dropdown list box to open the configuration window for the drilldown view. The Add New KPI screen appears.

  2. Fill the input fields as follows:

    Field

    Entry

    Drilldown Name

    Costs of the Last 30 Days by Subsidiary

    Data Source Type

    BW Query

    Jump to Generic Analytics Application

    Leave this indicator empty

    Data Source Name

    ZTUT_DASHBOARDBUILDER_1

    Visualization

    Stacked Bar Chart

    Jump to Application

    Leave this indicator empty

  3. After you have entered the name of the query, choose Enter. The query is read and other configuration options are displayed.

  4. The Available Fields list contains the Calendar Day. To filter it to the last 30 days, from the context menu of the Calendar Day field, choose the entry Start of the navigation path Filter Next navigation step Select Filter Value End of the navigation path. Choose is between as the relational operator, enter the correct start date (30 days ago) and end date (today), and choose OK to confirm your selection.

  5. In the table Filter, the Calendar Day field is display with the data entered. So that values from the last 30 days are always displayed, convert the filter to a rolling time slot by choosing the pushbutton to the right of the date.

  6. As described above, you need the field Source in the table Columns. Therefore, delete the field Source from the table Rows, and add it to the table Columns.

  7. Add the field Calendar Day from the table Available Fields to the table Rows.

  8. Save the drilldown view. If necessary, like for the dashboard, enter the assignment to a package and a transport request, and choose OK.

Result

You have created two drilldown views for the tile Today's Costs; you can use these views to display detailed information for the tile.