General OBIEE

Get Involved. Join the Conversation.

Topic

    Ashish Harbhajanka
    Need Help in Creating a OTBI Analysis from Simple Logical...
    Topic posted January 6, 2017 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged Discussion Forums 
    116 Views, 1 Comment
    Title:
    Need Help in Creating a OTBI Analysis from Simple Logical SQL
    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.

    Document:
    Document:

    Comment

     

    • 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.