Getting aggregated values from the Multidimensional model
There are many important things to be discussed related to Reporting Services and Analysis Services. Since we have no way of discussing everything, let's take one more item that Reporting Services supports natively on an Analysis Services capability.
Analysis Services supports three different types of measures: additive, semi-additive, and non-additive. Generally, most of the measures are additive and easy to work. However, some of the measures cannot be summed up along with the dimensions used as they require a specific calculation. For example, stock needs to be maintained daily, and monthly stock is not just the total of all stock values for all dates for the particular month, it is the ...
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.
