Skip to Content
0
Former Member
Jul 19, 2011 at 10:32 AM

Parent Child Hierarchy (N Level Hierarchy ) in BI 4.0

80 Views

Hi ,

We have following table structure . We are trying to create parent-child hierarchy and implement drill on the same .

We are using Oracle database as RDBMS.

e.g.

Child Key    Parent Key
1    
2                 1
3                 1
4                 2
5                 2
6                 3
7                 1
8                 5

Now based on this table structure , if we create hierarchy using parent key and child key , we should be able to drill from 1 to {2,3,7} directly.

further when i click on 2 , we should get {4,5 } as resulting rows.

At the same time drill-down should not work on the values which are not parent of anyone (i.e. Leaf Node). e.g. 4, 8, 7, 6.

Can anyone please let me know how can i achieve the same result by building hierarchy or any work around ?

Regards ,

Jeevan Chaudhari