Quick way to copy a Cube?

Post Reply
fleaster
Regular Participant
Posts: 167
Joined: Wed Mar 30, 2011 11:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: XL2010

Quick way to copy a Cube?

Post by fleaster »

Ok just a simple question...

I would like to make a "frozen" copy of a cube with all dimensions/data etc intact and make it available to users
e.g. GL cube => GL_OLD cube - the old cube would not be updated, but just available for reference purposes

Is there a quick way to do this, short of recreating everything using TI...?

Matt

P.S. I know the cube rules may be a bit problematic with feeders from other cubes etc, but am not so concerned about this part
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Quick way to copy a Cube?

Post by Martin Ryan »

If you just want a copy of the raw data then you can stop the server, copy the .cub file in the data directory and start it up again. The new cube will be there - but as you mention it'll be without rules or views.

If you want all the calculated data then there's no alternative but TI.

As an alternative to a whole new cube you could create a "snapshot" dimension in your main cube (or just use your version dimension) and copy the data into an element in there instead.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
fleaster
Regular Participant
Posts: 167
Joined: Wed Mar 30, 2011 11:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: XL2010

Re: Quick way to copy a Cube?

Post by fleaster »

Thanks for the info Martin, i suspected a file copy might have to do ...

...ok another dumb question - is there a way to rename a cube? :)
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Quick way to copy a Cube?

Post by qml »

Yes, just rename the copied file and restart the sever.
Kamil Arendt
fleaster
Regular Participant
Posts: 167
Joined: Wed Mar 30, 2011 11:57 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: XL2010

Re: Quick way to copy a Cube?

Post by fleaster »

Ok I copied GL.cub to GL_OLD.cub and restarted the server, but no joy - the copied cube does not show up in server explorer... is there an exta step I need to take to "register" the new cube...?

thanks!

Matt
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Quick way to copy a Cube?

Post by Martin Ryan »

Not if you're an administrator, it should just be there. If you're not logged in as an administrator then you might have to set security to show you the cube.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply