Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
luisar
Starting Member
3 Posts |
 Posted - 2002-10-31 : 04:41:28
|
| I give more details on my question.I’ve an unbalanced Hierarchies like Director, Manager and project Manager (I’ve created this Hierarchies with two column like IdPosition and IdFather on my table) the Problem is: every Project Manager have one or more proposal (the proposal field is in the same table and the name of this field is IdProposal) so I want add on my Hierarchies this field (IdProposal) on the leaf member, I want an hierarchies like:Director->Manager->Project Manger->Proposal.Sorry for my English, I’m Italian. Thanks to AllLuigi. |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-31 : 16:28:14
|
| Adding the project to the hierarchy, and using the Parent-Child dimension seem to be mutually exclusive. You don't want to mangle the IDProposal column into the exisiting Parent-Child relationship. At the same time, you don't want to destroy the parent-child relationship just to accomodate the IDProposal column.Have you considered dimensioning IDProposal separately? Proclarity uses 'background' dimensions which can still present the data in a useful form. Perhaps you have tools that support a similar concept? |
 |
|
|
luisar
Starting Member
3 Posts |
Posted - 2002-11-05 : 06:59:05
|
| THANKS KEVIN for your answers. Luigi |
|
|
|
|
|
|
Parent Child