nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How do you make columns show distinct values in a table in BI Publisher

Ian Schroeder

Content

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.

Find more posts tagged with

Comments

Arun Raj

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

Ian Schroeder

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.

Arun Raj

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.

Ian Schroeder

Filters would be perfect. But I do not know how to create a filter for distinct values in this program.

Arun Raj

Can let me know the subject area you are using?

Ian Schroeder

Workforce Management - Worker Assignment Event Real Time

Thank you for speaking with me by the way.

Arun Raj

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.

Ian Schroeder

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?

Arun Raj

May be look at the below?

Worker : Termination Date
Location : Effective End Date
Job : Effective End Date

There could be more. I am sorry I cant give you a straight forward answer without seeing the analysis being created. Hope this helps.

Ian Schroeder

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.

New Announcements

Upcoming Events

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Oracle AI Data Platform Hackathon at Oracle AI World 2026
Oracle AI Data Platform Hackathon at Oracle AI World 2026 Sunday, October 25, 2026 12:00–5:00 p.m. PT Request your spot at the AI Data Platform Hackathon Join us in person for the Oracle AI Data Platform Hackathon on Sunday, October 25, from 12:00–5:00 p.m. PT in Las Vegas at Oracle AI World. Lunch will be provided.…
Oracle AI Data Platform Customer Advisory Council at AI World 2026
Oracle AI Data Platform team will host an in-person Customer Advisory Council for AIDP customers attending Oracle AI World 2026 on October 26, from 1–3 PM PT. Join Oracle AI Data Platform executive leaders and selected customers for interactive discussions on our product roadmap, priorities, and future direction. Share…