Forum FAQ: How do I impersonate another user to test the MDX query in SSMS?

  • Article

Question

There is a button "Change User" in Cube Browser, we can impersonate other user in "Security Context" dialog. But in SSMS, how do I impersonate another user to test the MDX query?

Answer

In SSMS, connect to SSAS server, type the Server name and then click button “Options”. Switch to “Additional Connection Parameters” tab, specify the user account for property “EffectiveUserName”:

EffectiveUserName=”UserAccount”

You can also test the user account with below query:

WITH MEMBER MEASURES.X AS

USERNAME

SELECT MEASURES.X ON 0

FROM [Adventure Works]

 

But note: Only SSAS server administrators can use the EffectiveUserName property. Since you are still using current windows account to logon to the SSAS server, you will access to SSAS server with your own credential, and EffectiveUserName property only works with your MDX query.