Stored Procedures

There are 3 entries for the tag 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 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 ......

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 and only the subset of SQL supported by SSAS can be used. Basically the rowset action just returns a flattened result set. However what would be possible would be to write a .Net stored procedure and use that to execute your SQL query. The code itself ......

SSAS: Analysis Services Stored Procedure Project (ASSP) 1.1 release is out!

It's been a little while since we did the initial release of ASSP, but things have been bubbling along quietly in the background and today we pushed out another release which in addition to a few minor fixes includes the following new features. ListFunctions - This is cool on a couple of fronts (and not just because it is one of mine :) ) Firstly it is practical because it will list all the available functions in all the .Net assemblies that have been registered either at the server or, if you pass ......

News

About Me
I am a consultant, based in Melbourne Australia. I primarily work in the Business Intelligence area with SQL Server, although I also dabble in Content Management Server and .Net coding

Contact Me

MVP

Legal
Any and all code, software, examples, suggestions and anything else on this web site is available for you to use at your own risk. No warranty is expressed or implied.
Views and Opinions
The views and opinions expressed on this web site are not necessarily the views or opinions of my employer.

Subscribe in Bloglines Subscribe in NewsGator Online
Locations of visitors to this page

Twitter












Tag Cloud


Article Categories

Archives

Post Categories

.Net Blogs

Aussie Bloggers

BI Blogs

CMS Blogs

Syndication: