Working with Stored Procedures (Analysis Services)

You can use stored procedures to call external routines from Microsoft SQL Server 2005 Analysis Services (SSAS). You can write an external routines called by a stored procedure in any common language runtime (CLR) language, such as C, C++, C#, Visual Basic, or Visual Basic .NET. A stored procedure can be created once and called from many contexts, such as other stored procedures, calculated measures, or client applications. Stored procedures simplify Analysis Services database development and implementation by allowing common code to be developed once and stored in a single location. Stored procedures can be used to add business functionality to your applications that is not provided by the native functionality of MDX.

This section provides the information necessary to understand, design, and implement stored procedures.

Topic Description

Designing Stored Procedures

Describes how to design assemblies for use with Analysis Services.

Creating Stored Procedures (Analysis Services)

Describes how to create assemblies for Analysis Services.

Calling Stored Procedures (Analysis Services)

Provides information on how to use assemblies in Analysis Services.

Accessing Query Context in Stored Procedures (Analysis Services)

Describes how to access scope and context information with assemblies.

Setting Security for Stored Procedures (Analysis Services)

Describes how to configure security for assemblies in Analysis Services.

Debugging Stored Procedures (Analysis Services)

Describes how to debug assemblies in Analysis Services.

See Also


Assemblies (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance