Dynamic SSAS (SQL Server Analysis Services) Tabular Role Security - One Role to multiple cubes.

It has been quite a while since my last actual blog post. I do hope that this will help people to use a simple security model, which is easy to implement and maintain. The idea is further down the line to have an application sitting above the security table, so that the right people can add and remove access without our intervention. What we are going to explain below is to use Dynamic SSAS Role Security.