2637726 - Duplicate records in Advanced Reporting reports for Workflow information

SAP Knowledge Base Article - Public

2637726 - Duplicate records in Advanced Reporting reports for Workflow information

Symptom

Advanced Reporting reports for Workflow data fetch all the / duplicate records despite setting the date options to current date.

The requirement is to get the latest / current record for particular transactions

Environment

Advanced Reporting, Realms, Workflow Information

Reproducing the Issue

Navigate to Advanced Reporting.

Enter the Workflow Management view in Realms and drag the object to the canvas.

Set the date option to Current Date and check the results.

Modify the date options to other criteria and result set remain the same and displays all data.

Cause

Workflow Steps comments field causes the duplicates to appear in the report.
Adding the 'Workflow Steps comments' field from Workflow Steps Workflow Wf request comments table introduces duplicate records.

Resolution

If the Workflow Comments are not required for the actual report, the 'Workflow Steps Workflow Wf request comments' should not be added to the report.

If the table is required, the 'Workflow Steps comments' field should be added to the result list (e.g. 'comment'),
Please be aware that each table which contributes to the query with multiple records will result in a multiplication of all other records (A * B * C * ...)

To reduce the number multiplied results, apply filter on the Action Type = "COMMENT".
This filter should be designed as 'restriction' (if it would be a 'regular' query filter this would suppress all WF steps which don't contain any comment).

Use the 'Edit Restrictions' option from the 'Workflow Steps Workflow Wf request comments' table

This has been applied to our EC standard reports.

Also, Workflow table within Advanced Reporting does not follow any effective dating and displays all current records irrespective of the date option defined.
This is an expected behavior.

Keywords

Realms, Workflow, Advanced Reporting, Duplicates , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors HCM Suite all versions