turbo integrator process on event

Post Reply
nicola531
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

turbo integrator process on event

Post by nicola531 » Wed Apr 14, 2010 9:31 pm

Hello everyone,

I'm using TI processes, I would like to know if on a cell change is possible to run a TI process. Generally I would like to know if it is possible to run a process on a event.


Thanks in Advance for your answer,

Nicola

User avatar
Alan Kirk
Site Admin
Posts: 5928
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: turbo integrator process on event

Post by Alan Kirk » Wed Apr 14, 2010 10:02 pm

nicola531 wrote: I'm using TI processes, I would like to know if on a cell change is possible to run a TI process. Generally I would like to know if it is possible to run a process on a event.
In theory it's possible by using API calls on the Worksheet_Change event. In practice it's more problematic. First, because working with the API is a bear, though a future incarnation of the TM1 Tools add-in will contain a wrapper procedure which can just be called from your own code. However that's likely to be weeks away.

Second, and more significantly, when you make a change to a DBRW cell the Worksheet_Change event is triggered not once, but three times to allow the write-back feature to operate. If you enter into a cell which isn't a DBRW but which has DBRW cells on it, it may also be called multiple times but the number of times may vary. There are ways around that but they can potentially be as ugly as the API code is.
"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.

David Usherwood
Site Admin
Posts: 1359
Joined: Wed May 28, 2008 9:09 am

Re: turbo integrator process on event

Post by David Usherwood » Wed Apr 14, 2010 10:04 pm

Not directly - but you can set up a TI to run as a chore every x minutes and take some action (ie run another TI) if it detects a change in a cell's value. Watch for locking issues if you go that route.

User avatar
Alan Kirk
Site Admin
Posts: 5928
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: turbo integrator process on event

Post by Alan Kirk » Wed Apr 14, 2010 11:58 pm

David Usherwood wrote:Not directly - but you can set up a TI to run as a chore every x minutes and take some action (ie run another TI) if it detects a change in a cell's value. Watch for locking issues if you go that route.
I read it as an Excel cell, but yes, if it's a TM1 cell you're correct. The question of "on event" chores has been discussed as an enhancement request (http://forums.olapforums.com/viewtopic.php?f=19&t=1777) but I doubt it'll happen soon if at all.
"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.

Post Reply