Using UserName to Control Data Access and Default Member in SSAS
A great sample from MS on how to use the UserName function to restrict data access and control the default member in SSAS, great stuff:
Using UserName to Control Data Access and Default Member in SSAS
I wish the Real world was as easy