TI process or other way to identify "WHERE USED" for a TI process ?

[donap]

My predecessor here created some very cool, "modularized" , generic TI processes that get used in many other TI processes...
Like all the BUILD_Dimension_xxx_  TI Process share a logging process called from the Epilog Tab.

Bethe there are MANY TI processes in our environment. I am thinking some of them may have been for testing, and are not used anymore.

But I want to make certain they are not called from another TI process.

Is there any way to get a "where used" of a TI process that would show all instances where it is called from ?

Thanks

[AJAYC]

Donap

The simple answer, given what you have posted, is "No".

I have a cube in my model which captures all sorts of data at runtime from all sorts of TI processes, some of them generic and some custom. I have made sure that every single one has a range of measures which are captured at runtime that then get loaded into a "sys_Process_History" cube. One of these measures is "TI_Called_From", which happens to be passed as a parameter to every single TI process.

Other things I catch are; the range of parameters passed, runtime statistics on how long each tab in the process took, rows loaded, who ran it, when did it start and how long did it take etc etc etc.

Unfortunately, since you have inherited your model, it is likely that all of your processes are missing this vital information on the "called from process".

What you could do is have a TEST model and copy into it the processes you believe are required and then check to see if it falls over. If it does, then you are missing a process, or two. Alternatively, go into every process, add the missing data capture so that it is written into your cube and monitor it over a month or two to see what really gets called and what never does.

I can't really recommend any other smart way I'm afraid :-(

HTH
Ajay

[donap]

Thanks -

I have started capturing a "WHORANIT" parameter -- it was already in most of the processes for capturing the User running it interactively to a Process_log cube...I just added a Parm to concat a calling TI process...
So, As I go forward, I may add fields to the Process_log cube and separate the info.

[Lerinks]

Guys, excuse me for my English.
If you can use Total Commander(or other FileManager), i know some reception.

Need open folder "\\tm1model\'name your model'\Data"
(in TC) Use keyboard shortcut 'Alt+F7', in window "search for" you can write some combination (*pro - for process,*RUX - for rule ,*dim - for dimension ,*cub - for cube), next in window "find text" write name of process what do you want find.

I hope it was useful for you.