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

The information in this article 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.

REFERENCES

For more information, visit the following Microsoft Web sites:

Creating Virtual Dimensions

Aggregate Functions

Modification Type:	Major	Last Reviewed:	7/24/2003
Keywords:	kbinfo kbprb KB319637 kbAudDeveloper