Level: Intermediate to Advanced
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