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

x

We use cookies to ensure the best possible experience on our website. Detailed information on the use of cookies on this site is provided in our Privacy and Cookie Policy. Further instruction on how to disable our cookies can be found there.