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

Displaying a sample from a random hierarchy

In the previous recipe you learned how to generate a random sample from a predefined hierarchy. In this recipe you'll learn how to generate a sample from a random hierarchy. The idea is to make a single report that can be used over and over again, similar to news ticker on TV. All that is required is a mechanism for refreshing it. In case of a web page or a widget, it can be implemented relatively easy.

Apart from that, this recipe is interesting from a didactical point of view. It shows how to operate with hierarchies, how to navigate them, and get information about them, all without actually specifying any of the cube's hierarchy, other than measures. Even if you don't plan on implementing it, it can ...

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