CODEWITHSUNDEEP
sql-serverssascube
devlin carnate
devlin carnate

Reputation: 8602

SSAS aggregates measure that is set to not aggregate

I have non-additive measure in my fact table. I set the measure property AggregateFunction to None:

aggregatefunction

I processed the cube, and then went to the Browser. I re-connected to verify I was working with the latest changes in the cube. But the measure is aggregating.

browser

How do I keep SSAS from aggregating a non-additive measure?

Upvotes: 0

Views: 1511

Answers (1)

devlin carnate
devlin carnate

Reputation: 8602

It turns out that only the Enterprise version of SQL supports those non-additive measure settings. So the settings are there, visible and appear to be available, but they don't work. And there's no error. Nice "feature", Microsoft.

From this book:

Also semi-additive measures require Enterpise edition of SSAS

And from this blog:

One of the most frustrating limitations of SQL Server 2005 Standard edition is that it doesn’t support semi additive measures in SSAS Analysis Services cubes

Upvotes: 0

Related Questions