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

Combining two hierarchies into one

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

End users don't look at the data that closely. Reports are sometimes very asymmetric, and further, they don't follow the logic of a consistent table. In other ...

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