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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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

1592

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

MFA for Oracle Community

Oracle Transactional Business Intelligence

Categories

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

Comments