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.
Inspecting TM1 processes and chores
-
- 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:
Inspecting TM1 processes and chores
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
- gtonkin
- MVP
- Posts: 1254
- 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
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.
Extremely useful for when you inherit a pre-existing system!
Well done.
-
- 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:
Re: Inspecting TM1 processes and chores
Thank you George !
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
-
- Regular Participant
- Posts: 159
- 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
awesome, gret job.
-
- 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:
Re: Inspecting TM1 processes and chores
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