O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Analysis Services stored procedures

Analysis Services supports both COM and CLR assemblies (DLL files) as an extension of its engine, in which developers can write custom code. Once written and compiled, assemblies can be deployed to an Analysis Services instance.

Though the process of creating the assemblies is outside the scope of this book, using them is not, because of the benefits they bring you. The stored procedures implemented in those assemblies can be called from MDX queries, used in calculations, or triggered when an event occurs on the server.

If you haven't already read the previous recipe, do it now, because this recipe picks up where the previous one ended. It shows you how to register a popular open source assembly from the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required