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

The dimensionality of a cube equals the number of hierarchies used in it. This encompasses all the user and attribute hierarchies, including a special hierarchy Measures, visible or not, as long as they are enabled. A cube with 10 dimensions, each having 10 attribute hierarchies, is a 101D object! Comparing that to any 3D objects in your environment, such as a Rubik's cube, you will 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 to us through several ...

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