SQT11 Securing SSAS Data Without Tying Yourself in Knots


2:00pm - 3: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 to use role-based security in SSAS
  • Discover dynamic SSAS security
  • How to create custom SSAS security