O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, 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 cells based on their results in comparison with sibling members, which can be visualized in a horizontal direction. In this recipe, we will take a look at how to do the same but in a vertical direction, using the descendants of members in the report.

Bubble-up exceptions are a nice way of visualizing information about the descendants of a member without making reports too big. 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 by color-coding the cells.

Getting ready

Start SQL Server ...

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