I am creating a report in BI publisher and it shows duplicate values for employee ID's. Employee ID should be a distinct value and should not be returning duplicate values.
Are you using custom data model? If yes, then you will have to check the data model to make sure the SQL query is correct.
Thanks,
Arun
I am not exactly sure if I am using a custom data model or not. I have simply pulled fields from a subject area and for some reason my PersonID column is showing duplicates.
Ok. So you are creating a OTBI report. I was checking if you were creating a BI publisher report.
Try adding some filters in your analysis.
Filters would be perfect. But I do not know how to create a filter for distinct values in this program.
Can let me know the subject area you are using?
Workforce Management - Worker Assignment Event Real Time
Thank you for speaking with me by the way.
Happy to help.
Since it is HR / Employee data, you might want to look at any date columns to make sure you are only picking the most recent / active record. If it is a SQL we mostly look the Effective Date columns. Please check if you can utilize any Effective Date columns in your filter.
For example, an employee can have multiple assignments, however only 1 might be active.
That is a good idea. I am currently filtering by Assignment Status Type equal to Active. However, I am struggling to think of what date column to use for a filter.
Suggestions?
May be look at the below?
There could be more. I am sorry I cant give you a straight forward answer without seeing the analysis being created. Hope this helps.
Those are apparently fields we do not use. I have looked through quite a few date fields and cannot find one worth filtering by. I am surprised that there is not a way to SELECT DISTINCT on the field of PERSON NUMBER.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
