Report Portal

Analysis Services Security: Multiple Roles in Tabular vs. Multidimensional

In terms of security tabular and multidimensional models of SQL Server Analysis Services are very similar. Both use Roles to handle specific security settings. Those Roles are then assigned to users and groups. This is very trivial if a user only belongs to one Role - the user is allowed to see what is specified in the Role. But it can become very tricky if a user belongs to more than one role.

Read more...

Tags: design, security, tabular

 

2007-2015 VidasSoft Systems Inc.