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