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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.