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

Calculating the bit-string for hierarchies on an axis

We've been up and down the result so far. We've traversed the result horizontally and identified the current tuple, its hierarchies, and current member of those hierarchies. We've also identified the row number which allows vertically-oriented relative calculations, for example, the increment from the previous row.

In this recipe we're going to focus a bit more on the horizontal part. Although we already know a lot about the current tuple and its content, there are situations where we can benefit from having a bit more. For example, if there are multidimensional sets on rows, it might be interesting to calculate the ratio of the rightmost hierarchy members against their immediate parent or their ...

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