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 Analytics and AI

Child Item

Need Help in Creating a OTBI Analysis from Simple Logical SQL

AshishERPCloud

Summary

I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurence

Content

I have attached the Logical SQL 1 which works fine and also Logical SQL 2 which also works fine.

The combined SQL however does not works as expected.

Details in attached word doc.

Any help/inputs is appreciated.

LogicalSQLIssue.docx

ErrorMessage.txt

DuplicateIdentifierListLogicalSQLAnalysis.txt

Find more posts tagged with

Comments

Merrick Hartslief

I assume you are trying to join the Identifier with the person query so you can see who has the duplicates. I would suggest taking these to logical queries and using BIP do to the join.