When attempting to deploy a cube to a SQL 2005 Standard Edition
installation, we are prompted with an error message that states:

Errors related to feature availability and configuration: The 'Semi-additive
measures' feature is not included in the 'Standard Edition' SKU.


Is this true? Or is something else afoot here?

Thanks,
Steven

Hi Steven,

Indeed, this does appear to be true:

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

Features Supported by the Editions of SQL Server 2005
...
SE = SQL Server 2005 Standard Edition

Features/Analysis Services Enhancements
EE (32-bit)/DE (32-bit)/EE (64-bit)/DE (64-bit)

SE (32-bit)

WG (32-bit)

SSE (32-bit) and SSEA (32-bit)

SE (64-bit)

Advanced Analytic Features

Account Intelligence
Yes
No
No
No
No

Cross-database/cross-server linked measures and dimensions
Yes
No
No
No
No

Metadata translations
Yes
No
No
No
No

Perspectives
Yes
No
No
No
No

Semi-additive Measures
Yes
No
No
No
No

Writeback Dimensions
Yes
No
No
No
No
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

exact, not supported in Std
perspectives and partitions are not supported too

"Steven H" <steven.heinz (AT) ilg (DOT) com> wrote

Wow! That suckz! Analysis Services is basically useless in the Standard
Addition - Semi Additive Measures are a common need for data analysis such
as inventory levels, etc.


"Jeje" <willgart (AT) hotmail (DOT) com> wrote