Analysis Services Security

In this tip we look at how hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.

Learn how to add a user (member) to a SQL Server Analysis Services (SSAS) Database role via PowerShell or XMLA scripts.

You have created your first SSAS database and cube. Now you want to secure the cube and related dimensions. In this tip we look at different options for setting security permissions.

I have installed a new instance of SQL Server 2008 Analysis Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Analysis Services features in SQL Server 2008?

I have a requirement to implement a custom security scheme where roles and the user's place in the organization hierarchy are used to determine which customers a user can access. In particular the requirements are that a sales person can only access thei

I have seen the tip Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005 which showed how to define roles in a cube to limit the members of a dimension that are available to the members (Windows users and/or groups) of the role. I

I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement