Excel Report was not passing right user id to SQL Server Analysis Services
Background:
Windows 2003x64, SQL 2005 SSAS with Dimension Security Enabled
In this scenario when we were opening an Excel Report deployed on SharePoint it hangs the report when we try to expand the user hierarchy
Resolution
To work around this issue, disable the local SID cache on the domain member computer. To do this, follow these steps: