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 ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.