Microsoft KB Archive/274767

= FIX: Change of Caption Property of a Private Dimension Returns Error When Cube is Processed =

Article ID: 274767

Article Last Modified on 8/7/2006

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



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.



Steps to Reproduce Behavior
 Create a cube with at least one private dimension and process the cube. Open the Cube Editor. Click Properties, and then click Advanced properties. Select private dimension, and then change the All Caption property to Everything. Save your cube.</li> Close the Cube Editor.</li> Run the Storage Design Wizard, and then click Replace the existing aggregations.</li> Click MOLAP and let it design aggregations.</li> 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:

</li> Close the Process window.</li> Right-click the cube, and then select Process, Full process. Now the cube processes without an error message occurring.</li></ol>

Keywords: kbbug kbfix kbolap700sp3fix KB274767

-

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

© Microsoft Corporation. All rights reserved.