Microsoft KB Archive/296186

= FIX: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell =

Article ID: 296186

Article Last Modified on 2/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server OLAP Services
 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q296186



BUG #: 11254 (Plato7.x)



SYMPTOMS
When you edit a calculated member or a calculated cell that has a dependent calculated member or calculated cell, either #ERR appears in the browser of the Cube Editor or incorrect values and the order of the calculated members are incorrect.



RESOLUTION
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
After you save the cube in the Cube Editor, the value and the order of the calculated members is corrected.



STATUS
Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0 and SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in SQL Server 2000 Service Pack 2.



Steps to Reproduce Behavior

 * 1) Edit the Sales cube in the Foodmart 2000 database.
 * 2) Add a calculated member named C1 with a value of 1.
 * 3) Add a second calculated member named C2 with a value of [Measures].[C1].
 * 4) Navigate to the Value property for the C1 calculated member, and then change the value to 2.
 * 5) Browse the cube in the Cube Editor by clicking the Data tab.

You will see C2 listed before C1 in the columns of Measures and C2 will have a value of 1 instead of having a value of 2. If you change a slice of one of the dimensions, C2 then display #ERR. After you save the cube in the Cube Editor, the value and the order is correct for C2.

Additional query words: OLAP

Keywords: kbbug kbfix kbsqlserv2000presp2fix kbssas800sp1fix KB296186

-

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

© Microsoft Corporation. All rights reserved.