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.
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
Ensure that you have already performed the preceding steps of the tutorial.
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.
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:
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.
Fill the input fields as follows:
Field | Entry | Note |
---|---|---|
| Today's Costs by Subsidiary | |
|
| |
| Leave this indicator empty | |
| ZTUT_DASHBOARDBUILDER_1 | |
|
| You choose the visualization with which the drilldown view is called. You also have the other visualizations available after calling the view. |
| Leave this indicator empty | By selecting this checkbox, you can jump to other SAP Solution Manager applications. |
After you have entered the name of the query, choose Enter. The query is read and other configuration options are displayed.
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 . Enter the current date as the filter value.
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.
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.
Save the drilldown view. If necessary, like for the dashboard, enter the assignment to a package and a transport request, and choose OK
.
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:
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.
Fill the input fields as follows:
Field | Entry |
---|---|
| Costs of the Last 30 Days by Subsidiary |
|
|
| Leave this indicator empty |
| ZTUT_DASHBOARDBUILDER_1 |
|
|
| Leave this indicator empty |
After you have entered the name of the query, choose Enter. The query is read and other configuration options are displayed.
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 . 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.
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.
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
.
Add the field Calendar Day
from the table Available Fields
to the table Rows
.
Save the drilldown view. If necessary, like for the dashboard, enter the assignment to a package and a transport request, and choose OK
.
You have created two drilldown views for the tile Today's Costs
; you can use these views to display detailed information for the tile.