I have a performance issue with one Excel report that is connected to a SSAS 2008 cube that as about 120k records. The report works fine if we drop few attributes, but since we drop more attributes than usual (lets say, more than 10) for an ah-doc report,
the report becomes very slow. In SQL Profiler there are a lot of "Calculate Non Empty Current" events, but the MDX query generated by Excel as the NON_EMPTY function included. In this MDX, there are also a lot of CROSSJOIN, one for each field and
I don't know if this is this is correct.
Can someone help me? Thanks in advance.
View Complete Post