Next Meeting: Tue, Oct 14 2014
HASSUG & H-BI Monthly Meeting - October 14, 2014
Event Type: In-Person
Online Meeting URL: None
The schedule for this meeting will be:
11:30-11:40 – Announcements
11:40-12:40 – SQL Bytes - By HASSUG Members
12:40-1:00 – Lunch (Sponsored by Pariveda Solutions)
1:00-2:00 – Implementing a data-driven security modelin SSAS – Evan Hein & Mike Duffy
2:00-2:30 – Recap Announcements & Networking
UTC : Tue, Oct 14 2014 16:30 - 19:30
Event Time : Tue, Oct 14 2014 11:30 - 14:30 Central Daylight Time
Your Local Time: Tue, Oct 14 2014 16:30 - 19:30
2000 W. Sam Houston Pkwy S. #350
Short topics presented by various HASSUG members. First-come, first-present as time permits. Please keep topics under 10 minutes.
Implementing a data-driven security model in SSAS
Evan Hein Pariveda Solutions
The "additive" design of SSAS role security can present some unexpected challenges when trying to implement a data-driven security model based on multiple dimensions. This may be a relatively common use case in enterprise scenarios, such as the case where a sales rep is restricted to only see data in his primary region or in regions in which he has sold products. In this talk, we will introduce two potential solutions to this problem: the “Monolithic Security Dimension”, and the custom role assembly.
Evan is an Associate at Pariveda Solutions with experience across the Microsoft stack from .NET application development on the desktop, the web, and mobile devices to enterprise solutions using SQL Server and SharePoint.