Business Intelligence

powerpivot many to many relationships

Transitioning from an Analysis Services mindset to working with PowerPivot is not always the easiest transition.  One of the recent snags came in trying to work out a demo over some data where there are bridge tables – a common scenario in dimensional modeling that sits behind our OLAP cubes – but not a concept that PowerPivot is ready to handle.

So, thank goodness Marco Russo wrote a lengthy and detailed explanation so that I didn’t have to – read his post on Many-to-Many relationships in PowerPivot and thank him for his thoroughness!

Leave a Reply