Deep-Dive to Analysis Services Security

The Session will cover all advanced topics that you need to know about when developing high complex security solutions for your SSAS database. Those topics include cross-level dimension security, multiple role combinations and foremost dynamic security setups. All of them are designed for different business requirements but no solution fits them all. The different approaches will be examined on their impact on caching, connection time and also maintenance and in the end you probably understand why it can sometimes make sense to have 2000+ dynamic roles in your SSAS cube! A major part of the session will be dedicated to dynamic security using SSAS assemblies. Especially for complex requirements this is often the last hope. This session will guide you through the most common and uncommon pitfalls that you will encounter and show how to work around them.
Presented by Gerhard Brueckl at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 860 KB
    Video available MP4 Video HD 543 MB
  • SpeakerBIO
    Gerhard has been working with Microsoft BI tools since 2006 mainly focusing on Microsoft SQL Server and its components. As a consultant and architect he designed various enterprise BI solutions primary in the German-speaking areas. His personal interest has always been on analytical databases and their capabilities. In 2012 he achieved the SSAS Maestro certification. He is also very active in the community, has its own blog and speaks at conferences all over the world on a regular basis.
  • Video