Microsoft KB Archive/319637

= PRB: Incorrect Values Display When You Use a Count Function to View a Cube That Has a Virtual Dimension and a Measure =

Article ID: 319637

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q319637



BUG #: 12744 (Plato7.x)



SYMPTOMS
When you view the data of a cube that has a virtual dimension and a measure by using a Count aggregate function, some, or all, the values of the measure may be incorrect. The incorrect values become evident after you enable the cube for drillthrough. When you run a drillthrough query, it returns a number of rows that do not match the displayed count value.



CAUSE
This behavior may occur when a virtual dimension is created based on a physical dimension where a many-to-many or a one-to-many relationship exists between the members of a level and the member properties used to build the virtual dimension.



WORKAROUND
To work around this problem, change the member key to make sure that the relationship between the members of a level and the member property used to build the virtual dimension result in a one-to-one relationship.

Although you cannot re-design the underlying dimension structure, you can set the Virtual property of the virtual dimension to false.

