Cube File Copier
Posted: Thu Dec 11, 2014 11:44 am
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.
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.