Page 1 of 1
Automatic generation of dimensions and cubes without
Posted: Wed May 18, 2011 8:20 am
by CoN73mP7
Hi everyone,
i'm trying to automatically generate dimensions and cubes in Cognos TM1 by metadata described in our database. My goal is it, that when I launch a script, it deletes all old Cubes and Dimensions, sets them up new and pulls the data from files. Is this even possible with TM1? I've looked at the .dim and .cub files in the TM1 directories, but they are all kind of encoded so that I see no possibility to just let my script generate those files. Is there a possibility to do this by using the Java-Api or do I have to generate Process-Files (Files wich are used by TM1 to store processes) and get them somehow startet without using the Frontend of the Turbo-Integrator.
Looking forward to any suggestions
Greetings
Alexander
Re: Automatic generation of dimensions and cubes without
Posted: Wed May 18, 2011 9:39 am
by Michel Zijlema
Hi Alexander,
There is a set of functions available in TI that can be used to delete/create dimensions, cubes and create hierarchies.
See f.i. the
TI Functions section in the on-line help.
Michel
Re: Automatic generation of dimensions and cubes without
Posted: Wed May 18, 2011 10:03 am
by Alan Kirk
CoN73mP7 wrote:
i'm trying to automatically generate dimensions and cubes in Cognos TM1 by metadata described in our database. My goal is it, that when I launch a script, it deletes all old Cubes and Dimensions, sets them up new and pulls the data from files. Is this even possible with TM1? I've looked at the .dim and .cub files in the TM1 directories, but they are all kind of encoded so that I see no possibility to just let my script generate those files. Is there a possibility to do this by using the Java-Api or do I have to generate Process-Files (Files wich are used by TM1 to store processes) and get them somehow startet without using the Frontend of the Turbo-Integrator.
Michel has pointed you in the right direction for the relevant TurboIntegrator functions, but I do suggest that you reconsider your approach. Completely destroying all of your cubes and dimensions and rebuilding them from scratch would
usually be time-consuming, a maintenance headache since you'd have to completely script the creation process, and in many cases unnecessary. Usually a combination of updating the dimensions to reflect the current metadata structure and zeroing out and re-uploading only that area of the cube that's likely to have changed will be a far more efficient approach. It will save time and processor load both on the TM1 side, and on the source system side.
Re: Automatic generation of dimensions and cubes without
Posted: Thu May 19, 2011 1:00 pm
by CoN73mP7
Michel Zijlema wrote:Hi Alexander,
There is a set of functions available in TI that can be used to delete/create dimensions, cubes and create hierarchies.
See f.i. the
TI Functions section in the on-line help.
Michel
Thanks for your help, thats exactly what I'm looking for.
Now, when I've created my Script, how do I execute it. Is it necessary to copy my script in a process-file generated by TurboIntegrator at some place like:
#****Begin: Generated Statements***
Here?!?
#****End: Generated Statements****
Or can I execute only my Script somehow, because I realy don't understand what all those lines at the beginning of a process-File are doing:
Code: Select all
601,100
562,"CHARACTERDELIMITED"
586,"C:\import.csv"
585,"C:\import.csv"
564,
565,"o_vTy0Rf]ac9\W2aDmnb1_63^@4Ja<j^Yg?8W2VZ0DMilkYBt<`6l?o9<R\z?3MRBkQ><sDqJxo7=faL5Z\9`4k0B7a1:TdLhtZ\ILMe`7^DJFiKlAV:mxSrB5mpQ6YKQo][Lib?[?LvkhO4RcBje^3X?rTphdG3M=72mctGje^gl9bfbiB7>FnzU5EhEcHrLe@QW[`U"
559,1
...
Alex
Re: Automatic generation of dimensions and cubes without
Posted: Thu May 19, 2011 1:35 pm
by tomok
CoN73mP7 wrote:Now, when I've created my Script, how do I execute it.
The code you have pasted is NOT a script that you can call from a command line. It is the actual object file that TM1 stores to disk for backup purposes. It's just a coincidence that it happens to be in text. They could have just as easily stored it in binary format. You execute a TI process by either making it part of a scheduled chore, which can be set up in the GUI, or you execute it in a one-off manner, which can done by 1) via the GUI, 2) calling it from a TM1 action button in an Excel or Web Sheet, or 3) via the TM1 API.