6/4/2007 9:47:59 PM
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"
Darren Gosbell is a senior consultant with James & Monroe, a consulting firm whose specialties include the areas of business intelligence, data warehousing and business performance management (BPM). He has in excess of eight years practical experience in building and implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. He has used all versions of SQL Server since version 7.0, participating in the beta programs for both SQL Server 2000 and SQL Server 2005.
In 2006 Darren received a Microsoft MVP award in SQL Server in recognition of his contribution to the community specially in the areas of Analysis Services and MDX. He lives in Melbourne with his wife and 2 children and enjoys throwing boomerangs when he can find a safe area in which to do so (which is not nearly as often as he would like)
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:30 pm finish |
On: Tuesday, June 19, 2007