Yak Posting Veteran
Posted - 04/16/2015 : 10:32:38
| 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?