Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rogerclerkwell
Yak Posting Veteran
85 Posts |
 Posted - 2015-04-17 : 08:57:31
|
| I have a live Cube called:Name: 'SSAS Cube LIVE'ID: 'SSAS Cube LIVE' And a test Cube called:Name 'SSAS Cube TEST' ID 'SSAS Cube TEST'.Both have been processed and Test has some new updates in.To put the test cube live what I usually do is:1. Do a Full process on 'SSAS Cube TEST' which can take 10 hours.2. Check it is OK then script it out to a SSMS window as XML.3. Delete the live cube 'SSAS Cube LIVE'4. In the scripted out xml from Test rename: Name 'SSAS Cube TEST' to Name 'SSAS Cube LIVE' ID 'SSAS Cube TEST' to ID: 'SSAS Cube LIVE'Create the cube and then do a full process again.Is there a way I can remove the LIVE Cube and Rename TEST to LIVE, keeping all the data in it and not having to do another full process which takes 10 hours?Thank you,Roger |
|
|
|
|
|
Set already processed Test Cube Live