Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Setting parameters at Hierarchy within a hierarchy

Re: Setting parameters at Hierarchy within a hierarchy

From: hs <harry827_at_yahoo.com>
Date: 4 Mar 2003 05:49:52 -0800
Message-ID: <12c8e030.0303040549.2e51a01b@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US