Expert Cube Development with SSAS Multidimensional Models
by Chris Webb, Alberto Ferrari, Marco Russo
Chapter 9. Securing the Cube
Security, for an Analysis Services cube is a very important issue and one that needs to be properly understood and implemented. It's almost always the case that some form of security needs to be in place: the data in the cube may be extremely sensitive. For example, if a cube contains sales data for a whole company, we may need to make sure that each sales person can only look at his or her own sales and no one else's; equally, if a cube contains data regarding the profitability of a company, it's likely we'll need to ensure that only the finance department and the board have access to it.
Ignoring security during the initial analysis phase will inevitably lead to problems during the deployment of the solution. We can't ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access