Report Portal

SSAS : Set up simple security in Analysis services

In this post i will describe the basics of the security of a cube. For this purpose i'll be using the ResearchAverage cube i've worked before and is described in the following posts:

  • SSAS : Selecting a dynamic period in a MDX query
  • SSAS/SSRS : Calulating sums and averages with M2M dimensions

Security in SSAS is controlled by roles which allows you to group windows users according to their needs. (windows) Users are members in roles and that determines whether a user can access a cube (and how).

Read more...

Tags: security

 

2007-2015 VidasSoft Systems Inc.