Getting Started with Row Level Security

In this article, I will use the following features: Parent Child Relationships, Row Level Security in Analysis Services (AS) 2012 Tabular Mode, and the Analyze in Excel feature in SQL Server Data Tools (SSDT). This article will also use various DAX functions to accomplish these goals.

In the book "Professional Microsoft SQL Server Analysis Services 2008 with MDX" (Siva Harinath, March 2009, Wrox Press), there is a chapter on security in a multi-dimensional database. This chapter is based on a survey conducted by the director of a company that would like to understand the satisfaction level of their employees. This survey requires that managers are only allowed to see feedback if at least four employees reporting up to them have responded. If less than four respond, a manager is unable to see any results. This is designed to protect the identity of those responding to the survey, so that a manager is not able to guess who gave a negative score.