Exploring TM1 - a Chartertech Company
Close this search box.

TM1 Archive TI Process

I asked Mafia Man the other day how I can take a backup on the fly of everything in TM1 so that if I make changes and stuff up, I can easily restore from my backup.

He gave me the following code that is to be inserted in the Prolog tab under Advanced in a Turbo Integrator process.  This creates a full archive of a TM1 Model (in this case CXMD) out to a zip file that will not be overwritten the next time the process is run as it is date time stamped in the file name.

#****Begin: Generated Statements***
#****End: Generated Statements****

### Saves all data from memory and sets up the variables

### Assumes that 7-zip is installed at the defined location
sExec = ‘C:Program Files7-Zip-A7za.exe’;

### Defines the target folder for the backup
sBackupDir = ‘C:TM1_Backups’;

### Defines the source folder for the model to be backed up
sDataDir = ‘C:Program FilesIBMCognos ExpressXceleratorCustomTM1DataCXMD’;

### Defines the name to be used for the backup zip file
sFileName = ‘Data ‘ | TIMST(NOW(), ‘Ymd h.i’, 1) | ‘.zip’;

### Defines the arguments to be used with the zip command
sArgs = ‘ a -tzip ‘;
sCommand = sExec | sArgs | ‘”‘ | sBackupDir | sFileName | ‘” “‘ | sDataDir | ‘*”‘;

### Outputs the variables to a text file for debugging
#ASCIIOUTPUT (‘c:debug-save.txt’, sexec, sbackupdir, sdatadir, sfilename, sargs, scommand);

### Creates the zip


  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In