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: --CELKO-- <71062.1056_at_compuserve.com>
Date: 3 Mar 2003 16:55:54 -0800
Message-ID: <c0d87ec0.0303031655.b582b9a@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 Mon Mar 03 2003 - 18:55:54 CST

Original text of this message

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