Microsoft KB Archive/935996

= An MDX query takes longer than you expect to finish in SQL Server 2005 Analysis Services =

Article ID: 935996

Article Last Modified on 4/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
When you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services, the MDX query takes longer than you expect to finish. This problem occurs if one of the following conditions is true:
 * The MDX query contains an axis that is defined by using the Crossjoin operator (*).
 * The MDX query contains a slicer that uses the Crossjoin operator (*).

Note The MDX query that uses the Crossjoin operator (*) takes longer than an MDX query that uses the Crossjoin function.

This problem is more noticeable if the MDX query contains a calculated member that uses the Crossjoin operator (*).



CAUSE
This problem occurs because the Crossjoin operator (*) is not optimized for performance in SQL Server 2005 Analysis Services.

If the MDX query contains a calculated member that uses the Crossjoin operator (*), each cell that is returned by the expression is calculated. Therefore, this problem is more noticeable.



WORKAROUND
To work around this problem, use the Crossjoin function instead of the Crossjoin operator (*).



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbsql2005bi kbsql2005as kbexpertiseadvanced kbtshoot kbprb KB935996

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.