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

Setting special format for negative, zero and null values

The FORMAT_STRING property is used for specifying how a regular or calculated member (usually a measure) should be presented and what its FORMATTED_VALUE should look like. There are some predefined formats such as Standard, Currency or Percent, but we can also specify our own using the right combination of characters.

Most people are unaware of the fact that there are actually 4 sections of the format string for numeric values and 2 sections for strings. In this recipe we'll see how to set the format for negative, zero, or null values.

Getting ready

Follow these steps to set up the environment for this recipe:

  1. Open Business Intelligence Development Studio (BIDS) and then open the Adventure ...

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