Parent Child Hierarchies

Parent Child Hierarchies:

1. Parent child hierarchies are also called as?

A) Parent child hierarchies are also called as Value based hierarchies.

2. What is a parent child hierarchy?

A) One to many relationship among data is called as parent child hierarchy.

3. Who needs parent child hierarchies?

A) This kind of hierarchy is required for employees or team based hierarchies.

4. How many levels do parent child hierarchies have?

A) In parent child hierarchy we will have only two levels (One is Total and other one is Detail).

5. What needs to be done to resolve the issue of circular joins in OBIEE11G?

A) Alias must be used in order to resolve the issue of circular joins in OBIEE11G.

6. How do we need to manage the concept of parent child hierarchy in OBIEE10G?

A) We used to manage this concept in OBIEE10G by de normalizing the position table.

a. In this concept no of columns in the table is equal to number of positions in organization.

b. Hence this table metadata (Number of columns) changes from organization to organization.

c. If extra level is added then Meta data changes need to take care in DB, ETL and reporting levels.