Cube creation and loading via script

Post Reply
User avatar
mrnara
Posts: 9
Joined: Fri Jun 22, 2012 1:59 am
OLAP Product: TM1
Version: 10.1
Excel Version: 14.0 [Office 2010]
Location: California, USA

Cube creation and loading via script

Post 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.
Last edited by mrnara on Mon Jun 25, 2012 10:23 pm, edited 1 time in total.
Wim Gielis
MVP
Posts: 3241
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 creation and loading via script

Post 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.
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
Post Reply