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

Combining two hierarchies into one

The result of a query contains as many metadata columns as there are hierarchies on rows. For example, if we put two hierarchies on rows, the color and size of products, there will be two columns of metadata information, one for each hierarchy. In the first column, we will have all colors and in the second column we will have all sizes. Depending on the relationship between those hierarchies, we will get either a full cross join for unrelated hierarchies (different dimensions) or a reduced set of valid combinations (in case of the same dimension). In any case, there will be two columns.

Reports grow large very quickly. Once you put several hierarchies either on rows or on columns, suddenly you don't see data; ...

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