For instructions on creating and registering Analysis Services stored procedures, see the Books Online topic
Creating Stored Procedures
For information on using stored procedures in conjunction with association rules data mining to perform social network analysis, see the
and download the
by John C. Hancock.
For several other data mining related stored procs, see Jamie MacLennan's
and the sqlserverdatamining.com
- Here is one that's useful for finding the shortest or longest path to a leaf node in a decision tree.
- Here is one that builds the DMX CREATE MINING MODEL statement for an existing model.
- Here is one that calculates the goodness of fit of a regression model.
- Here is one that calculates covariance/correlation matrixes.
- Here is one that creates a data source object.
- Here is one that extracts information from a logistic regression model.
For an example of how to use a config file to store settings for Analysis Services stored procs, see a
by Teo Lachev.
For some performance tips and other sproc best practices, see a
by Mosha Pasumansky.
For information about debugging sprocs, see a
by Darren Gosbell.
For some examples of returning images from a sproc, see Hilmar Buchta's blog
. He also has a post about
and sproc performance.
For an example of using C# to deploy an assembly to Analysis Services using the management API, see this
. That thread also shows how to deploy a third-party DLL in addition to your assembly.
For an example of a stored procedure which allows you to retrieve members with identical names, see this
by Hilmar Buchta.
If your sproc opens a connection to Analysis Services, be sure to review the
Don't Deadlock Yourself
For an example of a stored procedure which merges two datasets into one dataset, see this blog post by François Jehl in
translated into English
For a list of best practices on when (and when not) to use stored procedures, see
blog post by Philip Stephenson based upon Darren Gosbell's list.
For an example sproc which allows a user to initiate cube processing from an Excel action, see this blog post by
For an example sproc to detect which roles the current user is in, see this
by Jon Burchel.
An example use of ASSP to
improve performance of drillthrough
in ROLAP mode against PDW.
Inclusion in ASSP: If you would like to see any of the above included in ASSP, please add a new feature request to the Issue Tracker tab or vote for an existing feature request.
Commercial SSAS Sprocs
IT-Workplace has a product called
Intelligencia Extensions for SSAS
which contains a sproc that draws a sparkline image.