easyROLES the fastest way to set up SSAS roles

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

Maintenance release 1.02

Maintenance release 1.02

An update to easyROLES is available as of today. Version 1.02 is a small maintenance release including a few minor bug fixes and support for Analysis Services 2014. In this software update we have fixed a few issues with the user interface which have been reported by customers during the first month. Annoyances like limited […]

v1.0 is now available!

v1.0 is now available!

The first ever stable public release of easyROLES – Analysis Services role management tool – is from now on available for download and you will never have to click in another role again. This is the first release but it is already packed with functionality which designed to help you automate and speed up role creation process. […]

β2 tests starting today!

β2 tests starting today!

Today we started rolling out version β2 of easyROLES SSAS role manager for testing. The first few days we will be spending on a few dedicated sites making sure all is as it should and afterwards everyone who has signed up for beta testing will receive a download link to the β2 package. Besides stability updates and […]

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

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

Maintenance release 1.02
Maintenance release 1.02

An update to easyROLES is available as of today. Version 1.02 is a small maintenance release including a few minor bug fixes and support for Analysis Services 2014. In this software update we have fixed a few issues with the user interface which have been reported by customers during the first month. Annoyances like limited […]

v1.0 is now available!
v1.0 is now available!

The first ever stable public release of easyROLES – Analysis Services role management tool – is from now on available for download and you will never have to click in another role again. This is the first release but it is already packed with functionality which designed to help you automate and speed up role creation process. […]

β2 tests starting today!
β2 tests starting today!

Today we started rolling out version β2 of easyROLES SSAS role manager for testing. The first few days we will be spending on a few dedicated sites making sure all is as it should and afterwards everyone who has signed up for beta testing will receive a download link to the β2 package. Besides stability updates and […]

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

β1 field tests last week
β1 field tests last week

Throughout last week we have been testing easyROLES (which is THE ultimate tool for maintenance of SSAS security roles; check out the video to see how easy it is to create roles) outside the comfort of our own lab. For us at easyROLES this was a week full of excitement and joy! It was absolutely fascinating […]

The Role Race
The Role Race

Today we published our first video showing how fast easyROLES is at creating SSAS Security roles and adding members to these roles. As you can see it took arround a minute total time to create roles for a whole bunch of product groups from Analysis Services Tutorial cube and assign AD groups or users to […]

Surviving corporate restructuring
Surviving corporate restructuring

This is inevitable – corporate restructuring, when different units are merged, moved around and created, will hit your Data warehousing / Business Intelligence team one day or another (some of us deal with this yearly). An avalanche of changes to hierarchies, security roles and reports will follow as well. Here are some considerations to help […]

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

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