Channel 9 Screencast - Dimension Security in SQL Server Analysis Services
A huge benefit of SQL Server Analysis Services is that just as accessing and manipulating data is more straightforward and oriented to the business, security is also easier to align with business needs.
In this video I walk through how straightforward it is to use roles in Analysis Services to determine what data a user can and cannot see. Very easy point-and-click, no code necessary.
In this video I walk through how straightforward it is to use roles in Analysis Services to determine what data a user can and cannot see. Very easy point-and-click, no code necessary.