SSAS Articles 
Design The many names of attribute relations
Design The many names of attribute relations
| The many names of attribute relations |
| Written by Thomas Ivarsson |
| Sunday, 24 February 2008 15:59 |
|
The reason for writing about this is that I need to find some good practical examples of how attribute relations work and implications on calculations. Richard Tkatchuk has written a white paper on this topic here, that you can download. My ambition is to follow Richards examples and apply them on the Adventure Works cube(like always). There are not that many examples of people in this business that have followed up Richards work on this topic but as a MDX rookie I am trying to explain what he writes about. I have only tried a few examples and some of them can be questioned from not having a complete picture of what is going on. Still I have given this subject much thought and have checked the best SSAS2005 books several times. I have also built a small and simple cube without attribute relations and it seem to confirm what I am supposing here. The rest of my experience comes from working in a large company that use SSAS 2005 cubes heavily. Anyway, this is my current opinion.
|
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)
