Book Image

Expert Cube Development with SSAS Multidimensional Models

By : Alberto Ferrari, Marco Russon, Chris Webb
Book Image

Expert Cube Development with SSAS Multidimensional Models

By: Alberto Ferrari, Marco Russon, Chris Webb

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Sample security requirements


Before diving into technical details, let's outline the sample set of security requirements that we will use in this chapter to illustrate how security can be implemented.

Imagine we are building a BI solution for a multinational company, and we want to give employees and partner companies all over the world access to our cube. Here's what we will need to do:

  • We need to restrict access by Country: Canadian users will be able to see only Canadian data, French users will only be able to data for France, and so on.

  • We need to restrict access by Reseller. So if a user from the "Roadway Bicycle Supply" reseller queries the cube, they will only be able to see their sales and will have no access to other resellers' information. We will demonstrate two different ways to handle this requirement.

  • We need to restrict access to certain Measures, both real and calculated.

In a real-world project, the security requirements must be agreed with the customer and they should be specified...