One of the strange omissions in BOL, even in its new improved July update, is that there doesn’t seem to be a page showing which features of Analysis Services are available in which editions (if there is please send me the link!). For example, I recently found out the hard way that Perspectives and Translations are not allowed in Standard Edition but I couldn’t actually find that fact documented anywhere; so how do you know, when you’re developing a cube (especially if like me you use Developer Edition) what features you’re allowed to use?
What you need to do is set the Deployment Server Edition property on your project appropriately. You can find it by right clicking on your project in the Solution Explorer in Visual Studio – it’s on the Build page of the Configuration properties dialog. If you have a project which uses features that are only available in Enterprise Edition and you have set Deployment Server Edition to ‘Standard’ you will get a list of errors when you build your project telling you that these features are unavailable in Standard Edition.
Not in the BOL, and in places a bit marketing-y, but:http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Thanks Kevin – a bit woolly, but all the information is there I think. It would be good to have it in BOL.
Thanks for the tip on the config properties. I also seem to recall that if you try and use a feature that Standard does not support then you get a warning in the relevant dialogue box. I that is where I picked up on the Perspectives issue as I was planning to use that once and had to re architect my design!
Also thanks for the tip.
A collegue of mine found the link in BOL after sending her your post:ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm
We have a case where, in some instances, we want to deploy to SQL Server Enterprise, with partitions and perspectives etc, and in other instances, only to Standard edition. It would be nice if BIDS recoginized the edition of Analysis Services it was deploying too, and only deployed the appropriate features. That would only work for some features however. If a cube used Semi Additive Measures it may not be possible, for BIDS to determine what to do.