Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 275 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need Help in Creating a OTBI Analysis from Simple Logical SQL
AshishERPCloud
Rank 5 - Community Champion
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.
0
Comments
-
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.
0