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


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft SQL Server OLAP Services 7.0 SP1
  • Microsoft SQL Server OLAP Services 7.0 SP2
  • Microsoft SQL Server OLAP Services 7.0 SP3
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.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:6/30/2004
Keywords:kbBug kbfix kbSQLServ2000preSP2Fix kbssas800sp1fix KB296186
©2004 Microsoft Corporation. All rights reserved.