Cube File Copier

Post Reply
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Cube File Copier

Post 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.
Attachments
TM1 Cube Copy.xlsm
(64.38 KiB) Downloaded 324 times
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Cube File Copier

Post by Wim Gielis »

Performance Modeler has an option to transfer files ;-)
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: Cube File Copier

Post 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.
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Cube File Copier

Post 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?
"the earth is but one country, and mankind its citizens" - Baha'u'llah
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: Cube File Copier

Post by iansdigby »

Aah, I see it. Looks really very interesting. Thank you for the heads-up Wim!
"the earth is but one country, and mankind its citizens" - Baha'u'llah
Post Reply