July 2009 Entries

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog post. So the following screen shots show how you would go about setting up such an action. As a quick example I cheated a bit and set up an Rowset action that calls the sp_who2 system stored procedure. This way I did not have a depedancy on any particular ......

Posted On Thursday, July 2, 2009 7:42 AM | Comments (15)

MVP for another year
It was very exciting to see an email from the MVP Award program in my inbox this morning saying that I had been re-awarded as an MVP for another year. This will be my 4th year as an MVP and I am very honored to have been re-awarded ......

Posted On Thursday, July 2, 2009 7:34 AM | Comments (6)