Creating an Analytics Drill Down Chart

Objective

After completing this lesson, you will be able to create an Analytics Drill Down Chart.

Analytics Drill Down Chart

Drilldowns are relationships between charts. Planners can build drilldowns to analyze data at a more granular level.

The Analytics Advanced application allows you to build a chart with drilldown functionality. You can navigate between chart levels by double-clicking the object or using the drilldown menu. The parent chart passes the selection information to the child chart. It is no longer necessary to create the charts first and then link them together using a drilldown object. In modern releases of SAP Integrated Business Planning (SAP IBP), drilldown can be built from the parent chart to subsequent chart(s) in a single step.

Using a Drilldown Chart

The figure shows an analytics with a drilldown for two levels.

Create an Analytics Drill Down Chart

Business Example

You are a member of the project team managing the implementation of SAP Integrated Business Planning (SAP IBP). You want to set up the analysis steps to help the planner work. Based on your blueprint, you set up a drill down chart to allow your planner to drill down in a pre-defined sequence:

  • Main Level Consensus Demand by Product Family
  • Level 1 Consensus Demand by Product SubFamily

  • Level 2 Consensus Demand by Product ID

  • Level 3 Consensus Demand by Month

Steps

  1. Create a drill down chart for Consensus Demand key figure and test it out. When it works properly, assign the chart to your T##Dashboard. Use the following data:

    Pie Chart

    FieldValue
    NameT##Consensus Demand Drill Down
    DescriptionConsensus Demand Drill Down ##
    Group ByProduct family 2
    Chart TypePie
    Planning FilterMy Group Products
    Unit of Measure to IDEA

    Pie Chart

    FieldValue
    NameConsensus Demand by Product ID
    DescriptionConsensus Demand by Product ID
    Group ByProduct SubFamily 2
    Chart TypePie
    Planning FilterMy Group Products
    Unit of Measure to IDEA

    Donut Chart

    FieldValue
    NameConsensus Demand by Product ID/Qtr
    DescriptionConsensus Demand by Product ID/Qtr
    Group ByProduct ID 2
    Chart TypeDonut
    MonthCurrent Quarter +3
    RollingSelected
    Unit of Measure to IDEA

    Line Chart

    FieldValue
    NameConsensus Demand Next 6 months
    DescriptionConsensus Demand Next 6 months
    Group ByMonth
    Chart TypeLine
    MonthCurrent + 5 Next Months
    RollingSelected
    Unit of Measure to IDEA
    1. On the 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 right side of the screen in the Basic Settings dialog box, enter the name T##Consensus Demand Drill Down and the description Consensus Demand Drill Down ##.

    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, choose the following key figure:

      Consensus Demand

    6. In the Group By field, choose Product Family 2.

    7. In the Target UoM field, choose EA.

    8. Scroll down and choose Pie in the Distribution Type section.

    9. Select Planning FilterMy Group Products.

    10. Hit Play to display the chart .

    11. Select your pie chart and choose the Drill Down icon on the tool bar above the chart on the right.

      Note

      If you do not see the Drill Down icon, select Edit in the right bottom of the screen.
    12. In the drillldown path, enter the name of Consensus Demand Drilldown with the same description and select OK.

    13. In the Level 1 screen of the analytics chart enter the name Consensus Demand by Product ID and the description Consensus Demand by Product ID.

    14. Change the value in the Group By field to Product ID 2 and keep the value in the Chart Type field with Pie.

    15. Select a section of the pie chart and choose the Drill Down icon on the tool bar above the chart on the right.

    16. Ensure that the drill down path Consensus Demand Drill Down appears as the default and Level 1 Drill Down Attributes: Product Sub-Family is selected.

    17. Select the OK.

    18. In the Level 2 screen of the analytics chart enter the name Consensus Demand by Product ID/Qrt and the description Consensus Demand by Product ID/Qrt.

    19. Change the value in the Group By field to Product ID 2 and Quarter the value in the Chart Type field to Donut.

    20. Using the Filter Bar, choose Quarter in the Time Periods field, and choose the current quarter and each of the next 2 quarters are selected in the From/To field. Choose Rolling.

    21. Select a section of the Donut chart and choose the Drill Down icon on the tool bar above the chart on the right.

    22. Ensure that the drill down path Consensus Demand Drill Down appears as the default and Level 3 Drill Down Attributes: Product ID is selected.

    23. Choose OK.

    24. In the Level 3 screen of the analytics chart enter the name Consensus Demand Next 6 Months and the description Consensus Demand Next 6 Months.

    25. On the Basic tab on the right, change the value in the Group By field to Month and change the value in the Chart Type field to Line.

    26. On the top right of the screen, choose Month, in the Time Periods field, and then validate that the current month and each of the next 5 months are selected in the From/To field.

    27. Save your chart and test out the drill down.

    28. Be aware that you can select more than one Product ID by holding down the Ctrl key and choosing the Drill Down icon to include multiple selections in the next chart.

    29. Drill back to the Main and choose Edit.

    30. On the Information tab, assign your chart to your T## Dashboard and choose Save.

    31. Examine the T## Dashboard to make sure the chart has been assigned.