Chapter 11. Security

Chapter Objectives Estimated time: 1.5 hours
In this chapter, you’ll learn how 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 multidimensional expressions (MDX) expressions to apply cell-level security.

In most real-world applications, OLAP databases are designed to answer many different questions that might be asked by diverse groups of individuals. 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. ...

Get Microsoft® SQL Server™ 2000 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.

Start your free trial