Page 1 of 1

Cube File Copier

Posted: Thu Dec 11, 2014 11:44 am
by iansdigby
If anyone has found it laborious to copy a cube and its associated files from one folder to another (perhaps to migrate a cube from a test to a live environment) then the attached may help.

To use (tested in Excel 2007 but will probably work in XP too):
1. Log in to a TM1 server in Perspectives
2. Load the workbook.
3. Enter the TM1 server, and data folder to copy from, on the Control worksheet.
4. Click the 'Copy Cube Files' button
5. In the form, select a target path and a cube.
6. Click OK.
The VBA copies
the .cub, .rux, .dim files;
the }vues and }subs folders
all relevant }ElementAttributes_xxx .cub and .dim files
all relevant }ElementAttributes_xxx }vues and }subs folders.

USE AT YOUR OWN PERIL, No warranty given or implied, etc. etc.

Re: Cube File Copier

Posted: Thu Dec 11, 2014 11:47 am
by Wim Gielis
Performance Modeler has an option to transfer files ;-)

Re: Cube File Copier

Posted: Mon Dec 15, 2014 9:10 am
by TrevorGoss
Performance Modeler has an option to transfer files
It sure does, it is one of the best parts of performance modeler, you can upload objects such as cubes or processes from one model to the next with no down time, the object will just appear in the model of your choice.

Wim, when I create a transfer, I click on the "generate batch file" option and it tells me that it generated a batch file for the trasnfer but...it gives me a path to the file which does not exist, and when I run a search for the file it does not come up. Does this happen to you also?

Thanks.

Re: Cube File Copier

Posted: Mon Dec 15, 2014 4:49 pm
by iansdigby
We just got v10 and i found Perf modeller very slow so haven't investigated this one. Does it copy files across TM1 servers?

Re: Cube File Copier

Posted: Mon Dec 15, 2014 4:55 pm
by iansdigby
Aah, I see it. Looks really very interesting. Thank you for the heads-up Wim!