December 2007 Entries

SSAS: ASSP 1.2 Released
Just in time for another early Christmas present the Analysis Services Stored Procedure team have just released version 1.2. It incorporates and couple of new functions and a few alterations. Below are the main additions, you can follow the links to the wiki pages for more information about each of the following. StrToSet - is a new class that incorporates a couple of new functions. The functions in this class are designed to allow the StrToSet function to receive shorter strings by passing in just ......

Posted On Saturday, December 22, 2007 11:25 PM | Comments (0)

Connect Issue Updated
I had a notification recently that one of the issues that I have reported to the SQL Server connect site (http://connect.microsoft.c... ) had been fixed. Deploying a Renamed Database from BIDShttp://connect.microsof... This issue was closed a little while ago as being a duplicate of a bug in the internal bug database, which I was a bit disappointed in as this meant that I would no longer get automatic feedback on this issue. So I was pleasantly ......

Posted On Saturday, December 22, 2007 1:53 PM | Comments (0)

BIDSHelper version 1.2.0.1 Released
The BIDSHelper team have just released an early Christmas present. I have just uploaded the install for the version 1.2.0.1 release of BIDSHelper to www.codeplex.com/bidshelper. As you can probably guess from the numbering, this is not a major release, it contains a couple of bug fixes and a little bit of performance tuning. In particular: An issue with multiple BIDSHelper buttons appearing in the calculations tab of the cube designer has been fixed. An issue where the configuration/expression highlighter ......

Posted On Monday, December 17, 2007 11:37 PM | Comments (3)

powerSSAS: DMV Equivalents
I was reading Vidas Matelis' recent post on the metadata rowsets in SSAS 2008 and this got me to thinking about a discussion that Chris Webb and I had recently about the new "DMV" functionality is SSAS 2008. And that it basically that they are simply gives you an easier way to access information that is available through XMLA discover commands. And that you could already get to this information relatively easily through the Discover() function in the Analysis Services Stored Procedure (ASSP) project. ......

Posted On Monday, December 10, 2007 10:37 PM | Comments (0)