Article ID: 255135 - View products that this article applies to.
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:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
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.
Contact us for more help
Connect with Answer Desk for expert help.