Problems with SSAS role creation are soon to be history

It used to take for ever, I would always make some careless mistake and would always dread the day when I had to create many SSAS security roles or, even worse, make changes to the existing ones. Well, soon enough we will no longer have to worry about this little annoyance. Check out SSAS role management tool easyROLES! It is currently in beta and you can sign up for testing if you want.

Here is a video showing how fast it is to create many SSAS roles with the tool:

 

The whole concept is based around the idea that you always get some kind of access list from "the business" according to which you set the roles up. So, why not just copy/paste the specs and let the machine do the dirty work? Try in test environment, verify that all looks as it should, paste into production and be done with it.

Fast and painless!