Article ID: 947511 - View products that this article applies to.
When you run a Multidimensional Expressions (MDX) query against an instance of Microsoft SQL Server 2005 Analysis Services, you receive the following error message:
This problem occurs when the following conditions are true in the WHERE clause of the MDX query:
The set in the WHERE clause cannot contain multiple measures.
Because the members from these attributes do not co-exist, the WHERE clause generates a NULL tuple. When SQL Server 2005 Analysis Services tries to calculate the current cell, the calculation fails because the current measure is an empty set.
To work around this problem, move the combination of the members that do not co-exist into a separate axis. For example, you can update the MDX query in the "Steps to reproduce the problem" section as follows:
Applications may generate MDX queries that meet the conditions that are described in the "Symptoms" section. In this situation, you may encounter the same problem. For example, you may encounter the problem in ProClarity. However, you cannot use this method to work around this problem because you may be unable to access the MDX queries.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problemExecute the following MDX query against the Adventure Works cube of the AdventureWorks Analysis Services Project Enterprise Edition sample project.
Note The AdventureWorks Analysis Services Project Enterprise Edition sample project is included in the Analysis Services database project. To download the Analysis Services database project, visit the following Microsoft Web site: