FIX: Change of Caption Property of a Private Dimension Returns Error When Cube is Processed (274767)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
This article was previously published under Q274767
BUG #: 6221 (Plato7x)

SYMPTOMS

If the All Member caption for a private dimension in a processed cube changes and the cube is reprocessed from the Storage Design Wizard, the reprocess fails with an error message, which indicates that a member with the new All Member caption name cannot be found. The error message that occurs is:
OLAP Server Error: Processing error [Object does not exist] 'new All member caption' ; Time:

CAUSE

The Storage Design Wizard does not accurately check for changes in the structure of the private dimension.

WORKAROUND

To work around this problem, perform a Full Process of the cube after you exit the Storage Design Wizard.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8

For more information, contact your primary support provider.

This is not an issue in Microsoft SQL Server 2000 Analysis Services version 8.0.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a cube with at least one private dimension and process the cube.
  2. Open the Cube Editor.
  3. Click Properties, and then click Advanced properties.
  4. Select private dimension, and then change the All Caption property to Everything.
  5. Save your cube.
  6. Close the Cube Editor.
  7. Run the Storage Design Wizard, and then click Replace the existing aggregations.
  8. Click MOLAP and let it design aggregations.
  9. Click Process Now. Expected Results: Process successful.
    Actual Results: The process fails with this error message:
    OLAP Server Error: Processing error [Object does not exist] 'Everything'; Time:
  10. Close the Process window.
  11. Right-click the cube, and then select Process, Full process. Now the cube processes without an error message occurring.
Modification Type:MajorLast Reviewed:8/7/2006
Keywords:kbbug kbfix kbOLAP700SP3fix KB274767
©2004 Microsoft Corporation. All rights reserved.