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-30 : 12:12:21
|
| Hi to everyone,My problem is: "how can I add a new level in a parent child dimension (if is possible)?"Thanks All.Luigi. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-10-30 : 12:30:41
|
| I think I speak for all when I say, that I don't quite get it. You'll have to be more specific. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-30 : 12:37:28
|
| Graz, RobI see this kind of vague questions all the time.Maybe you guys could put up some instructions on ask a question and get the best results on the sides of the posting textbox.I know when I first started I didn't have a clue.Edited by - ValterBorges on 10/30/2002 12:38:08 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-30 : 13:16:23
|
Well, the instructions are already on the Ask SQL Team page, including reading the FAQ and searching the site before posting the question. You all know how often people follow THAT advice.  |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-30 : 13:39:02
|
| Why put double-quotes around the question? Smells a little funny ...Jay White{0} |
|
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-10-30 : 14:48:03
|
| A Parent Child dimension defines a relationship between two columns in the same dimension table. This means there is only one level of metadata created/possible.The Dimension Wizard suggests that multiple levels may be displayed in a client application, depending on the data contained in the related columns. (ie, you link Account_rep to Account Manager, where an Account Manager can have another Account Manager as a parent. This would have an additional 'level' when displayed.)I'm still trying to verify that last bit. I'll let you know what I find out.'K. PROCLARITY says the Parent-Child Dimension is used to represent unbalanced Hierarchies. In their example they use Employees and Managers. The data is recursive. Bob is an Employee of Andy, but Bob is also listed as a Manager for Chris. So Bob's name appears in both columns. The corresponding drill down yields Andy-Bob-Chris. But this relationship is derived from only ONE declared level in the Parent-Child dimension.Edited by - Kevin Snow on 10/30/2002 14:56:43Edited by - kevin snow on 10/30/2002 17:00:48 |
|
|
|
|
|
|
Parent-Child Dimension