graphing TM1 data flow
Attached is the new version of a little parser in perl (free) that will create a text file for graphviz (free too) out of your .pro and .rux files and then generate a graph of the data flow in your TM1 server...
(the image has been cropped and scaled down for display, the original image is actually readable)
legend
ellipses = cubes, rectangles = processes
red = cellget, blue = cellput, green = inter-cube rule
Procedure to follow:
1. install perl and graphviz
2. put the genflow perl script in any folder, make sure it has the .pl extension (not txt)
3. doubleclick on it
4. Enter the path to your TM1 Data folder such as: \\servername\datafolder where \\servername\datafolder is the full file path to your TM1 data folder
5. Hit return and wait until the window disappears
This creates 2 files: "flow.dot" and "flow.gif" in the same folder as the perl script
6. Open "flow.gif" in any browser or picture editor
Changelog
1.3:
.CellPut parsing fix
.cubes/processes names displayed 'as is'
1.4:
.display import view names along the edges
.display zeroout views
.sources differentiated by shape
This is still quite experimental but this could become useful to view at a glance high-level interactions between your cubes.
| 
| 
| 
| 
| 
| 
| 
| 
| Attachment | Size |
|---|---|
| genflow.pl | 3.76 KB |
| genflow1.1.pl | 4.26 KB |
| genflow1.2.pl | 4.85 KB |
| genflow1.3.pl | 5.44 KB |
| genflow1.4.pl | 6.59 KB |
features to come
further development to come soon:
*flag in red cubes with conditional feeders (will be useful to see in a blink if you can use the faster multithreading load in TM1 9.1 with your cubes/rules)
*attributes graph
*limit graph display to the root of a cube, that will make it clearer to see which objects are needed to feed a given cube. the current script may lead to complex graphs that are hard to read on large systems.