Symptom
You are using the report Forecasted Utilization with the key figures Absence, Gross Capacity and Forecasted Utilization. You have also set up a result line, but you notice that the aggregated results for these 3 key figures are not correct.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to the work center that this report is assigned to and open the reports list.
- Open and run the report Forecasted Utilization.
- Go to Settings > Characteristics, and set up a result line.
- Go to Settings > Key Figures and make the key figures Absence, Gross Capacity and Forecasted Utilization visible.
You will see that the aggregation of results is not as expected.
Cause
The behaviour is correct. The report needs to be set up in a specific way.
Resolution
The key figures Gross Capacity and Absence are related to an employee’s work schedule and leave. Therefore, it is not meaningful to have an aggregation (i.e. a result line) on the Project field and this characteristic is not part of the default report view. However in case you add it via Add Fields, the following aggregation rules are set up:
Gross Capacity has the exception aggregation 'First Value' based on the project, so in case there are multiple projects, it only considers the first value. As mentioned, Gross Capacity completely relies on the employee's work schedule and does not need to be summed up since it would be same for all projects.
Absence has the exception aggregation 'Average of Detailed Values which are not Zero, Null or Error' based on Project. So if there are multiple values, the key figure result only considers the average value. As mentioned, Absence completely relies on the employee's work schedule and does not need to be summed up since it would be same for all projects.
By contrast, Forecasted Utilization has neither an aggregation nor an exception aggregation. The result row in the report is based on the formula:
Forecasted Utilization = ((Scheduled Work + Vacation) * 100) / Gross Capacity
Keywords
report, analytics, forecasted utilization, result row, GROSS_CAPACITY, VACATION, FORECAST_UTILISATION, HCMRPMU01_Q0001 , KBA , SRD-HR-ANA , Analytics Content , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To