4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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
    Jens has been working with Microsoft Business Intelligence for more than a decade, with particular interest to Analysis Services. Besides being a BI Developer on various projects, Jens is also currently managing the MSBI Platform Expert at Maersk Line IT.Jens regularly contributes to online forums and has been speaking at SQLSaturdays, Campus Days 13, 14 and various User Groups.
  • Video
    The video is not available to view online.