SSAS Semi-Additive Measure over Time Dimension

by Christopher Aliotta   Last Updated July 19, 2017 04:06 AM


Help, I'm relatively new to building OLAP cubes in Microsoft's SQL Server Analysis Services and I need help with a semi-additive measure over a time dimension.

In other words, I want to show the ending balance as a non-additive measure at quarterly and yearly aggregation points.


  • I have a measure called Ending Balance which is the sum of all the accounts ending balances.


  • I have a date dimension called As of Date. This dimension can be aggregated by year, quarter, and show monthly data points.

Desired Outcome:

Desired outcome of ending balance shown as non-additive measure along quarterly and yearly aggregation points.

I am using SQL Server Enterprise edition.

Related Questions

administrator permissions on a SSAS database

Updated May 15, 2018 14:06 PM

How make an SSAS Tabular model case sensitive?

Updated August 10, 2017 10:06 AM