How do you setup dynamic security to SSAS 2005 database based on current user

Written by Vidas Matelis. Posted in Management FAQ

Q: How do you setup dynamic security to Microsoft SQL Server Analysis Services (SSAS) 2005 database based on user that is querying database?

A: You can read about dynamic security in the paper by Carrie Williams: "Using UserName to Control Data Access and Default Member in SSAS 2K5".