Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

61
Views
1
Comments
AshishERPCloud
AshishERPCloud Rank 5 - Community Champion
in Oracle Transactional Business Intelligence

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.

Comments

  • Merrick Hartslief
    Merrick Hartslief Rank 1 - Community Starter

    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.