Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Ian Schroeder · 2016-04-01 19:13:04

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.

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

1591

Views

Comments

Rachel Martorelli-Oracle Rank 4 - Community Specialist

Apr 1, 2016 8:31PM

Here's a blog that might help. It has the xdo distinct function which can be used in bip templates.

https://blogs.oracle.com/xmlpublisher/entry/counting_distinctly

0

Oracle Transactional Business Intelligence

Categories

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

Comments