The Power of Custom Assemblies in Analysis Services

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 performance.
Presented by Jens Vestergaard at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    portræt.JPG
    Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services to report in Reporting Services, Targit or similar tool. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the skills in MS SQL Server, Jens has also worked with Microsoft. Net platform for more than 10 years, and can as a certified ASP.Net developer comply with requirements exceeding the normal tools. Jens has worked as a developer on the 'Effektor' team at Rehfeld Partners A/S for three years, and now works as a senior consultant in the team for the government, private and municipal clients. Prior to that he has worked as a BI consultant, delivering reports on POS data.
    http://www.t-sql.dk
  • Video
    The video is not available to view online.