Hi,
is there any way, to tell the TM1 Server to reload the Data from the Filesystem with a TI Process or a API call.
I have made changes in the TM1 Server files and want the server to load them while running. At the moment it just works when restarting the Server :-/
Best Regards
Alex
Reload Data from Filesystem
-
- 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: Reload Data from Filesystem
No, not without recyclng the service.
- qml
- MVP
- Posts: 1096
- 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: Reload Data from Filesystem
Generally it's not possible, however... I've never tried this... but what if you unload a cube, replace the *.cub file and then load it back? Will the server be able to pick up the updated cube? Just a stab in the dark... Will test it later.
Kamil Arendt
-
- Posts: 37
- Joined: Wed May 18, 2011 7:48 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
- Location: Stuttgart, Germany
- Contact:
Re: Reload Data from Filesystem
I think that a cube should be possible because of its loadFile() Function in the API.
My problem however is, that I want to load a process file wich i have created manually
My problem however is, that I want to load a process file wich i have created manually
-
- Posts: 26
- Joined: Fri Oct 09, 2009 5:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Reload Data from Filesystem
You can create a process through the API and register it (or update an existing one). However, it isn't trivial.
First you create the empty process (TM1ProcessCreateEmpty), then there are about 30 or so properties for the process that you will have to set values for, then check the process (TM1ProcessCheck), and then you register it (TM1ObjectRegister) or update the existing one (TM1ProcessUpdate).
You can get a handle to an already existing process and look at each property to determine the value type and the actual value stored in it. Most of them aren't documented though.
First you create the empty process (TM1ProcessCreateEmpty), then there are about 30 or so properties for the process that you will have to set values for, then check the process (TM1ProcessCheck), and then you register it (TM1ObjectRegister) or update the existing one (TM1ProcessUpdate).
You can get a handle to an already existing process and look at each property to determine the value type and the actual value stored in it. Most of them aren't documented though.
-
- Posts: 37
- Joined: Wed May 18, 2011 7:48 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
- Location: Stuttgart, Germany
- Contact:
Re: Reload Data from Filesystem
That's not what I'm looking for. I have created a noew .pro file and I want to integrate it while the server is running. So far I just manage to integrate the Process by restarting the server.
But it seems like there is no way to do it
But it seems like there is no way to do it

-
- Site Admin
- Posts: 6647
- 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: Reload Data from Filesystem
Bagovino has already pointed you to the only way. As you've doubtless discovered, replacing a TI .pro file with another one does not cause the new process to be used. This implies that the .pro files are read at startup and updated when one is modified through the GUI and saved. The consequence of that is that you can only modify the files by changing them in memory via tha APU and saving them. I started on just such a project a few months ago but ran into a problem with either the variables or the parameters and it hasn't been enough of a priority for me to pursue it. (IBM support were less than useful with this too.)CoN73mP7 wrote:That's not what I'm looking for. I have created a noew .pro file and I want to integrate it while the server is running. So far I just manage to integrate the Process by restarting the server.
But it seems like there is no way to do it
However someone has pursued it and has created the Vizier utility which allows hot promotion of objects to be done. From what I hear they probably ran into some of the same problems that I did. (Some users have told me that you still need to open and re-save some processes before they'll work.) If your pockets will stretch to it, it may be an option.
(And I'd like to blow a special raspberry to the idiot who designed the Lenovo (hey, it's a work computer; I'd never buy one on my own dime) T420 keyboard. The one that has a backpage key directly over the top of the back arrow key. Meaning that if you're composing a message amd only just slightly miss the back arrow key... Another fine example of designers who don't actually use a system being turned lose in designing one.)
"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.
-
- Posts: 26
- Joined: Fri Oct 09, 2009 5:54 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Reload Data from Filesystem
Thread derail here, but what issue did you run into? I've been working on something recently and spent quite of bit of time figuring out how process variables are stored, so maybe I can help you.I started on just such a project a few months ago but ran into a problem with either the variables or the parameters and it hasn't been enough of a priority for me to pursue it. (IBM support were less than useful with this too.)
-
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Reload Data from Filesystem
Actually I just got stung by this (on my work Lenovo) but found the situation could be rescued by pagefwd or Alt+right arrow.Alan Kirk wrote:(And I'd like to blow a special raspberry to the idiot who designed the Lenovo (hey, it's a work computer; I'd never buy one on my own dime) T420 keyboard. The one that has a backpage key directly over the top of the back arrow key. Meaning that if you're composing a message amd only just slightly miss the back arrow key... Another fine example of designers who don't actually use a system being turned lose in designing one.)