July 2007 Entries

I agree - It really is all about MDX (baby)
Nick Barclay did an interesting post recently, advocating learning MDX if you are going to be working with Performance Point Server. This is due to the fact that Performance Point builds SSAS cubes on the back end and SSAS which lives and breathes MDX. So the same advice really also extends to anyone using SSAS. You really need at least one MDX guru on your team - someone that can write MDX select statements, if you want to get the most out of SSAS. A couple of resources that Nick did not mention ......

Posted On Friday, July 27, 2007 10:24 AM | Comments (0)

SSAS: AMO gems from the MSDN Forum - Measures.Remove()
The second gem from the Analysis Services MSDN forum is also by Adrian Dumitrascu and deals with what the second "CleanUp" argument of the Measures.Remove() method does. MeasuresCollection.Remove() Method The 'cleanUp' boolean argument specifies if the dependent objects will be removed. For a Measure, the dependents include the PerspectiveMeasure objects. For a DimensionAttribute, the dependents include the CubeAttribute objects. If you do not specify the 'cleanUp' parameter, the dependents are removed. ......

Posted On Wednesday, July 18, 2007 11:32 PM | Comments (0)

SSAS: AMO gems from the MSDN forum - MajorObject.Update()
Here is another gem from the Analysis Services MSDN forum by Adrian Dumitrascu from the product team. The one from this thread deals with what exactly the .Update() method does. And was in the context of talking about creating new roles in a database. MajorObject.Update() Method Even if you create the role as new, it's still not needed to call database.Update(). Calling role.Update() is enough. The .Update() method only saves the minor properties and collections (thus not the major children) of an ......

Posted On Wednesday, July 18, 2007 7:55 AM | Comments (0)

SQL Server 2008 - launch date announced
Sorry - I got one important word wrong when I posted previously that the release launch date had been announced for SQL Server 2008. It turns out that Feb 27th 2008 is the launch date and not the release date. I should have known better, this is the same scheme that the mighty Microsoft marketing machine came up with for the 2005 launch. Oh well - it should be a good party anyway and with any luck the actually release date will be about the same time ......

Posted On Monday, July 16, 2007 7:54 PM | Comments (2)

SSAS: Detecting the version of SSAS on a given server
To detect the version of AS, use ADOMD and connect using a connection string like "Provider=MSOLAP;Data Source=<server>;" where <server> is the name of your server. If you have the 2000 and 2005 providers on your system, the 2005 provider will attempt to connect to first and will then fall through to using the 2000 (v8) provider if the server is an AS2000 server. Once you have an open ADOMD connection you can check the value of the ServerVersion property of the connection. A value with ......

Posted On Saturday, July 14, 2007 8:08 PM | Comments (1)

SQL Server 2008 - release date announced
[via SQL Server Central] Apparently at it's recent Worldwide Partner Conference, Microsoft announced that SQL Server 2008, Visual Studio 2008 and Windows Server 2008, will all be released on Feb 27, 2008. Cool :) In the current CTP, the BI Development Studio is still using the VS.NET 2005 shell,given the release dates, it will be interesting to see if it moves to the VS.NET 2008 shell ......

Posted On Saturday, July 14, 2007 6:20 PM | Comments (1)

SSAS: Exporting MDX from Profiler part 2
Greg Galloway commented on the previous post I made about exporting captured MDX queries from SQL Profiler, indicating that there was an issue with using the MDX cap Greg has posted an issue on connect which you can vote on here, but I can't see this behaviour changing in the near future. Maybe in Katmai they could make the extract smart enough to do the parameter replacement as it creates the .mdx file. As far as I am aware the Analysis Services provider in SQL Server Reporting Services (SSRS) 2005 ......

Posted On Wednesday, July 4, 2007 7:57 AM | Comments (4)

Re-Awarded for 2007!
I'm back! I just got an email from the Microsoft MVP program this morning letting me know that I have been re-awarded as an MVP for 2007. For those of you that may not be aware, the MVP award is given for a 12 month period, based on your contributions to the community for the last 12 months. I've been doing a few different things this year compared to the year before and the MVP program itself has been consuming some of my time, so I have to admit to being a little anxious coming up to my first renewal. ......

Posted On Monday, July 2, 2007 7:49 AM | Comments (4)

SSAS: Exporting MDX and XMLA from SQL Server Profiler
Hey, why didn't anyone tell me about this one? :) I was not looking for this, I was looking for someway to easily extract event durations without having to get my hands dirty with angle brackets (XML) and I stumbled upon the menu below. It appears that you can easily extract "MDX Events" or "All Queries" to an .mdx file. Notice that there is also one for Extracting DDL events, so presumably you could extract the XMLA for a set of operations on the server or database so that you could wrap them up ......

Posted On Monday, July 2, 2007 7:17 AM | Comments (1)