Show TOC

Background documentationMDO/KPI Objects

 

You can browse for KPI and MDO objects that are available in the SAP MII Workbench. The objects are displayed in a tree structure containing all base and composite KPIs, demand, persistent and joined MDOs. The icon represents base KPIs and represent composite KPIs. You can move the selected KPI or MDO to any section of the layout. In Design mode, the default image along with the path is displayed whereas in Live mode, the real-time table or chart is displayed.

You can customize the dimensions at design and runtime. You can also select or enter values to the KPI dimensions at design and runtime. On the dashboard, the KPI dimensions at runtime takes precedence over the customized dimensions at design time.

Prerequisites

You are assigned the roles with read and write permissions as defined in:

  • XMII_SSCE_ALL

  • XMII_SSCE_MIICONTENT_OBJECT

For more information on users and roles, see User Management.

Features

You can configure and visualize the parameters for the selected KPIs and MDOs. The default visualization of MDO is a table. For the selected MDO, you can do the following:

  • Add and configure query parameters

  • Visualize as a chart

  • Configure additional display parameters when visualized as a chart

The default visualization of KPI is a line chart. The KPI values displayed at runtime are calculated based on the specified durations, granularity, aggregation level and the lifecycle specified in the KPI framework. The available parameters and their descriptions are as follows:

Parameters

Description

Type

Displays the visualization type, Chart and Table.

Chart

Displays the different chart types on selecting Chart.

Duration

Specifies the time span to calculate an aggregated KPI value out of the single KPI values. The values are specified in the SAP MII console.

Granularity

Specifies the granularity of the KPI values that are used as input for the aggregation. The available values are:

  • Hour

  • Day

  • Month

  • Year

  • Raw

  • Week

This field is uneditable if the Duration is CurrentValue for the visualization type Table and for chart types Donut, Pie, or Tile.

Label Columns

The selected label columns is in addition to the timestamp dimension selected in Granularity field. Based on your selection, the chart displays multiple label columns. For example, If the selected granularity is Hour, the label columns applied to the chart can be any combination of Hour, Day, Week, Quarter, and Year.

Note Note

  • You must select Support Quarter and Minute Granularities field to enable minute and quarter level timestamp in Granularity field. For more details, see Creating Key Performance Indicators.

  • Timestamp dimension in KPI is not plotted on the X-axis if you have selected additional X-axis columns.

End of the note.

Start Date and End Date

Start and end date of the selected duration.

Note Note

The fields Start Date and End Date are visible, when you choose Custom as duration.

End of the note.

Start Time and End Time

Start and end time of the selected duration.

Note Note

The fields Start Time and End Time are visible, when you choose Custom.

End of the note.

Dimensions

Displays the following available dimensions of the selected KPI:

  • Visualize: You can select dimensions for charts and tables. A check box appears based on the selection.

    • If you select Table, a check box appears indicating that you can select multiple dimensions for tables.

    • If you select Chart, a radio button appears indicating that you can select only one dimension.

      Note Note

      This column is not visible for Bar, Horizontal Bar and Tile chart types

      End of the note.

  • Level: Displays the hierarchy level of the dimension as specified in the SAP MII Workbench.

  • Dimension: Displays the dimension name

  • Value: You can either select or enter a value to specify the filter of the KPI value
Visualization Behavior of Charts

The visualization behavior for different charts is as follows:

  • Line, Group Bar, Stacked Bar, Horizontal Group Bar

    The dimensions configured are displayed above the chart with a separator. The current dimension is displayed in bold font. You can select different dimensions that are displayed above the chart for visualization. To display aggregate values for all the dimensions, choose .

  • Bar, Horizontal Bar

    On selecting a bar, the bar will be highlighted and the tool tip displays the values at specified points. The X-axis displays the time period and the granularity of the selected bar. On every click, the granularity changes to the next lower level. For example, if you have selected CurrentYear, the bar chart displays the data for the current year. On consecutive clicks, the chart displays the data for the current month, current day, and current hour.

  • Pie, Donut

    On consecutive clicks, the pie or the donut charts will display the data for the next dimension. The path is displayed as breadcrumb navigation above the chart.

  • Tile

    You can display all the selected data in tile format. You can provide granularity, duration and select a dimension and display as tile for the selected dimension. Additionally, you can choose a parameter for each dimension and set default values. The input parameter value can be set for each dimension.

    You can display the KPI values in a brighter background by choosing Choose Background Tile Color. This highlights the background and displays the KPI values in white. The back ground color is actually the value color defined in the KPI. If you do not select the checkbox, the KPI values are displayed in the specified color.

  • Gauge

    On selecting Gauge, the Granularity field is disabled and Time Period field points to Current Value which can be edited. The threshold values and color configuration are retrieved from KPI definition.

Note Note

Events are supported for KPIs that are converted to Tile or Gauge.

End of the note.

Activities

Configuring Visualization for the Selected KPI Objects

  1. Create and save a dashboard. Follow the steps as described in the section Creating a Dashboard inDesign.

  2. Select and add any KPI from Start of the navigation path MII Content Next navigation step MDO/KPI Objects End of the navigation path.

  3. Choose Configure Visualization (Configure Visualization).

    The Configure Visualization screen with default settings Chart, Line, CurrentMonth, and Day is displayed.

  4. You can either choose Table or Chart from the Type field

    On choosing Chart, you can choose the available charts from Chart Type.

  5. You can select or enter the values for Duration and Granularity fields.

  6. You can also select the X-axis label columns from the Label Columns in addition to the timestamp dimensions for the selected chart.

  7. Choose X-axis label columns from the Label Columns.

  8. In the Dimensions table, you can either select or enter the dimensions in the Value column.

    A checkbox appears in the Visualize column.

  9. You can choose a parameter for each dimension and set default values. For details on the parameter and values, see Preferences (Metadata for the Dashboard).

    Note Note

    The KPI dimension supports the contexts None, Query Parameters, and Session Parameters.

    End of the note.

  10. Choose Apply.

Creating Events for the Selected KPI (When Converted to Tile or Gauge)

  1. Choose Events.

    A dialog box appears.

  2. On Click: At runtime, call the method provided in Method Name field when you click on the KPI tile or gauge. You can customize the code in the Source Code tab. For more information, see Source Code.

  3. Show Trend: Displays the trend of the KPI at runtime for specified granularity and duration when you click on the KPI tile or gauge.

Configuring Visualization for the Selected KPI at Runtime

You can alter the configured KPI at runtime. To do so:

  1. Follow Steps 1-7 as in Configuring Visualization for the Selected KPI

  2. Goto Preview mode.

  3. Choose Configure Visualization.

    The Configure Visualization screen without the Input Parameters column appears.

  4. You can change the configuration by selecting a different chart type, entering different values for granularity, duration and changing the dimension value in the Value column.

  5. Choose Apply.

The dashboard reflects the default value entered at runtime.

Configuring Visualization for the Selected MDO

  1. Create and save a dashboard. Follow the steps as described in the section Creating a Dashboard inDesign.

  2. Select and add any MDO from Start of the navigation path MII Content Next navigation step MDO/KPI Objects End of the navigation path.

  3. To configure additional parameters, choose Configure Query Parameters (Configure Query Parameters). For details, see Configure Query Templates in the Activities section of Query Templates

  4. To display the selected MDO as a chart, choose Configure Visualization (Configure Visualization). For details, see Configure Visualization in the Activities section of Query Templates.

    An icon Configure Display Parameters (Configure Display Parameters) is available to configure additional display parameters. For details, see Configuring Display Templates in the Activities section of Display Templates.