Page 1 of 1

Cube creation and loading via script

Posted: Sat Jun 23, 2012 2:31 am
by mrnara
So I know how to create a basic Cube from scratch and load data into it using the TM1 Architect and Turbo Integrator.
I see some code segments that TI generates under the "Advanced" tab.

Is there some way/technique to incorporate these code segments into a complete script, so that I can re-create the cube and load date from the command-line?
I'd also like to version-control this script, so that I can go back to a previous version if necessary.

I feel more comfortable doing Global Search/Replace to rename things, add additional elements, etc. in code (in a text editor) than using the TI GUI each time.

Re: Cube creation and loading via script

Posted: Sat Jun 23, 2012 8:15 am
by Wim Gielis
First off, you should not recreate cubes from scratch. Initially, create your cube (most of the time manually, or using the CubeCreate function in TI).
But after that, all changes are done in the existing cube without destroying and recreating.

I think you use the TI wizard and are not so experienced in writing TI code.

You can use TM1RUNTI to execute an existing TI process from command line.
Use Google or look elsewhere on this forum for information - it has been discussed before. Or look at my personal website below.

The TI editor is the place where you will script (the Advanced tabs of the process), but if you want to copy/paste your code to a text editor:
you can do this. But in the end all code needs to be in its (correct) tab of the process.