Re: AS2000 Query very slow with Excel 2003 PTS
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Sat, 13 Jan 2007 19:44:36 -0800
For any calculated measures, set the NON_EMPTY_BEHAVIOR property if
possible:
http://support.microsoft.com/default.aspx?scid=kb;en-us;304137
INF: How to Increase the Speed of MDX Queries that Contain the NON EMPTY
Keyword
Article ID : 304137
Last Review : July 15, 2004
Revision : 1.1
This article was previously published under Q304137
SUMMARY
In some cases, a query slows down considerably when you use both the NON
EMPTY keyword on an axis of a Multidimensional Expression together with
a calculated member.
This article describes how you can optimize a query, by using the Non
Empty Behavior property for the calculated member.
..
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: Re: Allowed Member Set with 2 Attributes
- Next by Date: Re: Selecting a Dimension Hiearchy by Default
- Previous by thread: AS 2000 repository on MS SQL 2005 - is it supported?
- Next by thread: Re: AS2000 Query very slow with Excel 2003 PTS
- Index(es):
Loading
