| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Setting parameters at Hierarchy within a hierarchy
There are 2 independent hierarchies. Account hierarchy and security
hierarchy. Now the users want to set parameters across these two
hierarchies meaning one hierarchy gets nested in the other. Can u give
me some pointers where I can get more information on the nested set
model ?
Thanks
71062.1056_at_compuserve.com (--CELKO--) wrote in message news:<c0d87ec0.0303031655.b582b9a_at_posting.google.com>...
> >> I have a situation where I have two hierarchies : the Organization
> hierarchy which has 6 levels ... and the second hierarchy is ... <<
>
> I am not sure what you mewan by this. Are these hierarhcies applied
> to the same set of nodes? I once had a case where a shoe
> manufacturing data warehouse had one reporting heirarchy for
> manufacturing (based on physical construction of the shoes, very
> fixed) and a second one based on marketing and sales (based on trends,
> very fuild).
>
> I did this with two nested set models that referenced the same set of
> nodes and it worked quite well. Inheritance is easy to show in a
> nested set model, too.
Received on Tue Mar 04 2003 - 07:49:52 CST
![]() |
![]() |