FIX: Copy/Paste Cubes Fail Without Any Error Messages
This article was previously published under Q255135
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 4546 (Plato7x)
If you use the OLAP Manager to copy and paste a cube from one database to another, you may find that only the name of the cube is copied. When you try to edit the cube, you see this error message:
The 'CubeName' cube's data source,", is missing.
This error occurs only when your target database has a couple of hierarchy dimensions. For example, a hierarchy for a Time dimension would have two dimensions:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0For more information, contact your primary support provider.
After you apply OLAP Service Pack 2 (SP2), the OLAP Manager captures the Decision Support Objects (DSO) error string 'Invalid name' and displays the error in a message box.
addin Add in
Article ID: 255135 - Last Review: 02/28/2014 00:31:15 - Revision: 4.1
Microsoft SQL Server OLAP Services
- kbnosurvey kbarchive kbbug kbfix KB255135