O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Finding related members in another dimension

As mentioned in the introduction of the previous recipe, Finding related members in the same dimension, this recipe deals with a slightly different scenario. It explains how to find the related members from two or more different dimensions.

Before we start, please keep in mind that when we say a dimension, we mean any hierarchy in that dimension from now on.

Dimensions, unlike hierarchies of the same dimension, are unrelated and therefore independent objects. Without a third table in the form of a third fact table, they are unrelated, at least in the dimensional modeling sense. When a fact table is inserted among them, the many-to-many relationship comes into existence.

There are two different types of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required