Reload Data from Filesystem

Post Reply
CoN73mP7
Posts: 37
Joined: Wed May 18, 2011 7:48 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2003
Location: Stuttgart, Germany
Contact:

Reload Data from Filesystem

Post by CoN73mP7 »

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
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: Reload Data from Filesystem

Post by tomok »

No, not without recyclng the service.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
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

Post by qml »

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
CoN73mP7
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

Post by CoN73mP7 »

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
bagovino
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

Post by bagovino »

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.
CoN73mP7
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

Post by CoN73mP7 »

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 :-(
Alan Kirk
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

Post by Alan Kirk »

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 :-(
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.)

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.
bagovino
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

Post by bagovino »

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.)
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.
lotsaram
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

Post by lotsaram »

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.)
Actually I just got stung by this (on my work Lenovo) but found the situation could be rescued by pagefwd or Alt+right arrow.
Post Reply