Custom Assemblies in SSAS
Duration: 15 minutes
Custom assemblies enable you to extend the power of SQL Server Analysis Services (SSAS) by using other technologies, such as Transact-SQL (T-SQL) and the SQL Server relational engine. This session demonstrates how to use custom assemblies in SSAS to leverage the power of the relational engine and use it directly in Multidimensional Expressions (MDX). Through the .NET framework and T-SQL, you can inject dimension member unique names into MDX, effectively replacing the MDX crossjoins with the T-SQL inner joins and gaining scalability and consistency in query performance.