TM1s Command Line

[TM1Newbie]

Hello

Trying to find some information on how to run TM1S.EXE (not TM1SD.EXE) from the command line. I don't have TM1SD.EXE otherwise I would install a local service to try and achieve what I want to do.

Basically what I want to so is start the local server version of TM1 (this is on my PC - not the network), allow it to run process/chores and then close this TM1 server from a batch file set to a scheduled task. I'm developing a small personal cube away from the corporate area. I've got the dimensions sorted, the cube built and a functioning ETL process but no way to start and stop the local server on demand (e.g. 4:00am to 4:30am)

I don't want to have to run TM1 all day everyday to simply load data on a schedule.

I've got close with:
C:\Program Files\Cognos\TM1\bin>tm1s.exe -z "C:\Program Files\Cognos\TM1\Custom\TM1Data\PData\" -d "C:\Program Files\Cognos\TM1\Custom\TM1
Data\PData\" -v bowntm101 -s 5000 -n local

but it asks for username/password to login (though there is nothing set). Can I pass a username from command line (admin).

No idea how to stop TM1S.exe from the command line.

Any help?

Thanks

Sam

[David Usherwood]

I'd say you are trying to make your life unnecessarily complicated by doing something the tools you have aren't built to do. Be careful, too, that you comply with your IBM license terms.
Having said that, there may be a way. You can run a TM1 foreground server up more or less as you described though I just use
tm1s.exe -z <config file>
and do the rest in that file.
To do the processing you want, create a TI process and put it in a timed chore.
To shutdown the server, use the (rarely used) DownTime parameter in your config file. It doesn't work on a service which is why it's rarely used.
But I would suggest you do a proper job with tm1sd.exe.

[TM1Newbie]

Thanks.

This is a bit of skunkworks project on a local PC.

[tomok]

This is a bit of skunkworks project on a local PC.

Which means you are violating your license agreement.