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