Stats by pool

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

Stats by pool

Post by Wim Gielis »

Hello,

I wrote a fairly avanced TI process to load the pool statistics into a cube, rather than generate 1,100+ text files.
WG_SYSTEM_Stats_pools.pro
(19.69 KiB) Downloaded 698 times
It uses the DebugUtility number 134 based on the information in this topic: https://www.tm1forum.com/viewtopic.php?f=3&t=15301

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply