Configuring PCC with Manage Configuration

Objective

After completing this lesson, you will be able to configure PCC with Manage Configuration

Configuration of Validation Rule Types in the Configuration Workbench

VIDEO

Tips for Completing This Lesson

The content you’re about to complete now provides step-by-step guidance to do the bulk of your configuration tasks in PCC. We recommend going through the lesson slowly, making sure to fully complete each exercise along the way.

Here’s what you can expect to see:

  1. Text-based overviews of each important configuration area.
  2. Video/screenshot walkthroughs of the UI.
  3. Step-by-step exercises or simulations to gain experience configuring tools.

Configuration Tools

You’ll learn how to work with two important tools to configure PCC: Configuration Workbench on the back end and Manage Configuration on the front end. Let’s see each of these tools in action.

Configuration Workbench Overview

The Configuration Workbench is the back end tool that you will use to set up PCC processes. This tool helps you create templates that can then be used in Manage Configuration.

The image shows the Configuration Workbench layout. This contains General operations and more info about these, the object list, and object specific work areas.

Manage Configuration Overview

Manage Configuration is a front-end application that is part of the overall PCC solution. Manage Configuration allows implementation consultants and customer administrators to configure validation rules, KPIs, analytics, and designers for Payroll Control Center. Once the templates are set in Configuration Workbench, you can find the result displayed in Manage Configuration. Configuration workbench provides the context and the logic that feeds validation rules or KPIs in Manage Configuration application. Manage Configuration provides a usable and friendly consumer-centric user interface.

Configuration WorkbenchManage Configuration

Purpose: Supports the back-end set up of PCC objects which will then govern what will be available in the front-end Manage Configuration workspace.

Configuration Workbench helps you define the following:

  • Templates
  • Conditions
  • Boundaries
Technical specialists must configure in the workbench before configuring in Manage Configuration.

Purpose: Supports your work in the front end. The user interface allows you to create your compliance-related rules, KPIs, and other customizable features.

Before we get into the details of each individual PCC object, let's look at how the various PCC objects integrate with each other.

Integration of the Various Objects into the Process: Big Picture

The image shows the overview of the steps of integrating various objects into the process.

Integration of the Various Objects into the Process: Part 1.

The image highlights Part 1 activities of integrating various objects into the process.

Integration of the Various Objects into the Process: Part 2.

The image highlights Part 2 activities of integrating various objects into the process.

Configuration of Validation Rule Types in the Configuration Workbench

Validation Rule Types (VRTs) are some of the important features you’ll set up in Configuration Workbench. A validation rule type collects the relevant technical context (such as country/region and the run time class with all supported variables) for defining a validation rule. Create validation rule types so they can later be used to create and update validation rules in Manage Configuration application in the development or production system.

The image shows an example of a validation rule type. A validation rule type is used to gather the necessary technical context, such as country/region and run time class, along with supported variables, to define a validation rule. These validation rule types are created so that they can be utilized to create and update validation rules within the Manage Configuration application in both development and production systems.

Basic Information:

  • Name, Country/Region
  • Rule Logic, and so on

Dimension: Dimensions are used for defining conditions in the Data section in Manage Configuration

Results: The supported results are used as value help when users define results in the Data section in Manage Configuration

Alert Operation: Alert status operation and reason

Root Cause Analysis:

There are two ways to create a Validation Rule Type using the Configuration Workbench:

  1. ​Copy from an existing validation rule type. You can copy the validation rule type from one of the provided validation rule types as part of the SAP best practice shipment for Payroll Control Center.​
  2. Create a new validation rule type from scratch.

Let’s do a walkthrough of the interface to take a closer look at the following aspects of validation rules:

  • Validation elements
  • Dimensions tab
  • Results tab
  • Alerts Operation tab
  • Root Cause Analysis Tab

Business Example

This practice shows how to create Validation rule types using Configuration Workbench.

Create a Validation Rule Type in the Configuration Workbench

Business Example

As a PCC Consultant, you need to create a new Validation Rule Type.

Steps

  1. Access Configuration Workbench transaction (transaction code PYC_CONF_WB).

    1. Open the Configuration tool favorite folder.

    2. Execute Configuration Workbench transaction.

  2. Copy SBP_GROSS_AND_NET_XX validation rule type.

    1. Switch to the edit mode by choosing the Display/Change icon in the application toolbar.

    2. Choose Validation Rule Type from the dropdown list on the left panel.

    3. Double-click on SBP_GROSS_AND_NET_XX (SBP - VRT GROSS AND NET).

    4. Choose the Copy icon in the application toolbar.

    5. Enter Z##_HRH65_GROSS_AND_NET_XX in the field TO of the Copy Validation Rule Type window. Then click the OK (Enter) button in the window's lower right corner. All the attributes and values, except for the ID, of the original validation rule type are copied to the new validation rule type.

    6. Change the name to a suitable name Z##_HRH65_GROSS_AND_NET_XX, where ## is your unique group number.

  3. Check the basic information tab to ensure that the relevant data is copied from the original validation rule type.

    1. Choose the country or region for which the validation rule type is applicable.

      "*" is used if the type isn’t country/region specific. In other words, country /region * means that only international objects are handled.

    2. Rule Logic is the class the PCC will use to configure the VR in the Manage Configuration and run it at runtime. This class could be redefined according to customer needs.

    3. Alert Entity is PERNR is inherited from the Rule Logic Class.

    4. The Keep resolved flag allows PCC to consider the alert status between the testing and production payroll processes. Activate this option.

  4. Add the Bank details infotype from the Picklist Group to the supported group on the Dimensions tab. Then rename Dimension from Bank Details to Employees Bank details.

    1. Click on the Dimensions tab.

    2. Drag and drop the Bank details infotype from the picklist to the supported group. Choose Yes for the question: Some dimensions depend on other fields. Do you want to include these dependencies? on the Dependencies window.

    3. Once you have successfully added yourself to the supported group, click on the name and change it from Bank Details to Employees Bank Details. Then click the OK (Enter) button in the window's lower right corner.

    4. Save your entry.

  5. On the Results tab, add Employees Bank Details from the Picklist Group to the supported group.

    1. Click on the Results tab.

    2. Drag and drop Employees Bank Details from the picklist to the supported group.

  6. Ensure that all four statuses are checked per the best practice on the Alert Operations tab.

  7. Check the Root Cause Analysis assigned to the validation rule type.

    1. Click on the Root Cause Analysis tab.

    2. Check the assigned RCA Templates.

  8. Validate newly created Validation Rule type configuration.

    1. Choose the Validate icon in the application toolbar to validate your configuration.

    2. Please note the information message in the lower left corner of the screen: "Congratulations! No error is detected."

  9. Save the data. The transport system is disabled in the training system because the configuration does not need to be transferred to the production system. When saving configurations, the system necessitates specifying a transport request in a real-life scenario.

    Congratulations! You have successfully created/copied a new validation rule type.

Configuration of Validation Rules in Manage Configuration

Validation Rules in Manage Configuration

Now that the validation rule types are set up on the back end in Configuration Workbench, it’s time to use the front-end interface, Manage Configuration, to continue the process. The Manage Configuration application is a pack of applications enabling the user to set up PCC objects (VR, KPI, Analytics, Drilldown, and RCA for the time being).

There are two ways to create Validation Rules in Manage Configuration:

  1. Create a new validation rule from scratch.​
  2. Copy from one of the existing validation rules. It is recommended to copy the validation rule from one of the provided validation rules as part of the SAP best practice shipment for Payroll Control Center.

Let’s see what this process looks like in Manage Configuration.

Business Example

This practice shows how to set up validation rules in Manage Configuration.

Create a Validation Rule in Manage Configuration

Business Example

In this exercise, as a PCC consultant or PCC Content Administrator, you will copy a best practice validation rule to create your own. You will copy the standard best practice validation rule that checks anyone over the gross pay threshold of 10,000 USD and create a new validation rule that checks anyone over the gross pay threshold of EUR 5000.

Steps

  1. Call the Manage Configuration App.

    1. Open the Configuration tool favorite folder.

    2. Click on the Payroll Control Center - Manage Configuration application.

    3. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)

  2. Choose Validation Rule and copy an existing validation rule SBP - US - C026 - Employees with Gross pay over the threshold amount (10,000 $).

    1. In the left panel, choose Validation Rules.

    2. To find the required validation rule, enter 026 in the search bar.

    3. Click on SBP - US - C026 - Employees with Gross pay over the threshold amount (10,000 $) validation rule.

    4. Choose the Copy button. If you do not see the copy button, either expand the page using the icon at the top right corner or click on the three dots at the top right corner.

    5. Once copied, a new validation rule is created with the default ID SBP_US_C026_VR_PY_GRS_GT_COPY and the default name Copy from SBP - US - C026 - Employees with Gross pay over the threshold amount ( 10,000 $ ). Please pay attention to the fact that the current Validation Rule remains the same. You must click and open the newer Validation Rule you just created. Close the validation rule you copied from (use the cross sign at the top right corner).

    6. Find the newly copied validation rule - SBP_US_C026_VR_PY_GRS_GT_COPY from the list of validation rules.

    7. Click the newly copied validation rule and then choose Edit.

  3. Adjust the newly created validation rule for Other countries (99), assign the validation rule type created in the previous step, and change the threshold value from 10000 USD to 5000 EUR.

    1. On the Administration tab, check and update the following fields.

      • ID – Change the ID to a unique ID – In this instance, rename it to Z##_HRH65_C026_VR_PY_GRS_GT, where ##- your group number.
      • Name – change the name to – Z##_HRH65 - C026 - Employees with Gross pay over the threshold amount (5000 EUR), where ##- your group number.
      • Validation rule type – Change the validation rule type created in the previous exercise (Z##_HRH65_GROSS_AND_NET_XX).
      • Country /Region– This should match your validation rule type; in this case, select Other Countries (99).
      • After changing the country assignment, notice the seven error messages the system generated in the lower right corner of the screen. Click on the Messages button and check the information: "Value "10_XXXX" doesn’t exist," where XXXX – wage type code. The messages indicate that the SAP PCC Best Practice package validation rule was initially set up for the USA (country grouping 10), utilizing wage types pertinent to this country grouping. However, the country grouping was altered to 'Other countries’(99), and consequently, the wage types no longer match the requirements of the 99 country grouping. Close the Messages window. To fix these errors, you must replace the wage type with those relevant to country grouping 99 in the next step.
      • ICON – no change needed.
      • Alert Entity – no change is needed as it is derived from the validation rule type entered in the previous field.
    2. On the Alert tab, review the following:

      • Definition – A Boolean expression indicating whether the Gross pay is more than the threshold amount; no change is needed here.
      • Key Indicator – The value and the text that appears under the Key indicator in the alert details page on My Alerts, My Team. No change is needed.
      • Details line 1, Detail line 2, and Details line 3 – The text and value that appear as the three lines under Details on the alert details page on My Alerts, My Teams. No change is needed.
    3. On the Auxiliary Calculation tab.

      • Auxiliary Calculation – The variable field is defined with CN_THRESHOLD as the identifier, THRESHOLD as the name, and 10000 as the expression. Click on the Expression field drop-down box, then select the number 10000 in the Expression pop-up box. In the Enter Constant pop-up window, Change the value to 5000 and press OK.
    4. Four different data sections are provided on the data tab. Review the data section to ensure that the wage type defined in the conditions for the data section is relevant to the country for which you are creating the validation rule.

      • Data Section – All Active Employee (DATA_1).

        All active employees are included within the current payroll period (as specified in the conditions), and the selected fields in the results section are applicable for display for these employees. This section is created to supply data to the Key Indicator and Detail Lines Sections, irrespective of other conditions.

      • Data Section – Employee Gross Pay (DATA_2).

        Change the section name to Employee payments.

        This data section selects all the employees with wage type /101 Total gross amount in the current payroll period, whatever the amount of this wage type. The output will show the wage type /101 and the corresponding sum of amounts. The sum operator aggregates all the splits for the payroll period for a given PERNR.

        Since you changed the Country/Region option in the Administration section from USA to Other Countries, you need to select the wage type with the same code /101, but for the Other Countries for the second condition.

        Open wage type drop-down list.

        Enter /101 in the Search bar of the Filter Values pop-up window.

        Choose Total gross amount (/101).

        There is now one less error message in the lower right corner of the screen.

        Click on + Add filter on the right from the Wage type field.

        Choose is Equal to option.

        Open wage type drop-down list.

        Enter /552 in the Search bar of the Filter Values pop-up window.

        Choose Difference prev. Period (/552).

        Click on + Add filter on the right from the Wage type field.

        Choose is Equal to option.

        Open wage type drop-down list.

        Enter /559 in the Search bar of the Filter Values pop-up window.

        Choose Payment (/559).

      • Data Section – Employee Basic Salary (DATA_3).

        This data section enables the selection of all wage types for the basic payments, which, in our exercise, range from M000 to M020, recorded for the employee in the current payroll period. The result of the data section is the wage types themselves and the sum of the amount of the selected wage types. You need to choose the wage type with the code M000 as the lower limit and M020 as the upper limit from the picklist for the Other Countries for the second condition.

        Open wage type drop-down list for the lower limit.

        Enter M000 in the Search bar.

        Choose Hourly wage (M000) of the Filter Values pop-up window.

        Open wage type drop-down list for the upper limit.

        Enter M020 in the Search bar.

        Choose Monthly salary (M020) of the Filter Values pop-up window.

        After this, the system displays only four error messages in the lower right corner.

      • Data Section – Employee Additional Payments (DATA_4).

        This data section provides the amount for the wage type between 5000 and 5555, M200 and M240, CM01 and CM04.

        Open wage type drop-down list for the lower limit.

        Enter 5000 in the Search bar.

        Choose Bonus (5000) from the Filter Values pop-up window.

        Open wage type drop-down list for the upper limit.

        Enter 5555 in the Search bar.

        Choose New Hire Bonus (5555) from the Filter Values pop-up window.

        Open wage type drop-down list for the lower limit.

        Enter M200 in the Search bar.

        Choose Shift Bonus (M200) of the Filter Values pop-up window.

        Open wage type drop-down list for the upper limit.

        Enter M240 in the Search bar.

        Choose Public holiday bonus (M240) from the Filter Values pop-up window.

        Click on ‘+’ Add filter on the right from the Wage type field

        Choose is between option.

        Open wage type drop-down list for the lower limit.

        Enter CM01 in the Search bar.

        Choose Salary increase (CM01) of the Filter Values pop-up window.

        Open wage type drop-down list for the upper limit.

        Enter CM04 in the Search bar.

        Choose Awards (CM04) from the Filter Values pop-up window.

        Following this, your validation rule does not have any errors.

    5. Review and, if necessary, adjust the solutions assigned to the verification rule in the solutions tab.

      A solution is presented as a hyperlink that the payroll administrator can click from both the Alerts and Alert Details pages in My Alerts to correct the alert for the employee. It's also possible to display a PDF, go to documentation, or invoke a mail.

      Review the solution added to the copied validation rule.

      Review the text to be displayed as link text for the solution in the My Alerts application.

      Review the parameters used in your solution definition.

      • Check compensation details in employee profile.

        This solution is designed for the SAP SuccessFactors Employee Central Payroll option, where master data, including compensation information, is maintained via SAP SF Employee Central HRIS system. Therefore, should a Payroll Administrator require modifications to master data within the Employee Central, this solution will enable direct access to the employee's profile via the alert triggered by the verification rule.

        Our course utilizes an on-premise training system for managing employee master data, which means this solution can either remain as is or be removed.

      • Review IT0008.

        This solution is designed for the on-prem option, where master data is maintained via SAP HCM system. Therefore, should a Payroll Administrator require modifications to Basic Pay data, this solution will enable direct access to the employee's 0008 infotype via the alert triggered by the verification rule.

        Open Template drop-down list.

        Choose SBP - PA30 in Webgui.

        Enter 0008 in the Infotype field.

      • Review IT0015

        This solution is also designed for the on-prem option. Therefore, should a Payroll Administrator require modifications to Additional Payments, this solution will enable direct access to the employee's 0015 infotype via the alert triggered by the verification rule.

        Open Template drop-down list.

        Choose SBP - PA30 in Webgui.

        Enter 0015 in the Infotype field.

      • Review IT0014

        Should a Payroll Administrator require modifications to Recurring Payments/Deductions, this solution will enable direct access to the employee's 0014 infotype via the alert triggered by the verification rule.

        Open Template drop-down list.

        Choose SBP - PA30 in Webgui.

        Enter 0014 in the Infotype field.

      • SBP - Link to Documentation

        Should a Payroll Administrator be required to check documentation regarding the specific alert, this solution will enable access to the necessary documentation.

        No changes are necessary to configure this solution.

      • Review IT2010

        Should a Payroll Administrator require modifications to Employee Remuneration Info, this solution will enable direct access to the employee's 2010 infotype via the alert triggered by the verification rule.

        Open Template drop-down list.

        Choose SBP - PA30 in Webgui.

        Enter 2010 in the Infotype field.

    6. Review the Root Cause Analysis (RCA) tab and adjust the Root Cause Analysis (RCA) assigned to the validation rule if necessary.

      A Root Cause Analysis (RCA) is a UI section displayed on the Alert Detail page in My Alerts. The RCA helps the payroll administrator understand the root cause of the alert. This RCA can be a payslip, a form, a list of wage types, a generic overview of the master data, etc.

      • PA Infotype Audit Summary

        Please delete it and assign another one later.

      • Wage Type Difference

        Please delete it.

      • Payslip on Test Payroll results

        Please delete it.

      • Productive Payslips Previous Period

        Please delete it.

      • Productive Payslips Current Period

        Since the SAP PCC Best Practice validation rule was developed for the USA, RCA calls the country-specific configured payslip. We will learn how to adjust this RCA in one of the following exercises. Please delete it and assign it later.

      • Productive Payslips Previous Period

        The same as for the RCA Payslip on Test Payroll results. Please delete it and assign it later.

    7. Dependencies.

      Dependencies are validation rules that determine whether the current processed validation rule will be executed. Typically, if Validation Rule C047 is activated for an employee, the current processed Validation Rule will no longer trigger.

      No changes must be made since the Validation Rule C047 does not include country-specific settings.

  4. Verify the newly created validation rule by utilizing the Preview option. You can preview the results from the Preview button in the application toolbar and proceed as follows:

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

      Note

      The dropdown menu displays a list of process recurrences that have the same country/region as the validation rule and, simultaneously, whose monitoring step has been started.

  5. Activate the newly created validation rule.

    Choose Activate to save the newly created Validation Rule. Correct any errors prompted and choose Activate again when you are done.

Configuration of KPI Types in the Configuration Workbench

Configuration of KPI Types in the Configuration Workbench

A key performance indicator (KPI) is a configurable function that provides the analytical statistics about employee or payroll data changes at the organizational level over time. For example, a KPI might show trends in payroll over last few payroll periods. A KPI type defines complete logic for KPI.

Creating KPI Types

There are two ways to create a KPI Type:

  1. Create a new KPI type from scratch.​
  2. Copy from one of the existing KPI types. ​

You should copy the KPI type from one of the KPI types provided as SAP best practice shipment for Payroll Control Center. Let’s look at the various elements that define the KPI type​ in the Workbench.

Business Example

This practice shows how to set up KPI types in the Configuration Workbench.

Create a KPI Type in Configuration Workbench.

Business Example

As a PCC consultant, you need to create a new KPI type.

Steps

  1. Access Configuration Workbench transaction (transaction code PYC_CONF_WB).

    1. Open the Configuration tool favorite folder.

    2. Execute Configuration Workbench transaction.

  2. Copy PCC Best Practice SBP_GROSS_AND_NET_XX KPI Type.

    1. Switch to the edit mode by choosing the Display/Change icon in the application toolbar.

    2. Choose KPI Type from the dropdown list on the left panel.

    3. Double-click on SBP_GROSS_AND_NET_XX (SBP - KPIT GROSS AND NET).

    4. Choose the Copy icon in the application toolbar.

    5. Enter Z##_HRH65_GROSS_AND_NET_XX in the field To of the Copy Validation Rule Type window. Then click the OK (Enter) button in the window's lower right corner. All the attributes and values, except for the ID, of the original validation rule type are copied to the new validation rule type.

    6. Change the name to a suitable name

      Z##_HRH65_GROSS_AND_NET, where ## is your unique group number.

  3. Check the basic information tab to ensure the relevant data is copied from the original KPI type.

    1. Choose the country or region for which the validation rule type is applicable.

      "*" is used if the type isn’t country/region specific. In other words, country /region * means that only international objects are handled.

    2. Check that CL_PYC_TSK_KPI_DEFAULT KPI Configuration - Sample Implementation is assigned as KPI Logic to the newly created KPI Type. KPI Logic is the class the PCC will use to configure the KPI in the Manage Configuration and run it at runtime. This class could be redefined according to customer needs.

  4. Add the Bank details infotype from the Picklist Group to the supported group on the Dimensions tab. Then rename Dimension from Bank Details to Employees Bank details.

    1. Click on the Dimensions tab.

    2. Drag and drop the Bank details infotype from the picklist to the supported group. Choose Yes for the question: Some dimensions depend on other fields. Do you want to include these dependencies? on the Dependencies window.

    3. Once you have successfully added yourself to the supported group, click on the name and change it from Bank Details to Employees Bank Details. Then click the OK (Enter) button in the window's lower right corner.

    4. Expand the Employee Bank Details group to check the dimension fields included. Confirm that the group consists of the fields from infotype 0009.

  5. Add Employee Bank Details from the Picklist Group to the supported group on the Results tab.

    1. Click on the Results tab.

    2. Drag and drop Employee Bank Details from the picklist to the supported group.

    3. Expand Employee Bank Details supported group and verify which result fields are included. Ensure that the group encompasses many statistical indicators, such as average and count, in addition to the fields of infotype 0009.

  6. Validate newly created KPI type configuration.

  7. If the validation is successful, save the new KPI Type.

Configuration of KPIs in Manage Configuration

KPIs in Manage Configuration

Let’s now look at how to work with KPIs using Manage Configuration.

There are four key KPI tabs in Manage Configuration:

  1. Administration
  2. Tiles
  3. Data
  4. Details

Let’s go through them one by one.

Administration Tab

The Administration tab stores the following KPI attributes:

  • ID: Unique ID for the KPI.
  • Name: KPI name that is displayed in the monitoring step.
  • KPI Type: Key driver that dictates what data can be assessed in the KPI data section.
  • Country/Region: Country for which this KPI is applicable. By default, this is derived from the KPI type.
  • Icon: Customizable from the UI5 icon list.
  • Tile Content: KPI is displayed as a tile in the monitoring step. You can select the type of the chart for the KPI.
The image shows the Administration tab. It stores KPI attributes

Tiles Tab and Charts

The Tiles tab is used to define all aspects of a KPI chart. Depending on the chart type selected in the attribute section, you can configure different elements and structures from this area.

All charts have two common attributes:

  • General: contains definitions for the header, icon, and footer.
  • Auxiliary Calculation: contains calculations that can be made inside the tile. This section can be used to define reusable data or to cut complex calculations into smaller portions.

The screenshot contains an example of a Line chart. In this example, you can see that in addition to the two common attributes previously mentioned, the chart also contains the tabs for text, threshold, and data points 1 to 6.

The screenshot features a Line chart example that includes tabs for text, threshold, and data points 1 to 6, in addition to the two common attributes previously mentioned.

Business Example

This practice shows how to set up KPIs in Manage Configuration.

Configure KPIs in Manage Configuration

Business Example

In this exercise, as a PCC consultant or PCC Content Administrator, you will copy a KPI provided as part of the best practice package to create your own KPI.

Steps

  1. Call the Manage Configuration App.

    1. Open the Configuration tool favorite folder.

    2. Click on the Payroll Control Center - Manage Configuration application.

    3. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)

  2. Choose KPIs and copy an existing KPI SBP - K001 - Count of employees with gross pay.

    1. In the left panel, choose KPIs.

    2. Click SBP - K001 - Count of employees with gross pay.

    3. Choose the Copy button. If you do not see the copy button, expand the page using the icon at the top right corner or click on the three dots at the top right corner.

    4. Once copied, a new validation rule is created with the default ID SBP_XX_K001_NBR_OF_EE_GRO_COPY and the default name Copy from SBP – K001 – Count of employees with gross pay.

      Please pay attention to the fact that the current KPI remains the same. You must click and open the newer KPI you just created. Close the KPI you copied from (use the cross sign at the top right corner).

    5. Find the newly copied KPI - name Copy from SBP – K001 – Count of employees with gross pay from the KPIs list.

    6. Click the newly copied validation rule and then choose Edit.

  3. Adjust the newly created KPI for Other countries (99) and assign the KPI type created in the previous step.

    1. On the Administration tab, check and update the following fields:

      • ID – Change the ID to a unique ID – In this instance, rename it to Z##_HRH65_K001_NBR_OF_EE_GRO, where ## - your group number.
      • Name – change the name to – Z##_HRH65_K001 - Count of employees with gross pay, where ## - your group number.
      • KPI type – Update the KPI type to Z## _HRH65 - KPIT GROSS AND NET created in the previous exercise 8.
      • Country /Region – Select 99 Other Countries from the drop-down list.

        After changing the country assignment, notice the six error messages the system generated in the lower right corner of the screen. Click on the Messages button and check the information about errors regarding the analytics designers. The messages indicate that the SAP PCC Best Practice package KPIs were initially set up for the USA (country grouping 10), utilizing settings pertinent to this country. However, the country grouping was altered to 'Other countries’(99), and consequently, the settings no longer match the requirements of the 99 country grouping. You must delete the designers to fix these errors. In the subsequent exercise, we will learn how to configure Analytic Designers. Once configured, they can be assigned to the KPIs in the next step. Close the Messages window.

      • ICON – no change needed.
      • Tile Content – no change needed (leave it as Line Chart).
    2. On the Tile tab, review the following:

      • General – header, Icon, and Footer text is defined here; no change is needed.
      • Top Text – As you can see in the line chart, a variable that counts the number of employees is assigned—left and right reference points in the Line chart. Right, one is the count in the current month, and left is the count prior to 6 months. This is useful to see the trend. In this case, review it, but no change is required.
      • Bottom Text – No change is needed.
      • Threshold – No change is needed.
      • Point 1 to Point 6 – These correspond to the six points in the line chart, as shown in the line chart tile. Review the variables assigned, including the count of employees. No change is required.
      • Auxiliary Calculation – An auxiliary calculation can be defined; no change is needed.
    3. Six different data sections are defined on the data tab. Review the data section to ensure that the wage type defined in the conditions for data sections is relevant to the country for which you are creating the KPI. In this example, wage type /101 is the correct wage type for Gross Pay. If the wage type does not need to be changed, then no further change is required for any of the below data sections.

      • Data Section – Count of EEs having a gross Current Period (CNT_GROSS_M)

        This data section provides the result as a count of employees for the current period. To ensure that only the relevant data is selected, conditions are defined, and only the active employee in the current period (M) with Gross Pay (/101) greater than 0 is selected. You must choose the wage type from the drop-down list with the /101 code configured for "Other countries."

      • Data Section – Count of EEs having a gross previous Period (M-1) (CNT_GROSS_M_1)

        This data section provides the result as a count of employees for the current period-1. To ensure that only the relevant data is selected, conditions are defined, and only the active employee in the current period- 1 (M-1) with Gross Pay (/101) greater than 0. Again, you must select the wage type from the drop-down list with the /101 code configured for "Other countries".

      • Data Section – Count of EEs having a gross previous Period (M-3) (CNT_GROSS_M_3)

        This data section provides the result as a count of employees for the current period- 3. Conditions are defined to ensure that only the relevant data is selected, and only the active employee in the current period- 3(M-3) with Gross Pay (/101) greater than 0 is selected. Select the wage type from the drop-down list with the /101 code configured for "Other countries."

      • Data Section – Count of EEs having a gross previous Period (M-4)(CNT_GROSS_M_4)

        This data section provides the result as a count of employees for the current period-4. To ensure that only the relevant data is selected, conditions are defined, and only the active employee in the current period- 4(M-4) with Gross Pay (/101) greater than 0. Select the wage type from the drop-down list with the /101 code configured for "Other countries."

      • Data Section – Count of EEs having a gross previous Period (M-5) (CNT_GROSS_M_5)

        This data section provides the result as a count of employees for the current period-4. To ensure that only the relevant data is selected, conditions are defined, and only the active employee in the current period- 5(M-5) with Gross Pay (/101) greater than 0. Select the wage type from the drop-down list with the /101 code configured for "Other countries."

        Note

        The variables defined in the alert section for creating an expression or displaying the data should be available as results in the data section. If you need to specify additional data for KPI, on the Data tab, choose the Add icon to create variables.
    4. On the Details tab- Analytics Designer is assigned to the KPI, Review the assigned analytics designer. Since the SAP PCC Best Practice KPIs were developed for the USA, KPI Drill Downs calls the country-specific settings. We will learn how to adjust these KPI Details in one of the following exercises.

    • Employees with Gross amounts over six payroll periods by FT/PT

      Please delete this details.

    • Count of Employees with Gross amounts over six payroll periods by Cost Center

      Please delete this details.

    • Count of Employees with Gross amounts over six payroll periods by FT/PT

      Please delete this details.

    • Sum of Gross amounts over six payroll periods by Cost Center

      Please delete this details.

    • Sum of Gross amounts over six payroll periods by FT/PT

      Please delete this details.

    • Employees with Gross amounts over six payroll periods by Cost Center

      Please delete this details.

  4. Verify the newly created KPI by utilizing the Preview option. You can preview the results from the Preview button in the application toolbar and proceed as follows:

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  5. Activate the newly created KPI.

    Choose Activate to save the newly created KPI. Correct any errors prompted and choose Activate again when you are done.

Configuring Analytics Designer Type in the Configuration Workbench

Configuring the Analytics Designer Type in the Configuration Workbench

An analytics designer type provides a technical context for defining an analytics designer in the Manage Configuration app. The Analytics Designer is used for root cause analysis (RCA) and for providing KPI details. ​

You can create analytics designers so that they can be used to create and update analytics designers for root cause analysis and KPI details in Manage Configuration application.

Recommended practice is to copy a standard or existing analytics designer type by selecting a standard or existing analytics designer type that you want to copy from, and choosing the Copy icon in the application toolbar.

All the attributes and values, except for the ID, of the original analytics designer type are copied to the new analytics designer type.

The image shows the Analytics Designer Type option on the PCC Configuration Workbench screen

Let’s look at the four basic elements that are defined in an analytics designer type:

  • ID: Unique identifier for the analytics designer type.
    • Name
    • Country: Choose the country or region for which it is applicable. An asterisk (*) is used if the type isn’t country or region specific.
  • Design logic: Used for entering the class for selecting the data according to the parameters, providing the results, allowing operations, and so on.
    • SAP standard class CL_PYC_TSK_DN_DEFAULT provides dimensions and results in the analytics designer.
    • Customers can also create their own customized logic in this.
  • Category: There are two categories, RCAs and KPI details.
    • RCAs are assigned to the validation rule to display detailed information.
    • KPIs are assigned to the analytics chart to display detailed information.
  • Entity Type: Alert entity is defined in the design logic.
    • The parameter defined in the alert entity should be the same as defined in the validation rule type.
    • This is because the RCAs are assigned to the validation rules.

Business Example

This practice shows how to set up analytics designer types in the Configuration Workbench.

Configure Analytics Designer Type in Configuration Workbench

Business Example

Steps

  1. Access Configuration Workbench transaction (transaction code PYC_CONF_WB).

    1. Open the Configuration tool favorite folder.

    2. Execute Configuration Workbench transaction.

  2. Copy PCC Best Practice SBP_KPIDDT_XX (SAP Best Practices KPI Drill Down Type) Analytics Designer Type.

    1. Switch to the edit mode by choosing the Display/Change icon in the application toolbar.

    2. Choose Analytics Designer Type from the dropdown list on the left panel.

    3. Double-click on SBP_GROSS_AND_NET_XX (SBP - KPIT GROSS AND NET).

    4. Choose the Copy icon in the application toolbar.

    5. Enter Z##_HRH65_KPIDDT_XX in the field To of the Copy Analytics Designer Type window. Then click the OK (Enter) button in the window's lower right corner. All the attributes and values of the original Analytics Designer Type, except for the ID, are copied to the new Analytics Designer Type.

    6. Change the name to a suitable name Z## HRH65 KPI Drill Down Type, where ## is your unique group number.

  3. Check the basic information tab to ensure the relevant data is copied from the original Analytics Designer Type.

    1. Choose the country or region for which the validation rule type is applicable.

      "*" is used if the type isn’t country/region specific. In other words, country /region * means that only international objects are handled.

    2. Check that CL_PYC_TSK_DN_DEFAULT Employee-Based Designer Implementation is assigned as Design Logic to the newly created Analytics Designer Type. Design Logic is the class the PCC will use to configure the Designer in the Manage Configuration and run it at runtime. This class could be redefined according to customer needs.

    3. Check that KD KPIs Details are assigned as the Category.

    4. Entity Type is PERNR inherited from the Design Logic Class.

  4. Add the Bank details infotype from the Picklist Group to the supported group on the Dimensions tab. Then rename Dimension from Bank Details to Employees Bank details.

    1. Click on the Dimensions tab.

    2. Drag and drop the Bank details infotype from the picklist to the supported group. Choose Yes for the question: "Some dimensions depend on other fields. Do you want to include these dependencies?" on the Dependencies window.

    3. Once you have successfully added yourself to the supported group, click on the name and change it from Bank Details to Employees Bank Details. Then click the OK (Enter) button in the window's lower right corner.

  5. Add Employee Bank Details from the Picklist Group to the supported group on the Results tab.

    1. Click on the Results tab.

    2. Drag and drop Employees Bank Details from the picklist to the supported group.

  6. Validate the newly created Analytics Designer Type configuration.

  7. If the validation is successful, save the new Analytics Designer Type.

  8. Repeat steps 2-7 to create an Analytic Designer Type by copying SBP_RCA_XX (SBP - SAP Best Practices Root Cause Analysis Type) to a new RCA Analytics Designer Type for RCA in validation rules.

    1. Double-click on SSBP_RCA_XX (SBP - SAP Best Practices Root Cause Analysis Type).

    2. Choose the Copy icon in the application toolbar.

    3. Enter Z##_HRH65_RCA_XX in the field To of the Copy Analytics Designer Type window. Then click the OK (Enter) button in the window's lower right corner. All the attributes and values of the original Analytics Designer Type, except for the ID, are copied to the new Analytics Designer Type.

    4. Change the name to Z## HRH65 Root Cause Analysis Type, where ## is your unique group number.

    5. Check the basic information tab to ensure the relevant data is copied from the original Analytics Designer Type.

    6. Choose the country or region for which the validation rule type is applicable.

      "*" is used if the type isn’t country/region specific. In other words, country /region * means that only international objects are handled.

    7. Check that CL_PYC_TSK_DN_DEFAULT Employee-Based Designer Implementation is assigned as Design Logic to the newly created Analytics Designer Type. Design Logic is the class the PCC will use to configure the Designer in the Manage Configuration and run it at runtime. This class could be redefined according to customer needs.

    8. Check that RC Root Cause Analysis is assigned as the Category.

    9. Entity Type is PERNR inherited from the Design Logic Class.

    10. Add the Bank details infotype from the Picklist Group to the supported group on the Dimensions tab. Then rename Dimension from Bank Details to Employees Bank details.

    11. Add Employee Bank Details from the Picklist Group to the supported group on the Results tab.

    12. Validate the newly created Analytics Designer Type configuration.

    13. Save the new Analytics Designer Type.

Creation of Root Cause Analysis (RCA) in Manage Configuration

What is Root Cause Analysis (RCA)?

Root cause analysis (RCA) provides details for an alert and helps payroll administrators analyze the detailed data for resolving a specific alert. The analytics designer tool is used to configure root cause analysis.

Payroll administrators and payroll process managers can drill down to the root cause of an alert displayed on the Alert Details page in Alert Management and Team Management.

Business Example

This practice shows how to configure a root cause analysis (RCA) in Manage Configuration. In this configuration, you start from scratch, in the Analytics Designer

Business Example

This practice shows how to configure a root cause analysis (RCA) based on SAP Best Practices in the Analytics Designer.

Business Example

This practice shows how to configure a root cause analysis (RCA) in Manage Configuration.

Business Example

This practice shows how to create a new RCA with Label-Value Pairs in Manage Configuration

Configure a Root Cause Analysis (RCA) with program output from scratch in Manage Configuration

Business Example

The root cause analysis (RCA) provides error details for an alert and helps payroll administrators analyze the detailed data to resolve this alert. Use the analytics designer to configure root cause analysis so you don't have to write your own code for root cause analysis in the rule logic. Payroll administrators and payroll process managers can drill down to the root cause of an alert displayed on the Alert Details page in Alert Management, Team Management, and the (Team) Monitoring step in Process Management.

As a PCC Consultant or PCC Content Administrator, you will create several new RCAs in Manage Configuration UI by coping RCA from the SAP PCC Best Practice package and creating three new RCAs from scratch.

Steps

  1. Prepare a variant for the program H99_HRFORMS_CALL.

    1. Call transaction SA38 in the backend.

    2. Enter H99_HRFORMS_CALL in the report name field.

    3. Run the report by clicking the clock icon (Execute) in the upper left corner of the screen.

    4. Create a variant for this program H99_HRFORMS_CALL with the following options:

      • Payroll Period section: Period 2 Other Payroll Period
      • Payroll area: define the payroll area assigned to your group ( X1-X9 for groups 01-09, Y0-Y9 for groups 10-19, Z0-Z9 for groups 20-29, ZS -for group 30).

        (In the customer's project, any valid payroll area in the system could be specified. Since when the RCA is called, the PCC will dynamically replace this value with the payroll area of the employee for whom the validation rule was triggered, and the system generates an alert. We recommend using the payroll area assigned to your group in this exercise to enable each participant to prepare their program variant.)

      • Print Prog Selection section:
      • Country grouping: 99
      • Form Class: Choose Payslip from the dropdown list.
      • Form Name:Choose Z99_HRH65 (or Z99_IMRAN_SALARY) from the dropdown list.
      • Variant: Choose PCC_PAYSLIP_99 from the dropdown list
      If you wish to use the SAP standard Payslip Form SAP_PAYSLIP_*, where * - country code to display employee payslip, in your customer project, ensure that the standard HR form SAP_PAYSLIP_** is active. If not, then execute transaction HRFORMS and activate as follows: Maintain Variants for the Standard Programs | SAP Help Portal
    5. Save the variant for the program H99_HRFORMS_CALL with

      • Name: GR##_HRH65, where ## - your group number.
      • Description: GR## Payslip for PCC.
  2. Create a new RCA with program output from scratch via Manage Configuration. The program output displays the output of a program run for a specific employee as a result of a payroll step. Use ID Z##_ HRH65_RCA_ Program_Output and name Z##_ HRH65_RCA - Test Payroll Payslip based on the current period for your new RCA. A similar RCA is included in the Best Practice package; you can create a new RCA by copying it. In the next exercise, we will copy two more new RCAs with program output. In this exercise, we'll create a new RCA from scratch to fully understand all the configuration options. This will also allow us to fully appreciate the benefits of working with Best Practice.

    1. Call the Manage Configuration App.

      • Open the Configuration tool favorite folder.
      • Click on the Payroll Control Center - Manage Configuration application.
      • To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)
    2. In the left panel, choose Designer and click on the button "+" Create Analytics Designer In the upper right corner of the screen. Then, expand the page using the icon Full Screen in the top right corner. On the Administration tab, enter the following information for the fields:

      • ID: Z##_HRH65_RCA_Program_Output , where ## - your group number.
      • Name: Z##_HRH65_RCA_- Test Payroll Payslip based on the current period
      • Type: Choose from the dropdown list Z##_HRH65_Root Cause Analysis Type created in the previous exercise.
      • Country /Region: Choose 99 Other countries from the dropdown list.
      • Content – Choose ‘Program Output as PDF’ from the dropdown list.

      ICON – Choose sap-icon://course-program or any other from the dropdown list.

  3. On the Program tab, choose a program H99_HRFORMS_CALL whose output is to be displayed in the alert details of an employee and specify a program variant for this report that you prepared in the previous step.

    1. Click on the Name drop-down box.

    2. Enter H99_HRFORMS_CALL in the Search bar of the Program pop-up screen.

    3. Choose the Call Print Program for HR Forms Workplace (H99_HRFORMS_CALL) program.

    4. Click on the Variant drop-down box.

    5. Choose the variant GR## Payslip for PCC, created in the previous step.

  4. Configure a data section that will select data from the current payroll period and specify the fields you want to use for running the program as data section results.

    1. Choose the Data tab.

    2. Click on the Add Data Section button.

    3. Enter the following information for the fields:

      To generate a payslip using a report for the employee for whom the alert was generated, you must transfer the "Personal number" and "Payroll area" fields as parameters to the selection screen H99 HRFORMS CALL report from the Alert and information about the current payroll period. Some fields, such as the payroll period, are available by default, so you don't need to worry about them. Still, in most cases, for the fields to be available, you must configure the data sections, specifying the data selection conditions and the desired result fields.

      • ID: DATA_1
      • Name: Employee Number
      • Result: (The drop-down list for this Result field of the data section lists all supported groups and fields from the Results tab of the Analytics Designer Type configured in the Configuration Workbench. You can choose any field and use it for your configuration. If you can’t find some required fields in the drop-down list, you need to add the corresponding Result Group via Configuration Workbench for specific Analytics Designer Type.)

        For the report H99_HRFORMS_CALL selection screen parameters, you need to get Personal Number and Payroll Area, so choose these fields as Results of the Data_1 section:

        • Click on the Result drop-down box.
        • Enter Employee Number in the Search bar of the Result Values pop-up screen.
        • Choose Employee Number (from Employee Demographics group).
        • Click on the Result drop-down box.
        • Enter the Payroll area in the Search bar.
        • Choose the Payroll area (from Organizational assignment Group).
      • Condition: Using the necessary fields from the Dimensions tab of the Analytics Designer Type configured in the Configuration Workbench, you can provide any conditions for obtaining the necessary information from the system. If you can’t find some required fields in the drop-down list, add corresponding Group via Configuration Workbench for specific Analytics Designer Type.
        • Click on the drop-down box under the Conditions section.
        • Enter Payroll period in the Search bar of the Dimensions pop-up screen.
        • Choose Payroll period (from Payroll Periods and Dates Dimension group).
        • Choose Is equal operator.
        • Choose Current payroll period from the drop-down list for the Filter Values pop-up window.
  5. To overwrite the selections defined in the program variant, specify the parameter on the selection screen and provide the parameter value you want to use for running the program.

    1. Come back to the Program tab

      Click on the "+" Add Selections.

      Choose Personnel Number (PNPPERNR) from the drop-down list for the Parameters pop-up windows.

      Operator: Use the suggested by default. Is Equal.

      Choose the drop-down box for the Value field.

      Click on the Pen icon (New Item) icon on the top left corner of the pop-up window Item Expression.

      Choose Variable option.

      Enter Employee Number in the search bar of the Variables pop-up window.

      Choose Employee Number result field from the newly created 'Employee Number' data section, which was configured in the previous step of the exercise.

      Close Expression pop-up window.

      Click on the "+" Add Selections

      Choose Period Selection: Payroll Area (PNPXABKR) from the drop-down list.

      Operator: Use the suggested by default. Is Equal.

      Choose the drop-down box for the Value field.

      Click on the Pen icon (New Item) icon on the top left corner of the pop-up window Expression.

      Choose Variable option.

      Enter the Payroll area in the search bar of the Variables pop-up window.

      Choose Payroll area result field from the newly created 'Employee Number' data section.

      Close Expression pop-up window.

      Click on the "+" Add Selections.

      Choose Period Selection: Year (PNPPABRJ) from the drop-down list.

      Operator: Use the suggested by default. Is Equal.

      Choose the drop-down box for the Value field.

      Click on the Pen icon (New Item) icon on the top left corner of the pop-up window Expression.

      Choose Variable option.

      Choose Current Period -Year result field from the Constant result group.

      Close Expression pop-up window.

      Click on the "+" Add Selections.

      Choose Period Selection: Period (PNPPABRP) from the drop-down list.

      Operator: Use the suggested by default. Is Equal.

      Choose the drop-down box for the Value field.

      Click on the Pen icon (New Item) icon on the top left corner of the pop-up window Expression.

      Choose Variable option.

      Choose Current Payroll Period result field from the Constant result group.

      Close Expression pop-up window.

      The system maintains two categories of payroll results: test and productive. For this Root Cause Analysis (RCA), the test payroll results are required for the employee in question. The same variant will be utilized to generate payslips through the H99_HRFORMS_CALL program for both test and productive payroll results. Configuration parameters transferred from the alert to the report selection screen allow you to dynamically send the personnel number, payroll area, and payroll period and define which payroll results, test or productive, should be selected for the employee.

      To proceed, select the P_TPY parameter and set it to true.

      Click on the "+" Add Selections.

      Enter P_TPY in the search bar of the Parameters pop-up window.

      Choose P_TPY(P_TPY) from the drop-down list.

      Operator: Use the suggested by default. Is Equal.

      Choose the drop-down box for the Value field.

      Click on the Pen icon (New Item) icon on the top left corner of the pop-up window Expression.

      Choose Variable option.

      Enter True in the search bar of the Variables pop-up window.

      Choose True result field from the Constant result group.

      Close Expression pop-up window.

  6. Test the new RCA from the preview button at the top right of the RCA detail page.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  7. Activate the new RCA.

    1. Choose Activate to save the newly created RCA.

Create New RCAs as Copy from the SAP PCC Best Practice Package

Business Example

As a PCC Consultant or PCC Content Administrator, you will create two new RCAs in Manage Configuration UI by coping from the SAP PCC Best Practice package.

Steps

  1. Configure RCA (with program output) by coping SBP_RCA_PROD_PAYROLL_PREV_PERD (SBP - RCA - PRODUCTIVE PAYSLIP PREVIOUS PERIOD) a Root Cause Analysis (RCA) from the SAP PCC Best practice package.

    1. Call the Manage Configuration App

      • Open the Configuration tool favorite folder.
      • Click on the Payroll Control Center - Manage Configuration application.
      • To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)
    2. Search SBP_RCA_PROD_PAYROLL_PREV_PERD (SBP - RCA - PRODUCTIVE PAYSLIP PREVIOUS PERIOD), click on it, and then choose the Copy button. If you do not see the copy button, expand the page using the icon in the top right corner or click on the three dots in the top right corner.

    3. Once copied, a new RCA is created with the default ID -SBP_RCA_PROD_PAYROLL_PREV_COPY and the default name Copy from SBP - RCA - Productive Payslip Previous Period. Close the RCA you copied from (use the cross sign in the top right corner). Find the newly copied SBP_RCA_PROD_PAYROLL_PREV_COPY from the list of RCAs. Click the newly copied RCA and then choose Edit.

    4. On the Administration tab, check and update the following fields

      • ID – Change the ID to Z##_HRH65_RCA _PROD_PAYROLL_PR, where ## - your group number.
      • Name – change the name to Z##_HRH65_RCA - Productive Payslip Previous Period results, where ## - your group number.
      • Type – Update the RCA type to the one created earlier (Z##_HRH65_Root Cause Analysis Type).
      • Country /Region – Choose 99 Other countries.
      • Content – keep the picklist value Program Output as PDF.
      • ICON – no change needed.
    5. On the Program tab, review the following

      • Name – keep the Call Print Program for HR Forms Workplace (H99_HRFORMS_CALL) in this field.
      • Variant – Select the variant from the drop-down list. You already created this variant in the previous exercise.
      • Review the Parameters for the report selection screen. They are almost the same as those you configured in the previous exercise, except for the payroll period. The value from the previous period will be transferred, not the current one.
    6. The data section has the same configuration you created in the previous exercise.

    7. Activate the new RCA.

  2. Configure RCA (with program output) by coping SBP_RCA_PROD_PAYROLL_CURRENT(SBP - RCA - PRODUCTIVE PAYSLIP CURRENT PERIOD) a Root Cause Analysis (RCA) from the SAP PCC Best practice package.

    Repeat the steps 1.2 -1.7 for the SBP_RCA_PROD_PAYROLL_CURRENT (SBP - RCA - Productive Payslip Current Period.

    • Use ID – Change the ID to Z##_HRH65_RCA_PROD_PAYROLL_CR, where ## - your group number.
    • Name – change the name Z##_HRH65_RCA - Productive Payslip Current Period, where ## - your group number.

Configure RCA with the Table via Manage Configuration

Business Example

As a PCC Consultant or PCC Content Administrator, you will create a new RCA with the table from scratch.

Create a new RCA with the table with four columns: Wage Type code, Wage Type Amount for the previous payroll period, Wage Type Amount for the current payroll period, the difference between the amount of the previous period and the amount of the current period.

The new RCA will display basic wage types (0008 IT), Bonuses (0015 IT), and secondary wage types /101 Total gross amount, /559 Payment and /552 Difference prev. Period.

It’s necessary to split wage types into three groups: Basic Pay, Bonuses, and Payments.

Selecting a wage type between the M000 and M020 codes is necessary for basic pay.

For bonuses, the wage type should be from 5000 to 5555 WT code.

Select/101, /552, and /559 for the Payments group.

Steps

  1. Create a new RCA with ID Z##_HRH65_RCA_TABLE_WT and name Z##_HRH65 _RCA Wage Type delta between prev and current payroll periods.

    1. Call the Manage Configuration App

      • Open the Configuration tool favorite folder.
      • Click on the Payroll Control Center - Manage Configuration application.
      • To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)
    2. In the left panel, choose Designer and click on the button "+" Create Analytics Designer In the upper right corner of the screen. Then, expand the page using the icon Full Screen in the top right corner. On the Administration tab, enter the following information for the fields:

      • ID: Z##_HRH65_RCA _TABLE_WT, where ## - your group number.
      • Name: Z##_HRH65_RCA Wage Type delta between prev and current payroll periods.
      • Type: Choose from the dropdown list Z##_HRH65_Root Cause Analysis Type created in the previous exercise.
      • Country /Region: Choose 99 Other countries from the dropdown list.
      • Content – Choose Table from the dropdown list.
      • ICON – Choose sap-icon://table-chart or any other from the dropdown list.
  2. Configure two data sections for selecting required wage types from the previous and current payroll periods.

    1. Choose the Data tab.

    2. Click on the Add Data Section button.

    3. Enter the following information for the fields:

      • ID: DATA_1.
      • Name: Current period.
      • Result:
        • Click on the Result drop-down box.
        • Enter Wage type in the Search bar of the Result values pop-up window.
        • Choose Wage type from the Payroll Results: Results Table Group.
        • Click on the Result drop-down box.
        • Enter Sum in the Search bar of the Result values pop-up window.
        • Choose Sum of 'HR Payroll: Amount' from the Payroll Results: Results Table Group.
      • Condition:

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose the Payroll period (from Payroll Periods and Dates Dimension group).

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose Is equal operator.

        Choose Current Payroll period from the drop-down list for the Filter Values pop-up window.

        Click on the "+" Add condition button opposite the section title Conditions.

        Click on the drop-down box for the new Condition field.

        Enter wage type in the search bar on the Dimensions pop-up screen.

        Scroll down to the Payroll Results: Results Table Group and choose the field Wage Type.

        Choose Is between operator.

        Click on the drop-down box for the low-limit field.

        Enter M000 in the search bar on the Dimensions pop-up screen.

        Choose Hourly wage (M000) under Other countries group.

        Click on the drop-down box for the upper-limit field.

        Enter M020 in the search bar on the Dimensions pop-up screen.

        Choose Monthly salary (M020) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is between operator.

        Click on the drop-down box for the low-limit field.

        Enter 5000 in the search bar on the Dimensions pop-up screen.

        Choose Bonus (5000) under Other countries group.

        Click on the drop-down box for the low-limit field.

        Enter 5555 in the search bar on the Dimensions pop-up screen.

        Choose New Hire Bonus (5555) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /101 in the search bar on the Dimensions pop-up screen.

        Choose Total gross amount (/101) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /552 in the search bar on the Dimensions pop-up screen.

        Choose Difference prev. Period (/552) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /559 in the search bar on the Dimensions pop-up screen.

        Choose Payment (/559) under Other countries group.

    4. Click on the "+" Add Data button.

      Enter the following information for the fields:

      • ID: DATA_2.
      • Name: Previous period.
      • Result:

        Click on the Result drop-down box.

        Enter Wage type in the Search bar of the Result values pop-up window

        Choose Wage type from the Payroll Results: Results Table Group.

        Click on the Result drop-down box.

        Enter Sum in the Search bar of the Result values pop-up window.

        Choose Sum of HR Payroll: Amount from the Payroll Results: Results Table Group.

      • Condition:

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose Payroll Period (from Payroll Periods and Dates Dimension group).

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose Is equal operator.

        Choose Previous payroll period from the drop-down list for the Filter Values pop-up window.

        Click on the "+" Add condition button opposite the section title Conditions.

        Click on the drop-down box for the new Condition field.

        Enter wage type in the search bar on the Dimensions pop-up screen.

        Scroll down to the Payroll Results: Results Table Group and choose the field Wage Type.

        Choose Is between operator.

        Click on the drop-down box for the low-limit field.

        Enter M000 in the search bar on the Dimensions pop-up screen.

        Choose Hourly wage (M000) under Other countries group.

        Click on the drop-down box for the upper-limit field.

        Enter M020 in the search bar on the Dimensions pop-up screen.

        Choose Monthly salary (M020) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is between operator.

        Click on the drop-down box for the low-limit field.

        Enter 5000 in the search bar on the Dimensions pop-up screen.

        Choose Bonus (5000) under Other countries group.

        Click on the drop-down box for the low-limit field.

        Enter 5555 in the search bar on the Dimensions pop-up screen.

        Choose New Hire Bonus (5555) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /101 in the search bar on the Dimensions pop-up screen.

        Choose Total gross amount (/101) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /552 in the search bar on the Dimensions pop-up screen.

        Choose Difference prev. Period (/552) under Other countries group.

        Click on the "+" Add filter button to the right of the condition for selecting wage types.

        Choose Is Equal operator.

        Click on the drop-down box for the low-limit field.

        Enter /559 in the search bar on the Dimensions pop-up screen.

        Choose Payment (/559) under Other countries group.

  3. Configure four table columns.

    To move to the Column configuration, choose the corresponding tab.

    1. Click on the Add Table Column button.

    2. Click on the Expression drop-down box for the Column 1.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Wage Type as the column header.

      Push the OK button and close the the Expression pop-up window.

      For customer projects, SAP recommends using the Text (expression) or Text ("&DE&<DataElement>") function rather than the Constant option for header/text configuration to simplify solution maintenance and support. Utilizing a constant for text translation into multiple languages or text replacement can significantly increase complexity.

      Transaction SE11 contains text elements from the PCC Best Practice Package. Select the Data Type radio button, enter the prefix SBP*, and use the drop-down box. A list of the text elements will appear for selection. If an appropriate text is not found, the same transaction can be used to create a new Data Element.

      We will use Constants as a starting point to explore the available configuration options.

      Click on the Expression drop-down box for the Column 1 Under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter Wage Type in the search bar.

      Choose Wage Type result field from the Current period data section.

      Close Expression pop-up window.

    3. Click on the Add table column button.

      Click on the Expression drop-down box for Column 2.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Previous period as the column header.

      Push the OK button and close Expression pop-up window.

      Click on the Expression drop-down box for the Column 2 Under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter Sum in the search bar.

      Choose Sum of 'HR Payroll: Amount' result field from the Previous period data section.

      Close Expression pop-up window.

    4. Click on the Add table column button.

      Click on the Expression drop-down box for Column 3.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Current period as the column header.

      Push the OK button and close Expression pop-up window.

      Click on the Expression drop-down box for the Column 3 Under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter Sum in the search bar.

      Choose Sum of 'HR Payroll: Amount' result field from the Current period data section.

      Close Expression pop-up window.

    5. Click on the Add table column button.

      Click on the Expression drop-down box for Column 4.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Delta as the column header.

      Push the OK button and close Expression pop-up window.

      Click on the Expression drop-down box for the Column 4 Under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter Sum in the search bar.

      Choose Sum of 'HR Payroll: Amount' result field from the Previous period data section.

      Click on the Pen icon (New Item) next to the variable and choose the "-" button at the top of the Item Details pop-up window.

      Click on the Pen (New Item) icon next to the "-" and choose the Variables option.

      Choose Sum of 'HR Payroll: Amount' result field from the Current data section.

      Expression for the Column 4 should look like this:

      Auxiliary Calculations can be utilized to determine the difference. This configuration feature will be examined in Exercise 17.

      Close Expression pop-up window.

  4. Configure the sorting option of the new RCA.

    To move to the Sorting configuration, choose the corresponding tab.

    1. Click on the "+" Add column button under the Sorting.

      Choose Column 1 from the drop-down list.

      Leave Ascending for the Direction field.

  5. Test your RCA from the preview button.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  6. Add the data section key and test your RCA with the updated configuration.

    1. Click on the Data tab.

    2. Click on the Result values drop-down box for Data Section Key.

    3. Enter Wage in the Search bar.

    4. Choose Wage Type from the Payroll Results: Results Table group.

    5. Test your RCA from the preview button.

      • Select a recurrence from the dropdown menu on the Preview screen.
      • Choose show result.
      • Check the configuration and close the Preview window.
      • Close Preview window.

    By default, data sections are joined on the main entity (e.g., root cause analysis designers use the alert entity employee number).

    Data from different sections must be joined on further criteria in specific scenarios.

    Example: Data section 1 reads the wage type list from the previous payroll period, and Data section 2 reads the wage type list from the current payroll period. These two data sections have to be merged further on the wage type to get a meaningful result with wage type comparison.

    The data section key defines further joining keys (outer join) between data sections (in the example above, Wage Type).

    Data section keys are populated to each data section as results automatically.

  7. Add the Grouping section for the new RCA and test your RCA with the updated configuration. You need to split wage types for the three different groups: 01_Group Basic Pay (wage type M000-M020), 02_Group Bonus (wage type 5000-5555), and 03_Group Payment (/101, /552, /559.)

    1. Click on the Grouping tab.

      • Click on the drop-down box for Expression Background Database ID field.
      • Click on the Pen icon (New Item) icon in the top left corner of the Expression pop-up window.
      • Choose Function option, then choose If.
      • Click on the first Pen icon (New Item) in the Expression pop-up window after IF(. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]-[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Operators, then choose Comparison Operators >=.
      • Click on the blank between >= and comma; the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose Constants, enter M000 in the field on the Enter Constant pop-up window, and push the OK button.
      • Click on the blank between "M000" and the comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the option Operators, choose AND under Logical Operators on the Select an Operator pop-up window, and push on the OK button.
      • Click on the blank between "AND" and the comma; a new Pen icon (New Item) will appear in this place. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]—[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Operators option, and then select Comparison Operators <=.
      • Click on the blank between <= and the comma, and the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Constants option, enter M020 in the field in the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter 01_GROUP in the field on the Enter Constant pop-up window, and push the OK button.
    2. Click on the new Pen icon (New Item) after the next comma, choose the Choose Function option, and select If.

      • Click on the Pen icon (New Item) in the Expression pop-up window after the second function IF(. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]-[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Operators, then choose Comparison Operators >=.
      • Click on the blank between >= and comma; the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose Constants, enter ‘5000’ in the field on the Enter Constant pop-up window, and push the OK button.If you use numeric values ​​as constants, they must be enclosed in single quotes. Customer wage types must start with a number.
      • Click on the blank between "5000" and the comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the option Operators, choose AND under Logical Operators on the Select an Operator pop-up window, and push on the OK button.
      • Click on the blank between "AND" and the comma; a new Pen icon (New Item) will appear in this place. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]—[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Operators option, and then select Comparison Operators <=.
      • Click on the blank between <= and the comma, and the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Constants option, enter ‘5555’ in the field in the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter 02_GROUP in the field on the Enter Constant pop-up window, and push the OK button.
    3. Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter 03_GROUP in the field on the Enter Constant pop-up window, and push the OK button. The expression should look like this:

      Close Expression pop-up window.

    4. Click on the drop-down box for Expression Background Database Name field. Repeat steps 7.1-7.2, but instead, 01_GROUP uses Basic Pay, 02_GROUP – BONUS, and 03_GROUP – Payment.

      • Click on the Pen icon (New Item) icon in the top left corner of the Expression pop-up window.
      • Choose Function option, then choose If
      • Click on the first Pen icon (New Item) in the Expression pop-up window after IF(. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]-[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Operators, then choose Comparison Operators >=.
      • Click on the blank between >= and comma; the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose Constants, enter M000 in the field on the Enter Constant pop-up window, and push the OK button.
      • Click on the blank between "M000" and the comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the option Operators, choose AND under Logical Operators on the Select an Operator pop-up window, and push on the OK button.
      • Click on the blank between "AND" and the comma; a new Pen icon (New Item) will appear in this place. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]—[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Operators option, and then select Comparison Operators <=.
      • Click on the blank between <= and the comma, and the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Constants option, enter M020 in the field in the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter Basic Pay in the field on the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the next comma, choose the Choose Function option, and select If.
      • Click on the Pen icon (New Item) in the Expression pop-up window after the second function IF(. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]-[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Operators, then choose Comparison Operators >=.
      • Click on the blank between >= and comma; the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose Constants, enter ‘5000’ in the field on the Enter Constant pop-up window, and push the OK button.
      • Click on the blank between "5000" and the comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the option Operators, choose AND under Logical Operators on the Select an Operator pop-up window, and push on the OK button.
      • Click on the blank between "AND" and the comma; a new Pen icon (New Item) will appear in this place. Choose Variables option. Enter Wage to the search bar and choose Wage Type from the Current period data section.
      • Click on the blank between [Current-period]—[Wage type] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Operators option, and then select Comparison Operators <=.
      • Click on the blank between <= and the comma, and the new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose the Constants option, enter 5555 in the field in the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter BONUS in the field on the Enter Constant pop-up window, and push the OK button.
      • Click on the new Pen icon (New Item) after the comma, choose the option Constants, enter Payment in the field on the Enter Constant pop-up window, and push the OK button.

        The expression should look like this:

        Close Expression pop-up window.

  8. Test your RCA from the preview button.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

    4. Close Preview window.

  9. Activate configuration.

Create a new RCA with Label-Value Pairs in Manage Configuration

Business Example

Configure root cause analysis with the table layout by configuring an analytics designer in Manage Configuration. The simple form layout consists of label-value pairs. You can define multiple groups to group different label-value pairs.

As a PCC Consultant or PCC Content Administrator, you will create a new RCA with Label-Value Pairs.

Steps

  1. Create a new RCA with ID Z##_HRH65_RCA _LVP and name Z##_HRH65_RCA_ Employee Information.

    1. Call the Manage Configuration App.

      • Open the Configuration tool favorite folder.
      • Click on the Payroll Control Center - Manage Configuration application.
      • To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)
    2. In the left panel, choose Designer and click on the button "+" Create Analytics Designer In the upper right corner of the screen. Then, expand the page using the icon Full Screen in the top right corner. On the Administration tab, enter the following information for the fields:

      • ID: Z##_ HRH65_RCA_ LVP, where ## - your group number.
      • Name: Z##_ HRH65_RCA_ Employee Information.
      • Type: Choose from the dropdown list Z##_HRH65_Root Cause Analysis Type created in the exercise.
      • Country /Region: Choose 99 Other countries from the dropdown list.
      • Content – Choose Label-Value Pairs from the dropdown list.
      • ICON – Choose sap-icon://value-help or any other from the dropdown list.
  2. Configure the data section to select the required fields: Company Code, Capacity Utilization Level, Formatted Name of Employee or Applicant, Bank Keys, and Bank account number for the current payroll periods.

    1. Choose the Data tab.

    2. Click on the Add Data Section button.

    3. Enter the following information for the fields:

      • ID: DATA_1.
      • Name: Employee Info.
      • Result:

        Click on the Result drop-down box.

        Enter code in the Search bar of the Result values pop-up window.

        Choose Company code from the Organizational assignment Group.

        Click on the Result drop-down box.

        Enter Sum in the Search bar of the Result values pop-up window.

        Choose Sum of 'HR Payroll: Amount' from the Payroll Results: Results Table Group.

        Click on the Result drop-down box.

        Enter Name in the Search bar of the Result values pop-up window.

        Choose Formatted Name of Employee or Applicant from Organizational Assignment Group.

        Click on the Result drop-down box.

        Enter Capacity in the Search bar of the Result values pop-up window.

        Choose Capacity Utilization Level from Basic Pay Group.

        Click on the Result drop-down box.

        Enter key in the Search bar of the Result values pop-up window.

        Choose Bank keys from Employee Bank Details Group.

        Click on the Result drop-down box.

        Enter account in the Search bar of the Result values pop-up window.

        Choose Bank Account Number from Employee Bank Details Group.

      • Condition:

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose the Payroll period (from Payroll Periods and Dates Dimension group).

        • Choose Is equal operator.
      • Choose Current payroll period from the drop-down list for the Filter Values pop-up window.
    4. Configure two label-value pairs in the data section.

      • Choose the corresponding tab to move to the Value-Label Pairs configuration.
      • Click on the Add Object Group button.
    5. Enter Data_1 in the field Name.

      Click on the Expression background database drop-down box for the field Title.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Employee Information as the data section header.

      Push the OK button and close Expression pop-up window.

      Click on "+" Add Item button.

      Click on the Expression background database drop-down box for the field Label.

      Choose Functions option.

      Choose Text.

      Click on the first Pen icon (New Item) icon after Text ( in the Expression pop-up window.

      Choose Constants option.

      Enter &DE&ASR_EMPLOYEE_NAME, as the label ,where Prefix &DE& allows to display a text element label.

      Push the OK button and close Expression pop-up window.

      Click on the Expression background database drop-down box for the field Value.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter Employee name in the search bar.

      Choose Formatted Name of Employee or Applicant from Employee Info data section.

      Push the OK button and close Expression pop-up window.

      Click on "+" Add Item button.

      Click on the Expression background database drop-down box for the field Label.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option.

      Choose Text.

      Click on the first Pen icon (New Item) icon after Text ( in the Expression pop-up window.

      Choose Constants option.

      Enter &DE&BURKS, where BURKS is -the technical name of the Company code field. Prefix &DE& allows to display a standard field label.

      Push the OK button and close Expression pop-up window.

      Click on the Expression background database drop-down box for the field Value.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option and choose Concatenate.

      Click on the first Pen icon (New Item) icon after Concatenate ( in the Expression pop-up window.

      Choose Variables option, enter code in the search bar, and choose Company code from the Employee Info data section.

      Click on the first Pen icon (New Item) icon after the first comma.

      Choose Functions option, and select Concatenate.

      Click on the Pen icon (New Item) icon after the second function Concatenate ( in the Expression pop-up window.

      Choose Constants option, and enter in the Enter a constant pop-up window field.

      Click on the Pen icon (New Item) icon after "-" in the Expression pop-up window.

      Choose Functions option, and select Text.

      Click on the Pen icon (New Item) icon after the second function Text ( in the Expression pop--up window).

      Choose Variables option, enter the code in the search bar, and choose Company code from the Employee Info data section.

      The expression should look like:

      Click on "+" Add Item button.

      Click on the Expression background database drop-down box for the field Label.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option.

      Enter Text.

      Click on the first Pen icon (New Item) icon after Text ( in the Expression pop-up window.

      Choose Constants option.

      Enter &DE&BSGRD, where BSGRD -is the technical name of the Capacity utilization level field from 0008 IT.

      Prefix &DE& allows the display of a standard field label.

      Push the OK button and close Expression pop-up window.

      Click on the Expression background database drop-down box for the field Value.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option and choose Concatenate.

      Click on the first Pen icon (New Item) icon after Concatenate ( in the Expression pop-up window

      Choose Variables option, enter capacity in the search bar, and choose Capacity utilization level from the Employee Info data section.

      Click on the first Pen icon (New Item) icon after the first comma.

      Choose Functions option, and select Concatenate.

      Click on the Pen icon (New Item) icon after the second function Concatenate ( in the Expression pop-up window.

      Choose Constants option, and enter in the Enter a constant pop-up window field.

      Click on the Pen icon (New Item) icon after "-" in the Expression pop-up window.

      Choose Functions option, and select Text.

      Click on the Pen icon (New Item) icon after the second function Text ( in the Expression pop--up window.

      Choose Variables option, enter capacity in the search bar, and choose Capacity utilization level From Employee Info data section.

      Push the OK button and close Expression pop-up window.

    6. Scroll up and click on "+" Add a group opposite Label-Value Pairs section.

      Enter Data_2 in the field Name.

      Click on the Expression background database drop-down box for the field Title.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Bank details as the data section header.

      Push the OK button and close Expression pop-up window.

      Click on "+" Add Item button.

      Click on the Expression background database drop-down box for the field Label.

      Choose Functions option, then select Text.

      Click on the Pen icon (New Item) icon after Text (.

      Choose Variables option.

      Enter key in the search bar.

      Choose Bank keys from Employee Info data section.

      Close Expression pop-up window.

      Click on the Expression background database drop-down box for the field Value.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter key in the search bar.

      Choose Bank keys from Employee Info data section.

      Push the OK button and close the Expression pop-up window.

      Click on "+" Add Item button.

      Click on the Expression background database drop-down box for the field Label.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constants option.

      Enter Bank account number.

      Push the OK button and close Expression pop-up window.

      Click on the Expression background database drop-down box for the field Value.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option, enter account in the search bar, and choose Bank account number from the Employee Info data section.

      Push the OK button and close Expression pop-up window.

  3. Test your RCA from the preview button.

  4. Activate your configuration.

Assign new RCAs to the Validation Rule in Manage Configuration

Business Example

In this exercise, you will complete the new validation rule configuration as a PCC consultant or PCC Content Administrator. You will assign the new RCAs to the validation rule Z##_HRH65_C026_VR_PY_GRS_GT created in exercise 7.

Steps

  1. Call the Manage Configuration App.

    1. Open the Configuration tool favorite folder.

    2. Click on the Payroll Control Center - Manage Configuration application.

    3. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)

    4. In the left panel, choose Validation Rule.

  2. Choose validation rule Z##_HRH65_C026_VR_PY_GRS_GT, click on it, and then choose the Edit button in the top right corner.

  3. Assign 5 RCAs created in exercises 11-14.

    1. Click on the Root Cause Analysis tab.

    2. Choose "+" Add under the section name.

    3. Scroll down to the new section.

    4. Click on Template in the drop-down box.

    5. Enter Z## in the Search bar of Root Cause Analysis Template pop-up window.

    6. Choose Z##_ HRH65_RCA - Test Payroll Payslip based on the current period.

    7. Scroll up and repeat steps 3.1 -3.6 for Z## HRH65 RCA - Productive Payslip Previous Period.

    8. Scroll up and repeat steps 3.1 -3.6 for Z## HRH65 RCA - Productive Payslip Currents Period.

    9. Scroll up and repeat steps 3.1 -3.6 for Z##_HRH65_RCA -Wage Type delta between prev and current payroll periods.

    10. Scroll up and repeat steps 3.1 -3.6 for Z##_HRH65_RCA -Employee Information.

  4. Verify the newly updated validation rule by utilizing the Preview option.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  5. Activate the newly updated validation rule.

    Choose Activate to save the newly created Validation Rule. Correct any errors prompted and choose Activate again when you are done.

  6. Choose validation rule Z##_HRH65_C003 - Employees returning from long absence( maternity/sickness)

  7. Replace

    • SBP - RCA - Employee Organizational Details to Z##_HRH65_RCA_ Employee Information,
    • SBP - RCA - Master Data Audit Log,
    • SBP - RCA - Simple Wage Type List to Z##_HRH65_RCA Wage Type delta between prev and current payroll periods,
    • SBP - RCA – Wage type comparison current period vs previous period to Z30_HRH65_RCA - Wagetype comparison current period vs previous period
    • SBP - RCA - Payslip based on current period Test Payroll results toZ##_HRH65_RCA - Payslip based on current period Test Payroll results,
    • SBP - RCA - Productive Payslip Previous Period to Z##_HRH65_RCA - Productive Payslip Previous Period,
    • SBP - RCA - Productive Payslip Current Period to Z##_HRH65_RCA - Productive Payslip Current Period
    • PA Infotype Audit Summary No changes are necessary.
  8. Verify the newly updated validation rule by utilizing the Preview option.

  9. Activate the newly updated validation rule.

Creation of Drill-Downs in Manage Configuration

Drill-Downs in Manage Configuration

KPI details provide detailed information for a KPI chart and help payroll process managers to analyze the detailed data for the KPI. Payroll process managers can see KPI details by selecting a KPI chart in the Monitoring step in My Processes.

Like the configuration of root cause analysis (RCA), in the case of KPI details, the data can be organized, calculated and presented as an analytics output in three different ways.

  • Program Output: The program output shows the output of a program run due to a payroll step.
  • The table layout allows group rows or sort columns for the table content for an employee. An example would be the list of key wage type presented in a table layout format for the employee.
  • The label-value pair: The simple form layout consists of label-value pairs, and multiple groups to group different label-value pairs, for example, organization data for an employee to present.

Business Example

This practice shows how to create a new Drill-Downs in Manage Configuration.

Business Example

In this practice, you will create a KPI drill down. This will be used to set up and use auxiliary calculations in and with Manage Configuration

Create a KPIs Drill Down Object in Manage Configuration

Business Example

Steps

  1. Call the Manage Configuration app.

    1. Open the Configuration tool favorite folder.

    2. Click on the Payroll Control Center - Manage Configuration application.

    3. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You used the same username and password to log into the training system.)

  2. Copy an existing KPI Drill Down SBP_XX_DD01_01_EE_GRS_PSA_FTPT (SBP - DD01 - 01 - Full-time (FT) / Part-time (PT) Employees with Gross amounts over last 6 payroll periods).

    1. In the left panel, choose Designer.

    2. Copy an existing KPI Drill down as follows:

    3. Search the Drill down SBP_XX_DD01_01_EE_GRS_PSA_FTPT (SBP - DD01 - 01 - Full-time (FT) / Part-time (PT) Employees with Gross amounts over last six payroll periods), click on it, and then choose the Copy button. If you do not see the copy button, expand the page using the icon in the top right corner or click on the three dots in the top right corner.

    4. Once copied, a new KPI Drill Down is created with the default ID SBP_XX_DD01_01_EE_GRS_PSA_FTPT_COPY and the default name Copy from SBP - DD01 - 01 - Full-time (FT) / Part-time (PT) Employees with Gross amounts over last six payroll periods.

    5. Close the drill down from where you copied it (use the cross sign in the top right corner).

    6. Find the newly copied Drill Down SBP_XX_DD01_01_EE_GRS_PSA_FTPT_COPY from the list of Drill Downs.

  3. Configure the newly created KPI Drill Down.

    1. Click the newly copied Drill-Down and then choose Edit.

    2. On the Administration tab, check and update the following fields:

      • ID – Change the ID to a unique ID – In this instance, rename it to Z##_HRH65_DD01_01_EE_GRS_PSA, where ## is your group number.
      • Name – change the name to Z##_HRH65 - DD01 - 01 - Full-time (FT) / Part-time (PT) Employees with Gross amounts over last six payroll periods.
      • Type – Update the KPI type to the one created in the previous exercise 8 Z## KPI Drill Down Type.
      • Country /Region – Choose 99 Other Countries.
      • Content – keep the picklist value Table.
      • ICON – no change needed.
      • Transport request – Select the transport request if the field is available in your system (this field may not be enabled in the training system)

    3. On the Column tab, review the following: Column 1 to column 8 – All these columns are column headers for the table. Each column has a header with the function "Text"- this function with the literal &DE&<Data Element> to return the data element description. No change is needed for the expression. Review the alignment and the width. No change is needed.

    4. Perform the following:

      • Row Template tab – notice that the same column is available. In this section, we define the variable against each column. Later, the data section defines which variables are available for binding. Review column 1 to column 8. Click on the expression for Row content. You will notice in the figure below that the first is the data section ID (Data 1), and the second one (Employee Number) is the variable's name. This image shows a screen with the expression for row contentReview all the Row content. No change is required.
      • Sorting tab – column 1 (Employee Number) is the sorting column in ascending order. In this example, no change is required.
      • Grouping tab – no change is needed. Review the ID and Name. You will notice that the variables defined in the data section are used to group the table data.
      • Auxiliary Calculation – An auxiliary calculation can be defined; no change is needed. Only six data sections are defined on the Data tab. Review the data section. Since Best Practice objects were initially set up for the US and we have reassigned the country to other countries, resolving the emerging configuration errors is necessary. This can be done by replacing US-specific wage types with those relevant to Other countries.
      • Data Section – DATA_1 – Change the section name to Employee Gross Pay Current Period.

        This data section selects all the employees with wage type /101 Total gross amount in the current payroll period, whatever the amount of this wage type. The output will show the wage type /101 and the corresponding sum of amounts. The sum operator aggregates all the splits for the payroll period for a given PERNR.

        Because you changed the "Country/Region" option in the Administration section from "USA" to "Other Countries," you need to select the wage type with the same code /101, but for the Other Countries for the second condition.

      • Open wage type drop-down list – Enter /101 in the Search bar of the Filter Values pop-up window.

        Choose Total gross amount (/101).

      Note

      You will also notice that each data section has a condition where the Dimension is defined as the Wage type and value are filtered for wage type /101. This ensures that only relevant data is extracted and improves performance. Another dimension is the payroll period; as mentioned before, only one payroll period per data section is defined, hence the need for 6 data sections.

      One data section represents one payroll period. Since this Drill Down aims to provide the Gross pay over the six periods, one data extractor per period is needed. So, you should replace the wage type for all the rest of the data sections.

      Another important thing to notice is the results—the variables are defined in the results field. If you If you need any additional variables, feel free to add them.

  4. Test your KPIs Drill Down using the preview button.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  5. Activate the configuration.

    1. Choose Activate to save the newly created Validation Rule. Correct any errors prompted and choose Activate again when you are done.

    2. Next, you will need to Assign Drilldown to the KPI that you created in Exercise 9. This way, when the Payroll Process Manager clicks on the KPI tile in the process monitoring step, they can drill down and view detailed data. Note that you can create multiple drill-down options for each KPI and present your data in various ready-to-use ways.

Create a KPI Drill Down to set up and use Auxiliary Calculations in and with Manage Configuration

Business Example

As a PCC Consultant or PCC Content Administrator, you will create a KPIs Drill Down from scratch in Manage Configuration. This exercise will guide us through setting up and utilizing Auxiliary Calculations within Manage Configuration.

The system offers two options for displaying an employee's employment status: the Employment Percentage in IT0007 and the Capacity Utilization Level in IT0008.

The Payroll Process Manager asked you to configure the KPI Drill Down with the following information: Personal Number, Employee Name, Company Code, and Cost Center. The last column should show "Yes" if the Employment Percentage in IT0007 is equal to the Capacity Utilization Level in IT0008 and "No" if it is not.

Steps

  1. Call Manage Configuration.

    1. Call the Manage Configuration App.

    2. Open the Configuration tool favorite folder.

    3. Click on the Payroll Control Center - Manage Configuration application.

    4. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)

  2. Configure a new Drill Down according to the customer’s requirements.

    1. In the left panel, choose Designer and click on the button + Create Analytics Designer In the upper right corner of the screen. Then, expand the page using the icon Full Screen in the top right corner. On the Administration tab, enter the following information for the fields:

      • ID: Z##_HRH65_DD_FULL_PART_EE, where ## - your group number.
      • Name: Z##_HRH65_DD Full Part Employee.
      • Type: Choose from the dropdown list Z##_HRH65_KPI Drill Down Type created in the exercise 8.
      • Country /Region: Choose 99 Other countries from the dropdown list.
      • Content: Choose Table from the dropdown list.
      • ICON: Choose sap-icon://create-entry-time or any other from the dropdown list.
    2. Create a new data section.

      Choose the Data tab.

      Click on the Add Data Section button.

      Enter the following information for the fields:

      • ID: DATA_1
      • Name: Employee Info
      • Result:

        Click on the Result drop-down box.

        Enter Name in the Search bar of the Result values pop-up window

        Choose Formatted Name of Employee or Applicant from the Organizational assignment Group.

        Click on the Result drop-down box.

        Enter Number in the Search bar of the Result values pop-up window.

        Choose Employee Number from the Employee Demographics Group.

        Click on the Result drop-down box.

        Enter code in the Search bar of the Result values pop-up window

        Choose Company code from the Organizational assignment Group.

        Click on the Result drop-down box.

        Enter cost in the Search bar of the Result values pop-up window

        Choose Cost Center from the Organizational Assignment Group.

        Click on the Result drop-down box.

        Enter Capacity in the Search bar of the Result values pop-up window

        Choose Capacity Utilization Level from Basic Pay Group

        Click on the Result drop-down box.

        Enter employment in the Search bar of the Result values pop-up window

        Choose Employment percentage from the Planned Working Time Group

      • Condition:

        Click on the drop-down box under the Conditions section.

        Enter Payroll period in the Search bar of the Dimensions pop-up screen.

        Choose the Payroll period (from Payroll Periods and Dates Dimension group)

      • Choose Is equal operator.
      • Choose Current payroll period from the drop-down list for the Filter Values pop-up window.
    3. Configure Auxiliary Calculations

      Click on the Auxiliary Calculations tab.

      Click on the Add Auxiliary Calculations button.

      Enter the following information for the fields:

      • ID: EXP1
      • Name: DIFF
      • Expression

        Click on the Expression background database drop-down box for the field Label.

        Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

        Choose Functions option, and select ABS - Absolute Value.

        Click on the first Pen icon (New Item) icon after ABS ( in the Expression pop-up window.

        Choose Variables option.

        Enter capa in the Search bar.

        Choose Capacity Utilization Level from Employee Info data section.

        Click on the blank between [Employee Info]-[ Capacity Utilization Level] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), and choose the option "-"at the top of the popup window, Item Details.

        Click on the blank between "-" and ); a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item).

        Choose the option Variables option.

        Enter employment in the Search bar.

        Choose Employment percentage from Employee Info data section.

        Close Expression pop-up window.

    4. Configure four table columns.

      To move to the Column configuration, choose the Corresponding tab.

      Click on the Add Table Column button.

      Click on the Expression drop-down box for the Column 1.

      Click on the Pen icon (New Item) icon on the top right corner of the Expression pop-up window.

      Choose Functions option, then select Text.

      Click on the first Pen icon (New Item) icon after Text (.

      Choose Constants option.

      Enter &DE&PERNR_D in the bar of the Enter a Constant pop-up window.

      Close Expression pop-up window.

      Scroll down and click on the Expression drop-down box for Column 1 under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option

      Enter Number in the Search bar of the Variables pop-up window

      Choose Employee Number from the Employee Info Group.

      Close Expression pop-up window.

      Scroll up and click on the "+" Add column button.

      Click on the Expression drop-down box for the Column 2.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option, then select Text.

      Click on the first Pen icon (New Item) icon after Text (

      Choose Constants option.

      Enter &DE&ASR_EMPLOYEE_NAME in the bar of the Enter a Constant pop-up window.

      Close Expression pop-up window.

      Scroll down and click on the Expression drop-down box for Column 2 under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter name in the Search bar of the Variables pop-up window.

      Choose Formatted Name of Employee or Applicant from the Employee Info Group.

      Close Expression pop-up window.

      Scroll up and click on "+" Add column button.

      Click on the Expression drop-down box for the Column 3.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option, then select Text.

      Click on the first Pen icon (New Item) icon after Text (.

      Choose Constants option.

      Enter &DE&KOSTL in the bar of the Enter a Constant pop-up window.

      Close Expression pop-up window.

      Scroll down and click on the Expression drop-down box for Column 3 under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Variables option.

      Enter center in the Search bar of the Variables pop-up window.

      Choose Cost Center from the Employee Info Group.

      Close Expression pop-up window.

      Scroll up and click on + Add column button.

      Click on the Expression drop-down box for the Column 4.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Constant option, then select Text.

      Enter Empl% (0007IT) and Utilization%(0008IT) match?

      Push OK in the lower right corner of the Enter a constant pop-up window.

      Close Expression pop-up window.

      Scroll down and click on the Expression drop-down box for Column 4 under Row Template section.

      Click on the Pen icon (New Item) icon on the top left corner of the Expression pop-up window.

      Choose Functions option.

      Choose IF option.

      Click on the first Pen icon (New Item) icon after IF( .

      Choose Variables option.

      Choose DIFF from the Auxiliary Variables Group.

      • Click on the blank between [DIFF] and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Operators, then choose Comparison Operators =.
      • Click on the blank between = and comma; a new Pen icon (New Item) will appear in this place. Click on the new Pen icon (New Item), choose option Constants, then enter '0'and push the OK button
      • Click on the Pen icon (New Item) after first comma next to '0' , .

      • Choose Constants option.

      • Enter Yes option. and push the OK button

      • Click on the Pen icon (New Item) after second comma next to 'Yes' , .

      • Choose Constants option.

      • Enter No option and push the OK button

      Close Expression pop-up window.

      So, you are convinced that Auxiliary calculation captures the reusable expressions within an object's configuration and can be used as variables in other expressions.

  3. Test your Drill Down using the preview button.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  4. Activate your configuration.

Assign KPI Drill Downs to KPIs in Manage Configuration

Business Example

In this exercise, you will complete the new KPI configuration as a PCC consultant or PCC Content Administrator. You will assign the KPIs Drill Downs to the KPI Z##_HRH65_K001_NBR_OF_EE_GRO created in exercise 9.

Steps

  1. Call the Manage Configuration App.

    1. Open the Configuration tool favorite folder.

    2. Click on the Payroll Control Center - Manage Configuration application.

    3. To log into the front end of the training system, provide the username HRH65-## and password Welcome1. (You already used the same username and password to log into the training system.)

    4. In the left panel, choose KPI.

  2. Assign 2 KPI Drill Downs created in exercises 17-18.

    1. Choose KPI Z##_HRH65_K001_NBR_OF_EE_GRO, click on it, and then choose the Edit button in the top right corner.

    2. Click on the Details tab.

    3. Choose "+" Add Details button under the section name.

    4. Scroll down to the new section.

    5. Click on the Analytics Designer drop-down box.

    6. Enter Z## in the Search bar of Root Cause Analysis Template pop-up window.

    7. Choose Z##_HRH65_DD01_01_EE_GRS_PSA.

    8. Scroll up and repeat steps 2.2 -2.7. for Z## _HRH65_DD_FULL_PART_EE.

  3. Verify the newly updated KPI by utilizing the Preview option.

    1. Select a recurrence from the dropdown menu on the Preview screen.

    2. Choose show result.

    3. Check the configuration and close the Preview window.

  4. Activate the newly updated KPI.

Configuration of Actions and Solutions

Configurations of Actions and Solutions

Actions are the object types configured in Configuration Workbench to define solutions for alerts and step links for additional information in My Processes.​

Solutions and Steps

The image shows screens for Actions, which are separated as solutions and steps. A solution is presented as a hyperlink that the payroll administrator can access from both the Alerts and Alert Details pages in My Alerts. A step link is a hyperlink displayed on the step tab in My Processes in the Action section.

Actions are divided in two categories – Solutions and Steps:

  • Solution - A solution is presented as a hyperlink that the payroll administrator can access from both the Alerts and Alert Details pages in My Alerts. These hyperlinks are helpful for navigation in order to correct the alert for the employee. A typical example of a solution is "Add missing bank information". When the payroll administrator chooses this solution, they are directed to the people profile to check/add or correct the master data for that specific employee.​
  • Steps - A step link is a hyperlink displayed on the step tab in My Processes in the Action section. These can be used to start either a process outside of PCC or to confirm an offline process.​
The Action section with the step link is only visible when the step is status In Progress. If the step is not started yet or is already confirmed,​ you will not see the Action section or the step link on the step tab.

Log in to track your progress & complete quizzes