Switch between identical cubes

• gerhard.taute

  Newbie

  Points: 2

  More actions

  November 27, 2013 at 12:56 am

  #149998

  Is there an automated way of switching between two identical cubes. I want to create TwinCube1(production) and Twincube2(Copy of Twincube1). Process Twincube2 during business hours, after completed rename twincube2 as Twincube1.

  Thanks

• larskandersen

  Ten Centuries

  Points: 1232

  More actions

  November 27, 2013 at 12:06 pm

  #1669551

  Here is a blog post that describing your switching scenario: http://kevinmintmier.wordpress.com/tag/xmla/

  If you use a scheduling agent, you would be able to execute the alter command after the processing command.