Dear all,
I need to write a little tool to copy TM1 processes (as well as dimensions, cubes, users etc) from one server to another. I think copying the .proc-file on the file system is not a very good solution since I have to restart the TM1 server that the process is available. Therefore I thought I can use the TM1 API (while I would prefer the Java API). Unfortunately the API does not support a function like "Copy Process". Is there any other solution to copy a process from one server to another?
Thanks for your help!
Patrick
Copy process with TM1 API
-
Patrick Meier
- Posts: 2
- Joined: Tue Oct 05, 2010 2:03 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 9.5.1
- Excel Version: Excel 2007
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Copy process with TM1 API
There is no API call, AFAIK, that will do a live copy of either processes or chores from one server to another and I also can't imagine any circumstance where I would want to do that where just plain copying the .pro and .cho files from one data directory to another wouldn't suffice. Replication can move everything EXCEPT processes and chores.
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Copy process with TM1 API
It can be done, but not easily. In essence you would need to recreate the processes by reading the process' code, variables etc from the source server and then creating the same things on the target server.Patrick Meier wrote: I need to write a little tool to copy TM1 processes (as well as dimensions, cubes, users etc) from one server to another. I think copying the .proc-file on the file system is not a very good solution since I have to restart the TM1 server that the process is available. Therefore I thought I can use the TM1 API (while I would prefer the Java API). Unfortunately the API does not support a function like "Copy Process". Is there any other solution to copy a process from one server to another?
But this will not be a "little" tool, and you'd need to put in a lot of time and effort to get it to work reliably.
Orrrrr.... you could pay someone who has already done that work for you. There is one commercial tool on the market which will do the kind of "hot promotion" that you're looking for. If your budget will stretch to it it may be worth looking at.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Copy process with TM1 API
A more current link to this product can be found at viziersoftware.com
It's more than a little tool these days.
(I do have an association with the company.)
It's more than a little tool these days.
(I do have an association with the company.)
-
Patrick Meier
- Posts: 2
- Joined: Tue Oct 05, 2010 2:03 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 9.5.1
- Excel Version: Excel 2007
Re: Copy process with TM1 API
Thanks for all your answers!
Can this tool be used to copy processes via command line? If yes, it could be a solution in our environment. The price is still around 1'000 USD?
Can this tool be used to copy processes via command line? If yes, it could be a solution in our environment. The price is still around 1'000 USD?