Dynamic Security for Datwarehouse

The Dynamic Security which is used in SSAS Tabular Semantic is great, as it allows you manage the security through a table, and allows for a greate deal of flexibility (Which can be sourced from a data-source such as Excel) 

As an example, we have a matrix spreadsheet of many users, each who have a different combination of departments they can access. We can unpivot this to form a permissions list within the data-warehouse which is then applied using the Dynamic security in the Semantic model

It would be great to have this same functionality at the data-warehouse level.




Please sign in to leave a comment.