Inspecting TM1 processes and chores

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

Inspecting TM1 processes and chores

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

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 88 times
TECH_TM1Documenter_ProcessInfo.pro
(43.47 KiB) Downloaded 79 times
TECH_TM1Documenter_ChoreInfo.pro
(12.83 KiB) Downloaded 64 times
Best regards,

Wim Gielis

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

User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Inspecting TM1 processes and chores

Post by gtonkin » Fri Jul 28, 2017 5:48 am

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: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Inspecting TM1 processes and chores

Post by Wim Gielis » Fri Jul 28, 2017 5:26 pm

Thank you George !
Best regards,

Wim Gielis

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

Drg
Posts: 62
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 » Tue Aug 08, 2017 7:05 am

awesome, gret job.

Wim Gielis
MVP
Posts: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Inspecting TM1 processes and chores

Post by Wim Gielis » Fri Oct 20, 2017 3:12 am

Drg wrote:
Tue Aug 08, 2017 7:05 am
awesome, gret job.
Thank you !
Best regards,

Wim Gielis

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

Post Reply