SAP Knowledge Base Article - Public

2709820 - Key Figure Total Duration does not show the same Value as in the related Time Report

Symptom

You created a new time report and now you want to display the Total Duration in the standard report All Time Entries (technical ID CODTIME_ENTRY_Q0001) but the results shown are different.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Select the view Design Reports.
  3. Search for the report All Time Entries and open it.
  4. Enter the user you would like to check the Total Duration for under Time Entry Employee Responsible and select a Time Entry Calendar Month.
  5. Click Go to start the report.
  6. Add Key Figure Total Duration to the report view.
  7. You will realize that the value is different than shown in the related time report (to check the time report, please go to work center Time Reporting, view Time Reports).

Cause

The reason why the records do not to show up is due to the way the aggregation happens on unique records. This is the current behavior of the system and works as designed.

Resolution

To show the exact values and correct aggregation for all time entries, please include the characteristic Time Entry Created On (you will find it in the tab Available Fields) in the report view and refresh the report afterwards.
Now the key figure Total Duration shows the same value as in the original time report.

Keywords

Time Report, All Time Entries, key figure Total Duration, incorrect value, Time Entry, different value, CODTIME_ENTRY_Q0001 , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-SRP-TR , Time Report , How To

Product

SAP Cloud for Customer 1802 ; SAP Cloud for Customer 1805 ; SAP Cloud for Customer 1808 ; SAP Cloud for Customer 1811 ; SAP HYBRIS C4C ADDINS 1902 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711