we have a citrix server hosting excel 2010 which queries a SQL 2008 SSAS server. when running a pivottable query with locally installed excel, it runs in less than 10 seconds. when running the same query with excel on a citrix server, it runs forever, up to 1 hour.
any ideas what the bottleneck could be on citrix? where to look?