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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2012-01-22 : 23:36:18
|
| Hi Is it possible to have different set of sub group hierarchy for the same group.For example,Group1 should have subgroups group2 , group3, group 4 and group5I should be able to drill down the group1 through group2-> Group3-> group4 -> Group5or group1 ->group4->group5 (without drilling group2, group3 values)or should be able to Thanks in advance.- Varalakshmi |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2012-01-25 : 07:01:27
|
| It is possible if you create a hierarchy for each possible permutation of drill path you are expecting. This would entail extra columns in your sql table for the dimension and new hierarchy designs in the cube dimension.Duane. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-25 : 10:13:01
|
quote:
Originally posted by varalakshmi
Hi Is it possible to have different set of sub group hierarchy for the same group.For example,Group1 should have subgroups group2 , group3, group 4 and group5I should be able to drill down the group1 through group2-> Group3-> group4 -> Group5or group1 ->group4->group5 (without drilling group2, group3 values)or should be able to Thanks in advance.- Varalakshmi
you need to store them in parent child format in table.it will be self referencing relationship within same table and you can use recursive CTEs to retrive the information like above------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Multiple level of grouping in report