Business Intelligence and Big Data with the Microsoft Stack, For Database Administrators

SQTH17 Secure SSAS Data Without Tying Yourself Up in Knots


3:00PM - 4:15PM

Level: Intermediate to Advanced

Craig Utley

Craig Utley



Are you looking for the best way to secure the data in your cube? There are several approaches to applying data security, each with its own pros and cons. Learn about the basic built-in security, and then see approaches for extending this through dynamic security, using security dimensions, and SSAS stored procedures. You'll see examples of each as well as a discussion of when to use which approach.

You will learn:

  • How security works in SSAS
  • How to decide on which security implementations to choose and why
  • How to extend the security model with custom security