I’m approaching the review phase for a paper I wrote about advanced dimensional modeling with Analysis Services 2005 using many-to-many dimension relationships.
Currently the paper has around 80 page (with many figures!) and covers 2 base techniques (base and cascading many-to-many relationship) and 6 design patterns to model different business scenarios:
- Distinct Count
- Multiple Groups
- Transition Matrix
- Multiple Hierarchies
I hope to publish the paper on SQLBI.EU in a few weeks. In the meantime I am looking for peer reviewers that already have some knowledge and experience of the use of many-to-many relationships in a non-traditional way. If you are interested, please contact me using the contact link in this page.
UPDATE: PDF and demo are now available here.