Oracle Transactional Business Intelligence
Need Help in Creating a OTBI Analysis from Simple Logical SQL
I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurence
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.