Chris Webb's BI Blog

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

Deployment Wizard Bug

with one comment

The Deployment Wizard is meant to allow you to deploy a project from BIDS but not overwrite certain parts of the associated Analysis Services database. Examples of things you’d not want to overwrite on the server include partitions, connection strings and security settings. However once I started actually using this functionality with my customers over the last few months I came across (or rather was informed of by one of said customers and was able to repro with others) a pretty major bug: when you select the ‘Retain Roles and Members’ option to not overwrite any of the security roles, while it does indeed not overwrite any of the roles it sets cube access in all of them to None and this in turn loses all the dimension security settings defined on the roles. So, be warned… it’s with PSS at the moment but I’m told it probably won’t be fixed in SP2.

UPDATE: I haven’t tested this myself, but according to Dan English this has been fixed in AS2008:
http://denglishbi.spaces.live.com/Blog/cns!CD3E77E793DF6178!490.entry

Written by Chris Webb

December 16, 2006 at 9:49 pm

Posted in Analysis Services

One Response

Subscribe to comments with RSS.

  1. Hi Chris. The Dan English blog link has changed. Now it’s here:

    http://denglishbi.wordpress.com/2008/07/20/ssas-deployment-wizard-retaining-permissions/

    Regards

    lucazav

    April 12, 2013 at 11:45 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,301 other followers

%d bloggers like this: