Adding SSAS roles via Powershell
User Rating: / 0
PoorBest 
Written by Bhavik Merchant   
Tuesday, 07 September 2010 23:22

I needed to delve into Powershell again recently as a means to automate the creation of a long list of roles and the addition of AD groups to them.

Since there were so many i thought it would be easier to have a list of roles in a text file and just parse that to create all your roles automatically. The script posted here is a first pass that was used during development and does the following:

Read more...

 

 

 

Data Warehouse Explorer