Chapter 11. Implementing Security

After completing this chapter, you will be able to:

  • Create security roles in an OLAP database.

  • Manage security roles at the database and cube levels.

  • Restrict access to dimensions and parts of dimensions.

  • Create a custom calculated member for different roles.

  • Create MDX expressions to apply cell-level security.

In most real-world applications, online analytical processing (OLAP) databases are designed to answer many different questions that diverse groups of individuals might ask. For example, a sales representative might be interested in his or her sales in a particular region by product by customer. A district manager might be interested in the total sales in one region by product by customer. And a technical support ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.