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 stock value of the last day of the month. This type of measure is called semi-additive.

Let's look at how Reporting Services supports the display of semi-additive measures.

Getting ready

Let's create a new report using the following steps:

1. Add a new...