Testing SSAS Security in Excel

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s