dbTalk Databases Forums  

copying and pasting virtual cubes across databases

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss copying and pasting virtual cubes across databases in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
shri
 
Posts: n/a

Default copying and pasting virtual cubes across databases - 02-04-2004 , 03:33 PM






While copying and pasting virtual cubes across databases,
I get the error that the dimension already exists. I have
been able to copy and paste before, but have suddenly
started encountering it.

Thanks in Advance,
Shri

Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: copying and pasting virtual cubes across databases - 02-05-2004 , 01:19 AM






One cause could be that the structure of shared dimensions no longer
matches across the databases. From SQL BOL:

Quote:
The situation in which the target location already contains an object
with the same type and name, but a different structure, than a
supporting object. In this case, the paste operation fails, and no
objects are pasted. If objects already exist in the target location with
the same types, names, and structures as the supporting objects, the
paste of the main object is successful, but the supporting objects are
not pasted.
Quote:

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.