M2M

ARTICLE

The updated Survey pattern for Power Pivot and Tabular #powerpivot #tabular #ssas #dax

One of the first models I created for the many-to-many revolution white paper was the Survey one. At the time, it was in Analysis Services Multidimensional, and then we implemented it in Analysis Services Tabular and in Power Pivot, using the DAX language.

ARTICLE

Optimize Many-to-Many with SUMMARIZE and Other Techniques

We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships

ARTICLE

Free online session at PASS DW/BI Virtual Chapter #sqlpass – Wed Jan 18th, 2012

On January 18th, 2012 at 12pm Eastern Time (which is 5pm GM) Alberto Ferrari will deliver a free online session for the PASS DW/BI Virtual Chapter . This is the official description of the session. Many-to-Many Relationships in DAX The introduction of

ARTICLE

The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services

ARTICLE

CREATE GLOBAL CUBE statement does not support cascading M2M relationships?

Thanks to a comment sent by a reader of my M2M paper , I just found a possible bug (or ” not supported by design feature”) of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension relationship is supported, but if

ARTICLE

Many-to-Many Dimensions: Query Performance Optimization Techniques

More than one year ago I published a paper about design patterns for many-to-many dimension relationships . Since then, I built other models and I got more experience about possible performance optimizations. Unfortunately, I still hadn’t time to write

ARTICLE

Analysis Services 2005: many-to-many dimension, killer feature!

SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are “marginal”, in the sense that bring us better productivity