Microsoft KB Archive/203591

= BUG: Cannot Drill Down Virtual Dimension with More Than 760 Members =

Article ID: 203591

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q203591



BUG #: 7153 (platovn)



SYMPTOMS
By design, a virtual dimension is limited to having maximum of 760 members. However, if a virtual dimension is based on a column that has more than 760 rows, OLAP Services fails to report any error.

In such cases, if you just browse the virtual dimension, you will be able to see all the members (more than 760). However, you will not be able to drill down data for this dimension when you browse the cube.



WORKAROUND
Create a regular dimension instead of a virtual dimension if you have more than 760 members.



STATUS
Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.

Additional query words: virt dim greater than

Keywords: kbbug kbpending KB203591

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.