Stats by pool

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
Posts: 2792
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL
Excel Version: Microsoft 365
Location: Brussels, Belgium

Stats by pool

Post by Wim Gielis » Tue May 19, 2020 8:35 pm


I wrote a fairly avanced TI process to load the pool statistics into a cube, rather than generate 1,100+ text files.
(19.69 KiB) Downloaded 339 times
It uses the DebugUtility number 134 based on the information in this topic:

The pools themselves are not incorporated in the cube, in a really small TM1 model I counted over 20,000 such pools.
I guess that a simple loop over numbers and generating a text file with DebugUtility is more useful going forward.
If someone extends my TI process or finds an error, let me know.

Now that this TI process is there let’s try to see if we can get ‘information’ from the data.

Enjoy !
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 120 TM1 articles and a lot of custom code
Newest blog article: Documenting processes and rules

Post Reply