June 2008 Entries

Today I was moving a prototype dashboard off a virtual server onto a development server. I saved the workspace file and copied it over and I got the following error when I clicked the test button in the data source page - "Unable to connect to the specified server. Make sure the address is correct" This was a bit puzzling as it was connecting to "localhost" so it should have worked fine on the dev server. If you do a search in your favorite search engine for this error you will possibly come across ......

Share This Post:
Short Url: http://wblo.gs/W0O

A little while ago Jamie posted about how he formats SQL code which happens to be quite similar to the way I do it. But this then lead me to think about the equivalent formatting for MDX. So if I get MDX like the following:with member measures.ptd as 'sum(periodstodate([Date].[... [Date].[Calendar].currentme... Amount] )',format_string = "currency" select {[Measures].[Measures].[Sales Amount] ,measures.ptd} on 0, {[Date].[Calendar].[Month].... ......

Share This Post:
Short Url: http://wblo.gs/Vxl

[via EXEC dbo.LongTermMemory__Archive] Apparently SQL Server now has a new logo. It's interesting... I think they felt left out at the launch events with Visual Studio 2008 and Windows Server 2008 when they were the only product without a logo. I'm not quite sure what it's meant to be, but to my eye it seems to have been influenced a bit by the Kookaburra :) What do you think this new logo is ......

Share This Post:
Short Url: http://wblo.gs/Vuo

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.

Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

NetworkedBlogs

Blog:

Random Procrastination

Topics:

MDX, SQL Server, BI

Follow my blog

Twitter

darrengosbell @blu3S41l0r It's really a new capability of MD not Power View, so yes, Dax Studio will work with MD servers running SQL 2012 CU 4 or later about 13 days ago

darrengosbell @mtydeman sorry, was not on twitter last week. Yes, SSAS MD works well with snowflakes. The joins are resolved during dimension processing about 38 days ago

darrengosbell SSAS: Clearing the MDX Script for a session in SSMS http://t.co/jioE6bQO about 137 days ago

darrengosbell SSAS: Executing MDX Scope statements using SSMS http://t.co/Tpx9pfoz about 182 days ago

darrengosbell @MitchDenny thanks - I had a ball, #powerview is such a cool thing to demo about 273 days ago

darrengosbell @asantaballa @jenstirrup daxeditor is not me, that's an MS sample. I'm working on http://t.co/b1JsRLps at the moment about 330 days ago

darrengosbell @Technitrain I can see it too about 330 days ago

darrengosbell @jppp I hope you enjoy the 2012 release :) life's been pretty good - too busy, but still good. about 455 days ago

darrengosbell BIDS Helper 1.6 Beta Release (now with SQL 2012 support!) http://t.co/dSWkG7PI about 455 days ago

darrengosbell @Kjonge just showed that in post-ctp3 #denali #Dax in #ssas will have query plans as profiler events about 613 days ago

Darren Gosbell [MVP] - Random Procrastination

Business Intelligence, SQL Server, .Net, Powershell and MDX Madness

June 2008 Entries

Performance Point Monitoring - cannot connect to the specified server

A Rose by any other name - MDX Formatting

A new Logo for SQL Server

News

Twitter

Tag Cloud

Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: