Chris Webb's BI Blog

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

Connection String Properties in SQLMS RC0

with 3 comments

I heard this was going to be possible back in March, but now I’ve seen it in RC0 – you can now set connection string properties in SQL Management Studio when opening an MDX query window. Just click the new MDX query button, then click Options and you’ll see a third tab:


Although it’s much less common to need to set connection string properties, there are still a few scenarios where it’s useful. One example is the ‘Cube’ connection string property, which allows you to write session scoped script assignments in the way Mosha does here:

Another good example is when you’re using the Roles or EffectiveUserName properties to test out how queries behave with security.

Written by Chris Webb

June 9, 2008 at 5:04 pm

Posted in Analysis Services

3 Responses

Subscribe to comments with RSS.

  1. Hello Chris,I don\’t know how to contact you so trying this route. Could you please have a look at the issue I am facing in AS2005 aggregate() function. I have recreated the problem using AdventureWorks as well as FoodMart 2000 cube so that you can look at the issue directly at your end.Thanks a lot for your help.Regards,Ajit.

    Ajit Singh

    June 13, 2008 at 11:53 am

  2. Sorry, forgot the forum link where the problem is explained with MDX queries:

    Ajit Singh

    June 13, 2008 at 11:54 am

  3. […] with the connection string set as follows (see here for how to do this in SQL Server Management Studio; but beware – this bug is still around in […]

Leave a Reply

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

You are commenting using your 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


Get every new post delivered to your Inbox.

Join 4,046 other followers

%d bloggers like this: