Microsoft KB Archive/297799

= PRB: Empty Cells Are Returned by a MDX Query that Uses a Non Empty Clause =

Article ID: 297799

Article Last Modified on 11/21/2006

-

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.

