Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Deployment Server Edition

with 5 comments

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.

Written by Chris Webb

September 4, 2006 at 9:10 pm

Posted in Analysis Services

5 Responses

Subscribe to comments with RSS.

  1. Not in the BOL, and in places a bit marketing-y, but:http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

    Kevin

    September 5, 2006 at 1:11 am

  2. Thanks Kevin – a bit woolly, but all the information is there I think. It would be good to have it in BOL.

    Chris

    September 5, 2006 at 6:43 am

  3. 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!

    Charlie

    September 5, 2006 at 2:13 pm

  4. 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

    Unknown

    September 11, 2006 at 11:01 am

  5. 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.

    Data Info

    December 16, 2009 at 4:44 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,144 other followers

%d bloggers like this: