Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
An MDX query returns additional cell data when you use the IsEmpty function on the query axis in Analysis Services with SQL Server 2005 Service Pack 2
Article ID: 942839 - View products that this article applies to.
Consider the following scenario. In a Multidimensional Expressions (MDX) query, you specify a hierarchy of a dimension on the slicer axis. You also specify a different hierarchy of the dimension on a query axis. Additionally, you use the IsEmpty function on the query axis. Then, you run the MDX query in Microsoft SQL Server 2005 Analysis Services with Microsoft SQL Server 2005 Service Pack 2 (SP2). In this scenario, the MDX query returns additional cell data.
This problem does not occur in versions that are earlier than SQL Server 2005 SP2.
This problem occurs because the slicer axis uses the members from the query axis instead of the members that you specify on the slicer axis.
To work around this problem, use the NonEmpty function instead of the IsEmpty function.
For example, update the MDX query in step 5 from the "Steps to reproduce the problem" section as follows.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem
[Product].[Product Model Lines].[Product Line].&[R]
For more information about how to install the sample project, visit the following Microsoft Developer Network (MSDN) Web site: