Microsoft KB Archive/935995

= When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected =

Article ID: 935995

Article Last Modified on 4/18/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
You have a Multidimensional Expressions (MDX) query that meets one of the following requirements:
 * One of the axes of the query is defined by using the DefaultMember function.
 * A slicer is included in the query, and the slicer uses the DefaultMember function.

When you run the query in Microsoft SQL Server 2005 Analysis Services, the query takes longer to run than expected. That is, the query takes longer to run than it does in the following situations:
 * When you use the default member of the hierarchy instead of the DefaultMember function
 * When you use the default member of the dimension instead of the DefaultMember function

This problem is more noticeable if the query contains a calculated member that uses the DefaultMember function.



CAUSE
This problem occurs because the performance of the DefaultMember function is not optimized in Analysis Services.

If an MDX query contains a calculated member that uses the DefaultMember function, each cell that is returned by the expression is calculated. Therefore, the problem is more noticeable in this situation.



WORKAROUND
To work around this problem, use one of the following instead of the DefaultMember function:
 * The default member of the hierarchy
 * The default member of the dimension



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 KB935995

-

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

© Microsoft Corporation. All rights reserved.