Skip to Main Content

Parent Child Tables in OBIEE

737765Dec 20 2009

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.