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 ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.