Defining Stored Procedures
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
You can use stored procedures to call external routines from Microsoft SQL Server SQL Server Analysis Services. 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 SQL Server 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 SQL Server Analysis Services. |
| Creating Stored Procedures | Describes how to create assemblies for SQL Server Analysis Services. |
| Calling Stored Procedures | Provides information on how to use assemblies in SQL Server Analysis Services. |
| Accessing Query Context in Stored Procedures | Describes how to access scope and context information with assemblies. |
| Setting Security for Stored Procedures | Describes how to configure security for assemblies in SQL Server Analysis Services. |
| Debugging Stored Procedures | Describes how to debug assemblies in SQL Server Analysis Services. |
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for