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 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 ...

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