TM1 Forum

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

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.

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.

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.