SAP Knowledge Base Article - Public

2261877 - Duplicate Records and Cancelled Position shown in Position table - Advanced Reporting

Symptom

  • Duplicate Record showing in Position Table for each position code or to some of the position code.
  • A query is created with Position table to report all active positions and a cancelled position is shown in the report

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Reproducing the Issue

  1. Create a query in Advanced Reporting
  2. Drag and drop the Position table
  3. See multiple rows per Position
  4. Add a filter by effectiveStatus in 'Active'
  5. Check Results
  6. There are still multiple rows for each Position

Cause

The report is showing the data as expected. The status field that we have to look is the "mdfSystemRecordStatus". The positions have the status of PH. "PH" is the record’s history before workflow got approved, it’s again a status specific to workflow records. Assume record has a value "A" and you created a workflow to change the record value to "B", once workflow is approved the record value will become "B". To keep the history a record with "PH" is created with value as "A".

So the reporting team should modify their query to filter out all records whose RECORD_STATUS is not 'N'. Only the records with record_status 'N' are approved and should exist or show up in the report.

Resolution

Please add the filter "mdfsystemrecordstatus" as "N", as these are the only records which are approved and not related to Workflow.

S1.jpg

You can find the below values in above mentioned field.

  • N - normal record
  • P - pending record
  • C - correction
  • D - soft deleted record
  • PH - Is the record’s history before workflow got approved,

 

Keywords

Cancelled Position multiple duplicate rows mdfsystemrecordstatus, duplicate positions, report on position , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-FWK-MDF , MDF Framework , LOD-SF-EC-MDF , MDF & EC2MDF Migration , LOD-SF-EC-POS , Position Management , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors Workforce Analytics all versions