Browse by Tags

• .NET
• Analysis Services
• CodePlex
• Discover
• dmv
• mdx
• stored procedures

• 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 Read More... Posted Thursday, July 02, 2009 7:42 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, .NET, ASSP, CodePlex, stored procedures

• SSAS: Executing Arbitrary SQL queries

  I had a question a little while ago via my blog about possibly using a rowset action to execute a SQL query against a specified table. Although a rowset action will allow you to enter a SQL query, such a query is still executed against the current cube Read More... Posted Thursday, June 18, 2009 11:20 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, .NET, ASSP, stored procedures

• Building a better DMV

  Following along on my recent theme of exploring the metadata rowsets and the new Dynamic Management Views (DMV) in SSAS 2008. I have added a new DMV function to the Analysis Services Stored Procedure project ( www.codeplex.com/ASStoredProcedures ) which Read More... Posted Wednesday, January 30, 2008 9:45 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, dmv, mdx, ASSP, Discover