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

Applying conditional formatting on calculations

Sometimes we want to emphasize cells based on their values. That way data analysis becomes easier because we combine best of charts and tables we still see the values while we have additional color information about the value in each cell.

A typical case is highlighting the background of cells with green or red color for good or bad results, respectively. It's a pretty trivial operation in Excel and it's not that hard in MDX either. This recipe demonstrates how to do this.

Getting ready

Open BIDS and verify you have the Gross Profit formatted measure defined in the previous recipe, Setting special format for negative, zero and null values. If not, define the measure like this:

Create Member CurrentCube.[Measures].[Gross ...

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