Securing the data

Every data model that contains data needs to be secured. Tabular also provides role-based and row level security, such as multidimensional. Role-based security can be connected to windows domain users as members of this role, and then the permissions on each of the tables can be set. DAX can be used to set the row level security for data.

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.