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 time a cube formula receives an error from Analysis Services due to restricted security access to a cube member referenced on a report.

Resolution

Read more...