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 see data for France, and so on.
We need to restrict access by Reseller. So if users from the "Roadway Bicycle Supply" reseller query 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...