Article ID: 2216472 - View products that this article applies to.
When you run a ROLAP query that involves multiple parent/child dimensions and uses common table expressions (CTE), the ROLAP query can return incorrect results in some scenarios.
This issue occurs when the following conditions are true:
Service pack informationTo resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/968382/en-US/ )How to obtain the latest service pack for SQL Server 2008
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in SQL Server 2008 Service Pack 2 for SQL Server 2008.
For more information about the drillthrough statement, visit the following Microsoft website:
Article ID: 2216472 - Last Review: July 19, 2010 - Revision: 2.0