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

Using a utility dimension to implement flexible display units

Measures are sometimes too precise for reporting needs. Either because they have decimals which distract us or because the numbers are very large, consisting of many digits, and therefore hard to memorize or compare with others. The phrase "can't see the forest for the trees" fits here perfectly.

One way to simplify this problem would be to divide those measures directly in the fact table by, let's say 1,000 or 1,000,000. We would of course have to specify the new unit in the title of the measure. However, that wouldn't be a good solution. In situations when we need the results to be as precise as possible, that would cause problems. As said, only sometimes, not always, there's a need ...

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