O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, 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 perfectly here.

Sometimes users like to see measures displayed in thousands or millions for ease of comparison. One way to accomplish that 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 where we need the results to be as precise as ...

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