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 Management Studio and connect to your SSAS 2016 instance. Click on the New Query button and check that the target database is Adventure Works DW 2016.

In this example, we're going to use the Product dimension. Here is the query we'll start from...