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 ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.