We solve complex problems of data modeling and develop tools and solutions to let business perform best through data analysis.

Complex challenges made simple

SQLBI is a consulting firm with a strong and unique experience in Business Intelligence, centered around Microsoft technologies – SQL Server and SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).


We help companies make sense of the information they have available so that they can take strategic informed decisions that deliver better results and performance. 

Many-to-Many Project

Many-to-many dimensional modeling

 

This project is not a tool or a component, but a set of design patterns to build solutions based on many-to-many dimension relationships with Analysis Services 2005.

This area is almost unexplored and at the same time is full of opportunity. The paper is the synthesis of more than one year of experience on Analysis Services 2005, but it is only the beginning. More study and experience is needed, especially in performance evaluation.

The paper is free, but please invite your peers to download it from sqlbi.eu web site. Every interested reader is also invited to give feedback, participating in the Many-to-many modeling forum.

A forum support is available. Register to SQLBI.EU and you will receive newsletters with updates and new releases.

 

Print

2007.05.15 The many-to-many revolution 1.0.93 in a printed form is available on Lulu.com for only print and shipping cost.

Download

2006.09.25 The many-to-many revolution 1.0.93: PDF many-to-many design patterns (by Marco Russo)

2006.09.25 The many-to-many revolution 1.0.93 demo: sample data and projects

Articles and History

2006.09.25 The many-to-many revolution: introduction from the downloadable article