Parent Child Tables in OBIEE
Hi,
I have three tables to be added in OBIEE Admin Tool
1. Request Master (Req_ID is PK)
2. Complaints (Req_ID is PK)
3. Compliments (Req_ID is PK)
Table 2 and 3 are linked to table 1 in a 1:1 relationship. so basicallly, all requests have a record in the master table (Request master) and depending on the type of request, there will either be a detail record in table 2 or table 3.
Can someone guide me as to what would be the best way to configure the relationships in the admin tool on the Physical & BMM layers.
-Osden