Melbourne SQL Server User Group - Many-to-Many Revolution

June 18, 2007 · 1 min read

I am speaking tomorrow night at the Melbourne SQL Server User Group. The presentation will be based on the excellent white paper that Marco Russo produced about Many-to-Many relationships in SSAS 2005 called the.

Here is the session abstract:

_The Many-to-Many Revolution --------------------------------------------------------

Do you have a situation with something like categories that have one or more customers and customers that fit into more than one of these categories? Then what you have is a many-to-many relationship.

There are well known techniques for modelling many to many relationships in relational database using bridging tables but until the 2005 release, there was no way of representing these relationships in Analysis Services. In this session we will explore the power and flexibility of this new modelling capability that was introduced with Analysis Services 2005. We will look at a number of different scenarios where such relationships are useful and explore how to configure them and some traps to watch out for. With Many to Many relationships you now have the power to accurately model your data.

But as Uncle Ben said in the original Spiderman movie "Remember, with great power. comes great responsibility"_

Sorry for the late notice, but if you are interested there is still time to register at. There is no charge, we just like to get a rough idea who is coming so we know how much Pizza and drink to order.

This article is part of the GWB Archives. Original Author: Darren Gosbell

New on Geeks with Blogs

  • We Won The One Award I Actually Care About

    Full Scale made the Inc. 5000 for the fifth year straight, the 12th listing across my three companies. Here is why the one award you cannot buy is worth stopping for.

  • Your Customers Build the Features Now

    I let a tool I liked sit dead for a year rather than build the features I wanted. An MCP server meant I never had to, and your customers can do the same to your product.

  • Get the Size of a Directory in Linux the Easy Way

    du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.

  • Vim Search and Replace: The Ultimate Guide

    One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.