Excel Report was not passing right user id to SQL Server Analysis Services

Background: Windows 2003×64, 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…

0

Excel report with SSAS taking more time to refresh over Wan

We had seen scenarios where Excel Sheet with Pivot table takes less time locally but over Wan it takes more than hour to refresh. The issue which we fixed was on Excel 2007 with SQL 2008 AS (Cube had Cell Level Security Enabled) The resetting of the connection to Analysis Services within a report each…

1