SSAS Semi-Additive Measure over Time Dimension

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

Issue:

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.

Facts:

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

Dimensions:

  • 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




How make an SSAS Tabular model case sensitive?

Updated August 10, 2017 10:06 AM