SSAS Articles 
Design Different types of hierarchies in SSAS2005
Design Different types of hierarchies in SSAS2005
| Different types of hierarchies in SSAS2005 |
| Written by Thomas Ivarsson |
| Sunday, 21 October 2007 06:40 |
|
I recently answered a question about this in the SSAS2005 newsgroup but thought that I can add a few more thoughts about this topic. Attribute and user hierarchiesI the dimension editor in BIDS you have the attribute hierarchy in the left pane and user hierarchies in the middle pane. If you do not ask the dimension wizard to detect natural hierarchies you will always attribute hierarchies with the attributes you have choosen. An Attribute hierarchy only have an all-member at the top and its values as member. Gender in the customer dimension have an all-gender member at the top and the values male and female. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
