Stats by pool

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 2426
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Stats by pool

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

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 21 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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

Post Reply