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 Balancewhich 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.
I am using SQL Server Enterprise edition.
I've made sure that the Time dimension is properly specified with the correct types and attribute relationships. Reference link