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

Using a dummy dimension to implement histograms over non-existing hierarchies

As seen in the previous recipe, Analysis Services supports attribute-based histograms by design. All it takes is a distinct count measure and we're set to go.

This recipe illustrates how to implement more complex type of histograms — histograms over non-existing hierarchies.

The complexity comes from the fact that the hierarchy on which we'd like to base the calculation on does not exist. That's a very big issue when a multidimensional cube is concerned.

OLAP cubes operate on predetermined structures. It is not possible to build items on-the-fly. In other words, it is not possible to create a new hierarchy based on a calculation and use it the way we would use any 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