2966567 - Key Figure Absence in Custom Report Based on Standard Data Source Forecasted Utilization Incorrect

You observed that the key figure Absence is not working correctly in a custom report based on standard data source HCMRPMU01 (Forecasted Utilization), even though the standard data source has been corrected by SAP.

SAP Business Design

1. Go to Business Analytics work center
2. Click on Design Reports view
3. Select All
4. Open custom report
5. Run report

The concept of Forecasted Utilization is based on the resources/employees and their assignments to projects. This assignment value is shown as Scheduled Work. Forecasted Utilization is then calculated as: ((Scheduled Work + Absence)/Gross Capacity) *100.

Scheduled Work and Forecasted Utilization are based on projects, while the other two key figures Gross Capacity and Absence are related to employee’s work schedule and leave. Therefore, these values should not be summed up every time (based on number of projects) if the employee is assigned to multiple projects.

We need two levels of exception aggregations:

• We need an exception aggregation First Value of project. It means that the values should be counted only once.
• We also need an exception aggregation Total of all employees. It will sum up the values across all employees.

You need to create new Calculated Key Figures and add Exception Aggregations to the Calculated Key Figures as follows:

1. Go to Business Analytics work center
2. Click on Design Key Figures view
3. Click on New
4. Enter Name, Description, and Data Source
5. Select Calculated Key Figure as Type
6. Click on Next
7. Expand Basic Key Figures
8. Double-click on Absence
9. Add formula
10. Click on Next
11. In section Maintain Exception Aggregation enter First Value as Aggregation Type
12. Enter Project as Characteristic
13. Click on Finish
14. Repeat steps 4 to 12
15. In section Maintain Exception Aggregation enter Total as Aggregation Type
16. Enter Employee as Characteristic
17. Click on Finish

After that, you need to adjust your custom reports with created Calculated Key Figures as follows:

1. Go to Business Analytics work center
2. Click on Design Report view
3. Search for custom report
4. Click on Edit > Report Wizard
5. Add the Calculated Key Figures
6. Remove the basic key figure
7. Click on Finish

Forecasted Utilization, key figures, absence, HCMRPMU01, Abwesenheit, Standardkennzahlen, Prognostizierter Bedarf, , KBA , SRD-HR-ANA , Analytics Content , Problem