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 a particular 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 Analysis Services Stored Procedure Project (ASSP).
The first part of this recipe focuses on the ClearAllCaches stored procedure in particular, which clears both the Analysis Services cache and the file system cache, therefore allowing BI developers...
