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 ...
Get SQL Server 2016 Reporting Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
