Details

Custom Assemblies in SSAS

15 minutes
BI
Beginner
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.
Some level of SQL & .Net knowledge a plus. Working experience with SSAS.

Back to Top cage-aids
cage-aids
cage-aids
cage-aids