Creating a Dashboard Chart

Objective

After completing this lesson, you will be able to create a dashboard chart.

Analytics Chart

SAP Integrated Business Planning (SAP IBP) allows you to analyze and visualize your data as charts, and to collect the charts on a dashboard for easy access. You can use the Analytics Advanced application to analyze your data and to create and customize charts. In the Dashboard Advanced application, you can organize and present charts and other information on a single UI to ensure convenient access.

The Analytics Advanced application provides a detailed view of all reports and Key Performance Indicators (KPIs), as well as a chart-creation tool. It enables you to customize how you display your data (visualizations) in a chart, bar graph, or data set. You can create visualizations from various sources, including importing them from SAP Sales and Operations Planning (S&OP) from your company network or from your items.

To display the Analytics Advanced application, choose the corresponding tile on the SAP Fiori launchpad. The Analytics Advanced application allows you to do the following:

  • Query your data (filter).

  • Group your data to visualize it in a meaningful way.

  • Save visualizations as a chart to a library that you can easily add to your custom dashboards.

  • Share your charts with other users or export them to a file.

Note

By default, all charts and dashboards are public. You can make charts and dashboards private by changing the parameters on the Global Configuration screen in the Configuration application. To make a chart or dashboard private, change the CHARTS PUBLIC parameter or the DASHBOARDS_PUBLIC parameter to false.

Comparison Chart Type

Different sets of data are suited to a specific chart type. The following table describes the comparison chart type, which is available for selection in the Analytics application:

Comparison Chart Type

Analysis Type

Chart Type

Purpose

Comparison

Bar

A chart that illustrates comparisons along individual items. Categories are organized along the vertical axis, and values along the horizontal axis.

Use this chart when you have one or more data series to plot, and you want to compare data for multiple categories. Data contains positive, negative, and zero values. The displayed values are durations.

Column

Column chart displays or compares several sets of data. This type of chart is best suited for displaying data for several sets over a period of time.

Dual X-Axis Bar

Allows you to compare data sets that have different units of measure. This chart type is used to compare trends or relationships between two variables (e.g., key figures) that may have different magnitudes and scales of measurement.

Dual Y-Axis Bar

Used for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. This chart type is useful when you have limited real estate and want to establish the relationship between two variables quickly.

Heat Map

A graphical representation of data where the individual values contained in a matrix are represented as colors. Fractal and tree maps often use a similar color-coding system to represent the values of a variable in a hierarchy.

Table

Data is presented in a simple table form.

Vertical WaterfallThis chart illustrates the cumulative increase, decrease, and total result for a set of key figures along a vertical axis
Horizontal WaterfallThis chart illustrates the cumulative increase, decrease, and total result for a set of key figures along a horizontal axis
Waterfall with Time DimensionThis waterfall chart illustrates the cumulative evolution of key figure values over time.

Key figure values can be inverted from positive to negative or from negative to positive, and reordered.

Trend Chart Type

The following table describes the trend chart type:

Trend Chart Type

Analysis TypeChart TypePurpose
TrendLineA line chart displays data as a series of points connected by a line. This type of chart is best suited for showing data for a large number of groups (for example, total sales over the past several years).
Dual Y-Axis LineUsed for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. This chart type is useful when you have limited real estate and want to establish the relationship between two variables quickly.
Dual Y-Axis CombinationThe combination chart is a visualization that combines the features of the bar chart and the line chart. The combination chart displays data using multiple bars or lines, each representing a specific category. A combination of bars and lines in the same visualization can be useful for comparing values across different categories, as it provides a clear view of which category is higher or lower. An example of this is using a combination chart to compare projected sales with actual sales across different time periods.
CombinationThis chart combines the features of the bar chart and the line chart. The combination chart displays data using multiple bars or lines, each representing a specific category. A combination of bars and lines in the same visualization can be useful for comparing values across different categories, as it provides a clear view of which category is higher or lower.
Dual X-Axis CombinationUsed for comparing trends or relationships between two variables (for example, key figures), which may have different magnitudes and scales of measurement. It combines the data categories represented by bars and lines.

Distribution Chart Type

The following table describes the distribution chart type:

Distribution Chart Type

Analysis TypeChart TypePurpose
DistributionHorizontal and Vertical Bar StackedA stacked bar chart displays data as a series of vertical bars. This type of chart is best suited for representing three series of data, with each series represented by a color stacked in a single bar, for example, the cost for a series of years.
PieA pie chart displays data as a pie, split and colored or patterned. Pie charts are typically used for a single data set (for example, the percentage of consumption for an asset). However, you can choose multiple pie charts for different groups of data.
DonutA donut chart is similar to a pie chart, displaying data as sections of a circle or donut. If, for example, you charted consumption by region on a particular report, you would see the total consumption (the figure) in the center of the donut and the regions as colored sections of the donut. As with the pie chart, you have the option to choose multiple donut charts for multiple groups of data.
Dual Stacked ColumnThis allows you to place multiple series on a chart and separate them vertically so you can visualize all the data at once.
Dual Stacked BarThis allows you to place multiple series on a chart and separate them horizontally so you can visualize all of the data at once.
ScatterIn scatter plots, the X values being graphed usually form a continuous series, like time.

Geographic Chart Type

The following table describes the geographic chart type:

Geographic Chart Type

Analysis TypeChart TypePurpose
NetworkChoroplethThis is a map that uses differences in shading, coloring, or the placing of symbols within predefined areas to indicate the average values of a quantity in those areas.
Geo Pie: A pie chart displays geographical data as a pie, split and colored or patterned.
Geo BubbleThis is a map of a country, a continent, or a region, with areas identified by circles or bubbles.

Create a Dashboard Chart

In this exercise, you create a dashboard chart that is required for one or more subsequent exercises in the course.

Business Example

You want your data to be readily available so that it can be easily viewed. To monitor certain key figures conveniently, you want to create a chart and add it to your dashboard.

Note that when the data values for the exercise include ##, replace ## with the group number that the instructor has provided to you.

Steps

  1. Create a chart and add it to the dashboard you previously created. Choose the Analytics Advanced tile and use the following data:

    FieldValue
    NameT##SalesFcstbyProdfam
    DescriptionSales Forecast Qty by Product Family
    Planning AreaIBP200
    Key FiguresSales Fcst Qty
    Group ByProduct Family 2
    Unit of Measure to IDEA
    Chart TypeBar
    Planning FilterMy Group Products
    1. On SAP Fiori launchpad home page, in the General Planner screen area, choose Analytics Advanced.

      Result

      The Analytics screen appears.
    2. Choose Create → Analytics Chart.

    3. In the Create New Chart dialog box, enter the name T##SalesFcstbaProdfam and the description Sales Forecast Qty by Product Family.

    4. In the Planning Area dropdown list on the right side of the screen, choose your ZUNIFIED planning area.

      To do this, you may need to delete the AAA planning area out of the Search field first. If a Warning dialog box appears with the message All your changes will be lost. Are you sure you want to change the planning area?, choose OK.

    5. In the Key Figures dropdown list, choose the Sales Fcst Qty key figure.

      Note

      You can select up to eight key figures per chart. To remove a key figure, choose the – icon next to each key figure. You can reorder the key figures by selecting and dragging the key figures to the desired position. You can also reorder key figures by choosing the Sorting icon next to the key figures selection.
    6. In the Group By dropdown list, choose TSP Cust. Channel, and then choose Select.

      Note

      You can add multiple attributes.
    7. To filter by Versions, Time Period, or Attributes, use the Filter Bar across the top.

    8. Select Planning FilterMy Group Products, which you created in an earlier exercise.

    9. Select Unit of Measure to IDEA.

    10. Scroll down the right section of the screen to the Type screen area, choose Bar in the Comparison Type section.

    11. On the Information tab add the chart to your dashboard

    12. Choose Save.

    13. Choose the back arrow to proceed with the next part of the exercise.

  2. Create a second chart and add it to the dashboard you previously created and then review your dashboard to validate your charts are there. Use the following data for this second chart:

    FieldValue
    NameT##QtybyQtrProdfam100
    DescriptionProduct Family 100 Qty by Qtr
    Planning AreaIBP200
    Key FiguresSales Fcst Qty, Consensus Demand, Marketing Forecast Qty
    Group ByQuarter
    Unit of Measure to IDEA
    Chart TypeBar
    Filter By Product Family 2FAMILY 100-HEADPHONES
    Filter By Time PeriodsNext Quarter Start to Quarter+3 end, Rolling
    1. On the SAP Fiori launchpad home page, in the General Planner screen area, choose Analytics.

      Result

      The Analytics screen appears.
    2. Choose Create.

    3. In the Create New Chart dialog box, enter the name T##QtybyQtrProdfam100 and the description Product Family 100 Qty by Qtr.

    4. In the Planning Area dropdown list on the right side of the screen, choose IBP200 planning area.

      If a Warning dialog box appears with the message All your changes will be lost. Are you sure you want to change the planning area?, choose OK.

    5. In the Key Figures field, select the following key figures:

      • Consensus Demand

      • Sales Fcst Qty

      • Marketing Fcst Qty

    6. In the Group By field, choose Quarter.

    7. Select the type as Bar.

    8. Choose Unit of Measure to ID EA

    9. Using the Filter Bar, choose Quarter in the Time Periods field. In the From/To field, choose the relevant dates for next quarter start to Q+3 end.

    10. Via the Filter hyperlink at the top, choose Filter → Product Family 2, and then choose FAMILY 100-HEADPHONES.

    11. On the Information Tab add the chart to your dashboard

    12. Choose Save.

    13. Navigate to the Dashboards Advanced app, choose your dashboard and validate that both charts are now displayed on your dashboard.

    14. Return to the SAP Fiori launchpad home page.