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 the same dimension

The dimensionality of a cube equals the number of hierarchies used in it. This encompasses all the user and attribute hierarchies, visible or not, as long as they are enabled, and one special dimension/hierarchy called Measures. A cube with 10 dimensions, each having 10 attribute hierarchies is a 101D object! Compare that to any 3D object in your environment, take a Rubik's cube for example, and you'll immediately be amazed by the space a typical SSAS cube forms. The number of coordinates, or shall we say cells, in that space is simply beyond our imagination.

Fortunately, a great deal of that space is empty and the SSAS engine has ways to optimize that. It even exposes some of the optimization features ...

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