SQL Marketing published the table with differentiation between different editions of SQL Server 2005 -
http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp. However, since SQL Server is such a big product, not every single technical detail made into it, and I lately got several questions about some details of feature differentiation in Analysis Services. First, obviously, everything that was available in Standard Edition of Analysis Services 2000 is still available in Standard Edition of Analysis Services 2005. Unfortunatelly, there was a typo error in the published table which incorrectly put Custom Rollups into Enterprise Edition only. This is really just a mistake that somehow got there. We don't take away features. It is actually vice versa - as Tom Rizzo wrote about in his
blog - we have really added value to the product by shifting several features which were previously available only in Enterprise Edition to the Standard Edition. In case of Analysis Services, you will immediattely see, that cell calculations, that were only part of Enterprise Edition in AS2K, now are available in all editions. New MDX Script constructs such as SCOPE, assignments, FREEZE etc - which are even more powerful then old style CREATE CELL CALCULATION statements are also available in Standard edition. Another example is HTTP connectivity feature. Recognizing how important scenarios of extranets and Internet access to the data not only for big enterprises but also for smaller companies is, we decided to make HTTP connectivity a feature of Standard edition as well. And there is more. The bottom line is Standard Edition of AS2005 is a better product then Standard Edition of AS2K, not just because it is new version, but also because it will have more staff.