easyROLES the fastest way to set up SSAS roles

Role Tutorials
Even faster way to create roles
Even faster way to create roles

One of our users sent a cool tip for speeding up role deployment even more. In their situation it was all about adopting BI Project development processes to include easyROLES. What they basically did was made sure that every time a new project (or a change request) is specified, the security part should always fit […]

Setting up Kerberos authentication
Setting up Kerberos authentication

Setting up Kerberos authentication can sometimes give headaches. It is really not hard (or scary as that puppy might seem at first) to get Windows to use this method of authentication and after the initial setup is done your users will definitely be thankful for not having to type in their credentials every time they […]

Cross-dimension security
Cross-dimension security

So far we have only looked at basic examples how to create SSAS security roles by limiting the users access rights to a member of one dimension. In real life situations we would often need to have a bit more advanced setup. Usually user right assignment is done on at least two dimensions within a […]

Visual totals in SSAS security
Visual totals in SSAS security

In our previous post we looked at how SSAS role security could be tested in Microsofts SQL Server Management Studio. The role we created is fully functional when we display the level on which security is applied (in this case it was member Pacific Sales Manager from level Title). However if we were to choose […]

Testing role functionality
Testing role functionality

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 […]

Add a new role in SSAS
Add a new role in SSAS

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… […]

We want you to be comfortable with your purchase and therefore offer 30 day 100% money back guarantee.