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.
Ending Balancewhich is the sum of all the accounts ending balances.
As of Date. This dimension can be aggregated by year, quarter, and show monthly data points.
I am using SQL Server Enterprise edition.