Once you have set up your security roles, it is a good idea to test them. Microsoft SQL Server Management Studio provides great functionality for role testing and making sure that data is secured as it should be. For this example we will use the same Analysis Services Tutorial cube that we used in the […]
The conventional way to add a new security role to SSAS, assign Active Directory users or groups to the role and limit the role to only certain members of specific hierarchies is usually a rather long and time-consuming process. Not to mention all those clicks will wear your mouse out in no time at all… […]
All SSAS developer and maintenance teams are very well familiar with the tedious task of creating roles and giving access to users and groups that should see only a limited subset of data. Securing your cube takes hours (if not days in certain cases) and is always the worst part of development cycle. If you […]