PRB: Empty Cells Are Returned by a MDX Query that Uses a Non Empty Clause (297799)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q297799

SYMPTOMS

When you execute an MDX query that uses the NON EMPTY keyword against a cube with a dimension that contains a custom rollup with a LookUpCube function, empty cells are returned.

CAUSE

This behavior occurs when the Execution Location property of the connection string is set to a value of 3 (Server).

RESOLUTION

Set the Execution Location property of the connection string to a value of 0, 1, or 2.

STATUS

This behavior is by design.

REFERENCES

For additional information about the Execution Location property, see the "Execution Location Property" topic in SQL Server 2000 Books Online.
Modification Type:MinorLast Reviewed:4/24/2003
Keywords:kbprb KB297799 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.