OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCT — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCT

in Reporting and Analytics for HCM 4 comments

Summary:
I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repeating multiple times in the results.

Steps I tried so far:

  1. Enabled Advanced SQL Clauses → DISTINCT option.
  2. Verified subject area fields being used.
  3. Still, the duplicates are not removed.

Screenshots:

  • Advanced SQL Clauses option with DISTINCT enabled.
  • Sample output showing repeated Person Number.

Request:

  • Please help me understand why duplicates are still appearing even after enabling DISTINCT.
  • What is the recommended way to remove duplicates in OTBI?
  • Is this issue caused by how joins are handled in the subject area?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!