Launch a pocess from .bat

Post Reply
pobrouwers
Posts: 34
Joined: Mon Aug 11, 2008 7:37 pm
OLAP Product: IBM Cognos TM1
Version: 9.5.2
Excel Version: 2003-2007
Location: France

Launch a pocess from .bat

Post by pobrouwers »

Hello,
Is it possible to execute a .bat file to launch a process ?
What is the syntax for the .bat ?

Thx
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Launch a pocess from .bat

Post by paulsimon »

Yes it is. There was an executable to run a TIprocess posted in the last 5 months. Check the previous posts.

Regards


Paul Simon
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Launch a pocess from .bat

Post by Martin Ryan »

When somebody finds it, can you please put it in the Useful Code sticky post, crediting the author.

(I had a quick search but couldn't find it).

Cheers,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: Launch a pocess from .bat

Post by Mike Cowie »

Martin Ryan wrote:When somebody finds it, can you please put it in the Useful Code sticky post, crediting the author.

(I had a quick search but couldn't find it).

Cheers,
Martin
Hi Martin,

I'll dig it up since I had originally posted a couple of the EXEs there (one to run a chore, one to run a process) - I first want to update the EXEs to eliminate a couple minor bugs, so look out for it in the next day or so.

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: Launch a pocess from .bat

Post by Eric »

I found this site a year ago.
http://home.att.net/~gobruen/progs/dos_ ... batch.html

I think you want the call command.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: Launch a pocess from .bat

Post by Eric »

Always considered creating the .bat file with TI ASCIIOutput() and the executing the BAT file, but never had a practical reason to do it. If you come up with anything let me know.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
pobrouwers
Posts: 34
Joined: Mon Aug 11, 2008 7:37 pm
OLAP Product: IBM Cognos TM1
Version: 9.5.2
Excel Version: 2003-2007
Location: France

Re: Launch a pocess from .bat

Post by pobrouwers »

Hi everybody,
I've found those exe and it's works... Place those 2 .exe to the folder bin of TM1 c:/program files/cognos/tm1/bin (normally)
read instruction in the attached text files...
let me know if you have a problem
Attachments
TIExecute.zip
(87.81 KiB) Downloaded 338 times
TM1ChoreExecute.zip
(24.04 KiB) Downloaded 292 times
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: Launch a pocess from .bat

Post by Mike Cowie »

pobrouwers wrote:Hi everybody,
I've found those exe and it's works... Place those 2 .exe to the folder bin of TM1 c:/program files/cognos/tm1/bin (normally)
read instruction in the attached text files...
let me know if you have a problem
pobrouwers,

You may have missed my above post in this thread (this relates only to the TIExecute.zip that you attached) - I had very recently updated our 2 TI process/chore executables and posted them in the "Useful Code" thread on the Cognos TM1 forum. It shows up in a sticky post near the top of the list of forum threads. The copy you attached in your post is much older, so you may want to update your attachment to the more recent copy. If it helps, the following should get you to the more recent post:

http://forums.olapforums.com/viewtopic. ... =214#p1621

The older EXE versions generally work, but may crash, for example if you get the parameters wrong.

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
att
Posts: 5
Joined: Thu Jan 15, 2009 6:01 pm

Re: Launch a pocess from .bat

Post by att »

pobrouwers wrote:Hi everybody,
I've found those exe and it's works... Place those 2 .exe to the folder bin of TM1 c:/program files/cognos/tm1/bin (normally)
read instruction in the attached text files...
let me know if you have a problem
It does not work for me - can it be because we run TM1 on 64-bit server? We desperatly need to run TM1 processes from a script or command line...
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Launch a pocess from .bat

Post by Martin Erlmoser »

what exactly doesn't work? error message?
Post Reply