Creating Custom Alerts

Objective

After completing this lesson, you will be able to create custom alerts.

Custom Alerts

Custom alerts are used to find important or critical supply-chain issues such as inventory shortages, an imbalance of supply and demand, or any unexpected changes in the supply chain.

You can specify the threshold values that will be used to determine issues. For example, you can specify the threshold values for minimum stock levels in a particular location.

Based on these threshold values, the system analyzes the data on the fly and finds where the threshold values are reached. This enables you and your colleagues to react quickly, before a supply chain situation becomes a problem.

It is possible to centralize custom alert definition with different rules applied to different attributes and periods instead of having to create multiple separate definitions. Key figure rules can be applied to different time periods (you can specify a horizon in which alert is more likely to occur, or is more meaningful), or to calculation level attributes (you can specify that alert has to be generated, for example, for a certain customer, or for a certain location).

The following functions may be performed with custom alerts:

  • Define and subscribe to custom alerts.
  • Define an Overview and get an overview of custom alerts.
  • Monitor custom alerts.

Custom alerts are generated by the system and visible to assigned users regarding important or critical supply chain situations. Information contained in the custom alert allows users to analyze and measure the impact of unexpected situations on their business. Users can fine-tune the criteria for alerts to be generated to mitigate issues in the supply chain.

Custom alerts are integrated with cases in SAP Supply Chain Control Tower, which facilitates the tracking and resolution of supply chain problems.

Alerts and their overview can also be added to dashboards to complement the visualization of different aspects of planning in organization.

Machine Learning Algorithms for Custom Alerts

The basic custom alert definition is based on static rules. This works fine if the threshold for the exception condition is known and the data is generally consistent.

If the data is variable and changes to the pattern occur, the static rules may lead to too many or too few alerts. With machine learning, planners can set up alerts without needing to know the exact thresholds.

For example, if you define alerts for your product's sales quantity based on ABC indicator, the rules would be different for Product A (a fast seller), which could be set at 5 percent decline in sales, than for product C, (a slow seller), which could be set for 20 percent decline in sales. This would result in several different alerts to provide the same result, which is to indicate that there has been a drop in your sales quantity. With machine learning, the grouping of your ABC products can be done automatically. Similarly, it allows you to find the outliers in the groupings.

Parameters can be set to get a "healthy" amount of alerts.

Machine Learning adjusts with changing data patterns.

Users can either use ML alert definitions on their own or put them on top of existing alerts with static rules.

You can apply one of the two clustering-based algorithms – k-means or density-spaced spatial clustering of applications with noise (DBSCAN). The number of alerts can be reduced or increased. These types of rules are mainly used for detecting outliers, when you do not know in advance your threshold values, and when the data shifts over time. Additionally, if you change data, the alert definition is automatically adjusted.

The DBSCAN and k-means clustering methods are used to find and group points on a chart that are close together. They also help in identifying the outliers (isolated points in low-density regions outside the groupings).

Recommendation

When working with very large numbers of records, it is recommended to schedule the jobs to improve performance of the alerts monitor, because the operation will time out after ten minutes. When the job to retrieve outliers is scheduled, the results are stored in a buffer, which makes the results faster and easier to retrieve.

Note

Machine learning requires very intensive processing, so it is normal for your operation to take longer than when processing standard alerts.

DBSCAN

DBSCAN requires a minimum of 25 distinct records to be able to complete the clustering accurately. Where there are fewer records, the results are insignificant. For example, you have defined an alert based on PRODID, LOCID, and Day aggregation level. You need at least 25 distinct records to use DBSCAN with the PRODID as an aggregated attribute. In other words, for each product you should have a combination of records of at least five days and five locations.

The DBSCAN algorithm checks attribute groupings and performs clustering on these attributes. In addition to performing outlier determination on one key figure, it uses multiple attributes during the calculation process that make it more accurate than the k-means algorithm.

K-means

The second machine learning algorithm which can be used for defining custom alerts is the k-means algorithm. In contrast to DBSCAN it only uses key figure values and does not consider attributes. The algorithm is also used in the ABC/XYZ segmentation to find clusters based on the segmentation measure’s demand value for ABC and volatility for XYZ.

Comparison of DBSCAN and K-means

The following simple example shows the difference in identification and detection of outliers, which then are marked as an alert.

DBSCAN: The algorithm first checks the quantity key figure and then checks the ABC indicator attribute. As a result, the algorithm identifies the only value of 100 for ABC indicator A as an outlier.

Example for Alert detection with DBSCAN

K-means: Since k-means uses only numerical values in the calculations, the ABC indicator attribute is ignored by the algorithm and only the quantity key figure is considered. As a result, an outlier can’t be identified since there are multiple records with the same values.

Example for k-means detection of Alerts

The Define and Subscribe to Alerts App

A new app had been delivered with SAP IBP 2008.

The app was built as the foundation for the future of creating new types of alerts.

The alert definition and subscription has been fully redesigned to give the best SAP Fiori experience to the users.

  • Alert definitions are shown via a list report, which allows you to easily find what you are searching for
  • Alert definition creation using a wizard that guides the user through the process
  • Alert definition and subscriptions are shown in an object page allowing you to quickly find the needed detailed information

    A step-by-step wizard in the new Define and Subscribe to Custom Alerts app guides you through the creation of definitions and subscriptions for the calculation of custom alerts.

The figure shows the Custom Alerts Wizard.

In the General Information section, you can define the name, description, and planning area for your alert. You can also define the severity of the alert, category, and the version/scenario of the data it should access.

Data Selection Section

Alert Rules Section

Display Options Section

In the Display Options section, you specify how you want to see the alerts displayed on a graph and it also allows you to add complimentary charts. This is a good feature for frequently used KPIs, for example, forecast accuracy that usually is displayed on an analytics chart to track its evolution over time and drill-down.

The last section is Optional. Here, you have the ability to share your alert with other users or user groups. After all sections are filled, you can review the alert and proceed by selecting Create and Subscribe.

You should give your subscription a name and add attribute filters, if needed. You can also fine-tune your display options (for example, choose what key figure values you want to see when you monitor custom alerts). You can also share your subscription.

When all mandatory subscription sections are filled, you can proceed to create an alert. Your alerts count will be displayed and you will be able to hyperlink to the Monitor Custom Alerts app to review the alerts that had been calculated.

Procedure Playbook

Customers have identified a need to standardize responses to situations that occur in their supply chains. Often the process of responding is captured outside of SAP IBP in separate documents that are used as offline references.

The Procedure Playbook app is now able to provide these best practices by enabling the creation of procedure playbooks that help solve supply chain issues. A playbook can contain a detailed description of the issues, the reasons for the issues, and activities and actions to be taken to resolve them.

One of the ways to use this functionality is to add the procedure playbook to custom alerts.

The figure the Procedure Playbook embedded in Intelligent Visibility App

When a custom alert is calculated and displayed in the Monitor Custom Alerts or the Intelligent Visibility app, users with whom the procedure playbook has been shared can view it along with the alert and use it while trying to resolve the issue.

Users can click one of the actions to open the configured link.

The figure shows how to access the Gating Factors from the Procedure Playbook.

The number of times a procedure playbook has been used while trying to resolve issues is displayed. The same applies to the number of times an activity with an action has been used while trying to resolve issues.

It is also possible to view the number of times an activity has been liked, disliked, or has been given a neutral rating.

Procedure playbooks can be shared with other users and user groups. To enable continuous improvement of response, write access can be provided to specific users, so that they can edit and improve the procedure playbook.

Demonstration how to Create Custom Alerts

Create Custom Alerts

Steps

  1. In the Web UI, create a category Demand Class # for the alert by using the Manage Categories app, and then create a custom alert assigned to that category. For the alert creation, use the following data:

    FieldValue
    NameT##Alert1
    DescriptionT##Alert1
    Planning areaZCONTROLTO
    Version/ScenarioBase Version
    SeverityMedium
    CategoryDemand Class ##
    Time HorizonNext Month to Month +3
    Calculation Level AttributesProduct ID, Customer ID (select Add on the right side to add)
    Calculation Level PeriodMonth
    Minimum Consecutive PeriodLeave at Default (1)
    Rule GroupSelect Sales Fcst Qty from the dropdown. Select Percentage instead of Absolute and Greater than. Enter a value of 100. As comparison key figure select Consensus Demand in the right key figure selection field
    Display OptionsChoose default chart type Bar
    Display Options - Key FiguresAccept suggested key figures (2 that were selected in a rule group) and select Unit of Measure To ID EA.
    SubscriptionsName: "T## DP Alert".
    Attribute FiltersAdd Adhoc filtering on Attribute Product ID. Select Product ID: T-F2##, T-F3##, T-F4##
    1. Log in to the Web UI using your ID.

    2. First, create a category for your alert by using the Manage Categories app and creating a Demand Class ## category that is relevant for custom alerts.

    3. On the Alerts group on SAP Fiori launchpad, choose the Define and Subscribe to Custom Alerts tile.

    4. To create a new alert, choose Create.

    5. Enter the information as provided in the table for the four mandatory steps of the alert wizard. To move forward, confirm with Next Step and once all information has been provided, choose Review.

    6. For final alert creation, choose Create and Subscribe.

    7. You are prompted to the subscription screen. Enter the information for the subscription as provided and select Create.

      Result

      In the alert subscription, you will see the number of alerts that were calculated on the top of the screen, as Alert Range Information. You should also be able to see the hyperlink on the right that leads to the Monitor Custom Alerts app.

      Make a note of the amount of alerts that got generated.

  2. Modify the custom alert that you created by incorporating an attribute for the Customer ID in the alert rule and selecting the Customers with your group number ##.

    1. On the Alerts tab, choose the Define and Subscribe to Custom Alerts tile.

    2. Locate your alert T##Alert1 and select Edit.

    3. In the Alert Rule section, choose Add Attribute Rule.

    4. Select Customer ID.

    5. Choose values for customer ID by searching for your ## and then select the customers with Customer ID 2400H_##.

    6. Select Review.

    7. Select Save.

    8. Transition to the Subscription tab and check the number of alerts generated.

      Result

      You should see that you are now generating less alerts, as the alert rule now applies only to one customer, who is the most relevant.
  3. In the Web UI, create a category Supply Class # for the alert by using the Manage Categories app, and create a second custom alert assigned to that category. Use the following data:

    FieldValue
    NameT##Alert2
    DescriptionT##Alert2
    Planning areaZCONTROLTO
    Version / ScenarioBase Version
    SeverityHigh
    CategorySupply Class##
    Time HorizonCurrent Week to Week +5
    Calculation Level AttributesAdd Product ID and Location ID
    Calculation Level PeriodWeek
    Minimum Consecutive PeriodLeave at Default (1)
    Rule GroupSelect Projected Periods of Coverage from the dropdown. Select Absolute and Less than. For the threshold key, enter the value 2.
    Display OptionsChoose default chart type Bar.
    Display Options - Key FiguresSelect Projected Periods of Coverage and Unit of Measure To ID EA.
    SubscriptionsName: "T## SP Alert".
    Attribute FiltersAdd Adhoc filtering on Attribute Product ID. Select Product ID: T-F2##, T-F3##, T-F4##
    1. Log in to the Web UI using your ID.

    2. First, create a category for your alert by using the Manage Categories app and creating a Supply Class ## category that is relevant for custom alerts.

    3. On the Alerts tab, choose the Define and Subscribe to Custom Alerts tile.

    4. To create a new alert, choose Create.

    5. Enter the information as provided in the table for the four steps of the alert wizard, and click Review.

    6. Choose Create and Subscribe.

    7. Enter the information for the subscription as provided and select Create.

      Result

      You will see the number of alerts that were calculated on the top of the screen, as Alert Range Information. You should also be able to see the hyperlink on the right that leads to the Monitor Custom Alerts app.
  4. Observe your two alerts in Monitor Custom Alerts.

    1. On the Alerts tab, choose the Monitor Custom Alerts tile.

    2. In the header section, filter for your subscriptions T## DP Alert and T## SP Alert.

    3. Review the results in the displayed table.

Result

You will see your two subscriptions and total number of alerts calculated.

Demonstration how to Create a Procedure Playbook and Add to the Custom Alert

Create a Procedure Playbook and Add to the Custom Alert

Steps

  1. Create a Procedure Playbook using the Procedure Playbooks app. Use the following table:

    FieldValue
    NameDP_Playbook##
    Available inCustom Alerts
    Planning AreaZCONTROLTO
    Detailed DescriptionFree Text
    Activities

    Name: Basics of demand generation ##

    Action Type: Show Link

    Text to Display: Basics of demand generation ##

    URL: Help.sap.com/ibp

    1. Under the General Planner group, choose the Procedure Playbooks tile.

    2. To create a new procedure playbook, choose Create.

    3. Name the playbook DP_Playbook##.

    4. From the dropdown list, select available in Custom Alerts.

    5. Select Planning Areas: ZCONTROLTO.

    6. In the detailed description, enter a text of your choice, along the lines of: Sales forecast and consensus forecast should be in lockstep. Participants in the Demand Review meeting should be aiming to align with the Sales Managers.

    7. Scroll down to the Activities section and choose Create.

    8. Name the activity Basics of demand generation ##.

    9. For Action Type, choose Show Link.

    10. In the URL box, type Help.sap.com/ibp.

    11. Type Basics of demand generation ## as the text to display.

    12. Choose Create.

    13. Choose Create to save the playbook.

  2. Add your Procedure Playbook to your alert T##Alert1.

    1. Under the Alerts group, choose the Define and Subscribe to Custom Alerts tile.

    2. Locate your T##Alert1 and choose Edit.

    3. Scroll down to the Procedure Playbooks section and choose Add.

    4. Choose your playbook DP_Playbook## and choose OK.

    5. Select Review and then select Save.

      Note

      If you return to the Procedure Playbooks app, you will see that the reference to the custom alert T##Alert1 now appears in the Where-Used List section.

Demonstration how to Display Custom Alerts and Work with Procedure Playbook

Display Custom Alerts and Work with Procedure Playbook

Steps

  1. In the Web UI, monitor your custom alerts. Alerts are displayed by subscription.

    1. Log in to the Web UI with your user ID.

    2. Choose the Alerts tab.

    3. Choose the Monitor Custom Alerts tile.

    4. Under Subscriptions, look for T##_DP_Alert.

    5. Select your subscription and confirm your selection with Go.

    6. Click any Alert to check the details of the alert.

      Note

      You can download a list of alerts for a subscription as a .csv file, or as a Microsoft Excel file. Alternatively, you can select an individual alert, or do a multiselect and choose Go-To → Excel Add-in (or Analytics). This action opens a planning view in SAP IBP, add-in for Microsoft Excel, where selections are made as per the calculation level that was specified in alert definition.
  2. Work with the Procedure Playbook assigned to your alert.

    1. In the details of the T##_DP_Alert, scroll down to the Procedure Playbook section.

    2. Expand the playbook DP_Playbook##.

    3. Check the information using the Detailed Description hyperlink.

    4. Check the information on demand via the hyperlink in the Activities section.

    5. On conclusion, rate the playbook and leave a comment of your choice.

Demonstration how to Run Application Job for Custom Alerts Notification

Run Application Job for Custom Alerts Notification

Steps

  1. Schedule the Custom Alert Notifications job.

    1. In the General Planner section, select the Application Jobs tile.

    2. Select Create to start a new job.

    3. In the Job Template field, select Custom Alert Notifications.

    4. Proceed to Step 2, and select the Start Immediately checkbox.

    5. In Step 3, in the Parameters section, in the Users field, select your Trainee ## user.

    6. Select Schedule.

  2. Check for completion of the job.

    1. In the initial screen of Application Jobs, check for the status of your job.

    2. You can refresh by choosing Go.

    3. Once the job is processed, the status changes to Finished.

    Result

    You should see notifications appearing in the Notifications area in the shell header, it might be required to refresh your browser window. Click on the icon and you will be brought to the Monitor Custom Alerts app, where you can see the details of your alerts, once you select the respective alert subscription.

    Note

    It is possible for the users to receive e-mails notifying them of custom alerts that require attention. E-mail contains the link for the Monitor Custom Alerts app and summary statistics by alert priority, subscription, and status.

    To be able to receive e-mails for custom alerts, the following prerequisites have to be met:

    • E-mailing for SAP Integrated Business Planning custom alert summary has to be enabled in the Settings → Notifications tab of the Me area

    • E-mail addresses have to be maintained via the Maintain Employees app