Duplicate rows returned for some Employees in Production Only
Summary
Duplicate rows returned for some Employees in Production OnlyContent
Hi,
When I run the attached analysis which is developed using logical SQL it returns duplicate rows for some Employees in Production. If I filter on the Created By field selecting 1 Employees User Name, who has duplicate rows, the report returns one row of data for the Employee which is correct and what I would expect. I cannot replicate the issue in our Test POD's and was wondering if anyone has had this issue or knows what the issue could be?
Please Note: The logical SQL combines the subject areas - "Workforce Management - Documents of Record Real Time" & "Human Capital Management - Approval Notification Archive Real Time".