Hello,
I wrote a fairly avanced TI process to load the pool statistics into a cube, rather than generate 1,100+ text files.
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 !
Stats by pool
-
- MVP
- Posts: 3222
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Stats by pool
Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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