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

Implementing bubble-up exceptions

In the previous recipe we dealt with highlighting the cells based on their results in comparison with sibling members which can be visualized in a horizontal direction. In this recipe we'll take a look at how to do the same but in vertical direction using the descendants of members in the report.

Bubble-up exceptions are a nice way of visualizing the information about descendants of a member without making reports huge. By coding the information about the result of descendants, we can have compact reports on a higher level while still having some kind of information about what's going on below.

The information we are going to "bubble-up" will be presented in the form of color-coding the cells.

Getting ready

Start ...

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