Optimizing tm1 calculations (with pictures!)

Found myself using both of my new toy-scripts while stress-testing TM1:

  • I vizualize model data flow (way bigger than PlanSample in this picture, but node filtering helps).
  • Looking at such graph it’s easy to see model inputs (to left side), hardest calculations (these are the gordian knots) and reporting cubes.
  • So I just start pouring data input and reads in suspiciously looking model parts. And if they suffocate, it’s up to optimizing rules or turning rules into TI processes.
  • Redraw the picture and repeat until happy )

Very much like unjamming the creek. Spring )