O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by 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 using two or more dimensions.

Before we start, let's get one thing straight - when we say a dimension, we mean any hierarchy in that dimension from now on.

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

In other words, there are two different types of combination we can make ...

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