Inspecting TM1 processes and chores

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

Inspecting TM1 processes and chores

Post by Wim Gielis » Sun Jun 18, 2017 3:09 pm


Here is a separate topic about how we can list properties of processes and chores.
The Main process can be used to execute the 2 subprocesses.
You can set up a cube (starting with }TECH_ so show the control objects when the processes have run),
or you can clean up the cube and its dimensions.
The output is large and varied, so have a go and see if it can help you when working with TM1.
The processes inspect the *.pro and *.cho files, respectively.

Original post: ... 7a4#p65723

Below you will find the latest versions of the processes. TM1 is needed to run the processes as-is.

Any questions / remarks / errors / improvements: let me know.
Certainly the process to analyse chores is new, all input is welcome.
This work consists of almost 2,000 lines of coding, excluding comments and whitespace.
(70.01 KiB) Downloaded 25 times
(43.47 KiB) Downloaded 25 times
(12.83 KiB) Downloaded 20 times
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Post Reply