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:

connectionstrings

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:
http://sqlblog.com/blogs/mosha/archive/2008/06/08/mdx-answer-to-nextanalytics-challenge.aspx

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:http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=3465774&SiteID=1

    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:

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,299 other followers

%d bloggers like this: