1
kudos
spam Kudos Remove

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

published 1030 days, 20 hours, 21 minutes ago posted by sasa 1031 days, 5 hours, 39 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:12:47 AM GMT

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 d...

category: Analysis | clicked: 8 | | source: geekswithblogs.net | show counter code
tags: ASSP, Codeplex, SSAS, Stored Procedures

No comments yet, be the first one to post comment.

To post your comment please login or signup