O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

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

Getting formatting from the Multidimensional model

The OLAP structure is well known as an optimized data structure for data retrieval, which is the main reason to use it as a data source for reporting. However, there are also other advantages Reporting Services can obtain when the data source is Analysis Services. Analysis Services allows us to configure format-strings for measures and we can get the same applied when they are shown in Reporting Services reports. It is one advantage which we discuss in the recipe.

Getting ready

As a practice, we define the formatting for measures in our Multidimensional model when designing them. This ensures that all BI clients use the same formatting when displaying the values of measures and KPIs. For some of ...

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