The Power of Custom Assemblies in Analysis Service

60 minutes
Track 4
Sometimes you are stuck with customer demands where common solutions just aren't scalable within the Analysis Services (SSAS) regular toolbox. This is where custom assemblies come to save the day! Custom assemblies allow you to extend the power of SSAS by using other technologies, as in this case T-SQL and the SQL Server relational engine. This session will demonstrate how to utilize custom assemblies in Analysis Services to leverage the power of the relational engine and use it directly in MDX. Through the .Net framework and T-SQL we will be able to inject dimension member unique names into MDX. Effectively we are replacing the MDX Crossjoins with the T-SQL Inner joins, whereby gaining scalability and consistency in query perfo

Back to Top cage-aids