Inspecting TM1 processes and chores

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 3098
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:

Inspecting TM1 processes and chores

Post by Wim Gielis »

Hi,

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: http://www.tm1forum.com/viewtopic.php?f ... 7a4#p65723

Below you will find the latest versions of the processes. TM1 10.2.2.4 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.
TECH_TM1Documenter_Main.pro
(70.01 KiB) Downloaded 953 times
TECH_TM1Documenter_ProcessInfo.pro
(43.47 KiB) Downloaded 927 times
TECH_TM1Documenter_ChoreInfo.pro
(12.83 KiB) Downloaded 944 times
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
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Inspecting TM1 processes and chores

Post by gtonkin »

Thanks for all the effort Wim, I have downloaded and browsed through the code but not implemented to a dev environment yet. There are some hidden gems in here which users may take for granted or not even notice i.e. the control codes in processes, views and subsets-what they mean and what they can tell you when you interrogate them.

Extremely useful for when you inherit a pre-existing system!
Well done.
Wim Gielis
MVP
Posts: 3098
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:

Re: Inspecting TM1 processes and chores

Post by Wim Gielis »

Thank you George !
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
Drg
Regular Participant
Posts: 158
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: Inspecting TM1 processes and chores

Post by Drg »

awesome, gret job.
Wim Gielis
MVP
Posts: 3098
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:

Re: Inspecting TM1 processes and chores

Post by Wim Gielis »

Drg wrote: Tue Aug 08, 2017 7:05 am awesome, gret job.
Thank you !
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