When connected to an AS database, we can use the Excel pivot table filter technique “Keep Only Selected Items” on some dimensions but not others. I have a fairly
large dimension that can handle it no problem ( < 1 second ) and another smaller dimension that takes several minutes to return a result. During that time, there is very little SQL Profiler activity on the AS Server and very high processor use
on the Excel machine. In both cases there is very little time logged on SQL Profiler between Query Begin and Query End – the query is fast. It is also quick to run the same MDX query in Mgt Studio.
Is this a solve-able problem? The analysts here use this function pretty heavily.
View Complete Post