Hello to all!
Has anyone run a Turbo Integrator process through a command line? If yes, could provide an example?
Regards,
Alessandro
Execute Process by command line
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Execute Process by command line
Google TM1RunTI or search the forum for it.
There have been a few posts on here and IBM provided a document showing how to use it that appears up near the top of a google search.
There have been a few posts on here and IBM provided a document showing how to use it that appears up near the top of a google search.
Declan Rodger
-
- Posts: 32
- Joined: Wed Nov 14, 2012 5:37 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007 STARDAND
Re: Execute Process by command line
declanr wrote:Google TM1RunTI or search the forum for it.
There have been a few posts on here and IBM provided a document showing how to use it that appears up near the top of a google search.
I have found the document. I do not understand how to apply. I do not know if I apply the syntax in a configuration file, or via cmd ... has no more explanatory tutorial.
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Execute Process by command line
Please let us know which part of the following paragraph you found difficult to understand and we will try to help.
tm1runti.pdf wrote:Parameters
Parameters can be either in a configuration file or passed on the command line.
Command line parameters take precedence over parameters that are in the
configuration file. This makes it possible to have persistent default parameters for
relatively static parameters (such as adminhost and server) and to supply just the
few parameters needed to either override the defaults or to provide values that are
not easily defaulted, such as the user name or the TurboIntegrator process name.
The parameters have a different format when passed on the command line. While
all parameters are passed in a "-parameter_name value" fashion, everything that is
passed as "parameter_name=value" is treated as a TurboIntegrator process
parameter.
There are four types of parameters:
* Command parameters
Used to specify the config file to use, which group of connection parameters to
use, or which TurboIntegrator process to run.
* Connection parameters
Used to specify the servername, username and other information needed to
connect to a TM1 server.
* Password parameters
Can either be a username and plaintext password or can be a filename
containing an encrypted password and associated keyfile used for decryption.
* TurboIntegrator parameters
Passed to the named TurboIntegrator.
Parameters specified on the command line must begin with dash (-) or slash (/).
The parameter value is separated from the parameter name by a space, and the
value can be specified as is or in quotes (if there are embedded spaces).
For example:
tm1runti –server MyTM1Server –username John –pwd "my secret"
ti_parm1=yes ti_parm2="my value"
Kamil Arendt
-
- Posts: 32
- Joined: Wed Nov 14, 2012 5:37 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007 STARDAND
Re: Execute Process by command line
qml wrote:Please let us know which part of the following paragraph you found difficult to understand and we will try to help.
tm1runti.pdf wrote:Parameters
Parameters can be either in a configuration file or passed on the command line.
Command line parameters take precedence over parameters that are in the
configuration file. This makes it possible to have persistent default parameters for
relatively static parameters (such as adminhost and server) and to supply just the
few parameters needed to either override the defaults or to provide values that are
not easily defaulted, such as the user name or the TurboIntegrator process name.
The parameters have a different format when passed on the command line. While
all parameters are passed in a "-parameter_name value" fashion, everything that is
passed as "parameter_name=value" is treated as a TurboIntegrator process
parameter.
There are four types of parameters:
* Command parameters
Used to specify the config file to use, which group of connection parameters to
use, or which TurboIntegrator process to run.
* Connection parameters
Used to specify the servername, username and other information needed to
connect to a TM1 server.
* Password parameters
Can either be a username and plaintext password or can be a filename
containing an encrypted password and associated keyfile used for decryption.
* TurboIntegrator parameters
Passed to the named TurboIntegrator.
Parameters specified on the command line must begin with dash (-) or slash (/).
The parameter value is separated from the parameter name by a space, and the
value can be specified as is or in quotes (if there are embedded spaces).
For example:
tm1runti –server MyTM1Server –username John –pwd "my secret"
ti_parm1=yes ti_parm2="my value"
My main question is:
- As I start the procedure? Start with a file. Txt passes the parameters and saved in any specific directory?
- Parameters Step through a .bat file?
- The TM1RunTI has some interface so that I can pass these parameters?
My biggest difficulty is how to start the procedure.
Regards,
Alessandro
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Execute Process by command line
Where are you trying to run it from?
If you start a Windows command prompt then navigate to the TM1 BIN install directory you can see what the parameters are and get a command line working, then put the command into a .BAT or .CMD file. If you want to run it from TM1 then I would suggest getting the .CMD working and calling it using ExecuteCommand.
If you start a Windows command prompt then navigate to the TM1 BIN install directory you can see what the parameters are and get a command line working, then put the command into a .BAT or .CMD file. If you want to run it from TM1 then I would suggest getting the .CMD working and calling it using ExecuteCommand.
-
- Posts: 32
- Joined: Wed Nov 14, 2012 5:37 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007 STARDAND
Re: Execute Process by command line
David Usherwood wrote:Where are you trying to run it from?
If you start a Windows command prompt then navigate to the TM1 BIN install directory you can see what the parameters are and get a command line working, then put the command into a .BAT or .CMD file. If you want to run it from TM1 then I would suggest getting the .CMD working and calling it using ExecuteCommand.
I'm trying to run it through a file. Bat.
My demand is running a TM1 process through a file. Bat.
I'm not able to create the correct syntax through the documents made available by IBM.
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Execute Process by command line
Any chance of showing us your batch script? Have you tried running it manually (i.e. not from TI)? If yes, what are the results?
Kamil Arendt