http://www.sqlservercentral.com/blogs/dknight/2011/02/21/testing-ssas-security-in-excel/

Printed 2014/04/20 03:50PM

Testing SSAS Security in Excel

2011/02/21

There are many posts available that describe how to test Analysis Services security from inside the development environment.  Today I would like to share a nice way to do this from excel.  When you create a connection to your Analysis Services database in Excel it creates an .odc file.  This file is used to store the connection string information about your connection.  This can also be deployed to SharePoint when using Excel Services.

To change what user is being impersonated in Excel (after initially creating a connection) you will need to go to the Data tab and select Connections.  That will open the screen below:

Select Properties on the connection to modify.  Then on the definition tab add the highlighted text with the desired role or username to test.

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.