Connection String Properties in SQLMS RC0
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:
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.
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
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
[...] 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 [...]
Validating MDX Queries Without Running Them « Chris Webb's BI Blog
January 29, 2013 at 11:53 am