TM1 Forum

I am currently undertaking a mass archiving project in an instance of TM1 that has had a series of different developers over its lifetime and as such has become a bit out of control and the exact opposite of anything that resembles 'best practice'.

Cubes, Dims and Rules I have a good handle on and am making good progress.

TI Processes on the other hand are proving a bit of an issue; the system has never really been documented so no-one knows which are and are not needed... I have been able to remove some that are obviously redundant but there are approximately 600!

Does anyone know of a way to ascertain when a process was last ran?

This obviously wont explain everything but it will be a pretty good starting point; I did consider deleting the lot and reinstating ones as people complain but apparently users don't like the sound of that for some reason.

I do not believe that such a property exists. Neither a property to check if a process is connected to another process.

600 is a lot of processes. There have to be at least that are doing the same task.

You'll probably have to trawl through the tm1server.log file, including any old copies (from memory they get saved as tm1server1.log, tm1server2.log and so on) looking for "process executed".

Probably a call for a bit of Python or similar.

Martin