Yes, of course - with any upgrade its always a good idea to test absolutely everything anyway in case of changes.
Personally I actually tend to just keep an Excel document with details of which chores I have scheduled for which times anyway (very "untechy" I know.)
Like you have suggested I often also output start, end time and duration etc to a logging cube but it doesn't always make it readily apparent if you are having issue with 1 chore locking out another etc. I use this more for just having a quick 1 stop shop of did everything run as expected and without errors.
One idea I would like to see implemented in workspace is a chore administration screen; where you somehow have all of the chores displayed at the same time, so that you can try and avoid potential conflicts by making sure you put a good enough buffer between each.
The current chore scheduler in Workspace "does the job" as well as architect did but it would be nice to be able to view your chores as a whole.
If something like the above was implemented, just having it would be enough but the real "cherry on the cake" would be if it also automatically log the last duration or average duration and give you a little flag to tell you if 2 chores might overrun. Of course it would still be up the user to understand whether that would cause any locking issues or whether they are ok running in parallel.
Of course, all of the above is pretty easy to do manually anyway (such as keeping a track in Excel yourself) but it would be nice to have it built in to the default software.
------------------------------
Declan Rodger
------------------------------
Original Message:
Sent: Thu November 19, 2020 09:08 AM
From: STUART KING
Subject: Monitor Chores and process
Declan - I took a quick look at the TI code. Very neat trick! A word of caution regarding this approach. Although we don't intend to make any immediate changes to the chore file format, IBM does not guarantee the format of the model files will not change between versions. At some point in the future I expect us to move away from using files to represent objects in TM1 (cubes, dimension, Processes, Chores). Current thinking is that we could build these objects into a GIT repo so that we might have some build in version control.
My approach has always been to build some helper TI processes that update a stats cube of my own design. This can be done to track the start time and finish time of the chore or TI processes in the chore. You should be able to figure out the runtime and frequency from these details.
------------------------------
Stuart King
IBM Planning Analytics Offering Manager
Original Message:
Sent: Tue November 17, 2020 01:13 PM
From: Declan Rodger
Subject: Monitor Chores and process
Hi Vivien,
I had a quick play about with using a couple of TIs to loop the }Chore dimension and then go in to the data directory to check the details saved in the .cho files for each chore found.
Note that they are just basic but should give you an idea for a starting point if you want to build it out.
It creates a cube with the following measures:
- Active - 1 indicates the chore is active
- Multiple Commit Mode - 1 indicates it is multiple (0 for single)
- Start Date - String cell showing in YYYYMMDD format
- Start Time - String cell showing in HHMMSS
- Frequency - The frequency in seconds
This has just been thrown together with me "playing about" so please do validate that it actually gives the correct results before trusting them!
2 TIs:
- SYS_Create_Chore_Info_Master
- Creates/Clears cube
- Loops }Chores dim and calls the sub process for each chore
- SYS_Create_Chore_Info_Child
- Uses the .cho file as a datasource (should be using relative file path for your data directory)
- Utilises the Key/Index? in the cho file to work out what the info beside it is for
You can download them from the Github link here
Thanks,
Declan
------------------------------
Declan Rodger
Original Message:
Sent: Tue November 17, 2020 02:31 AM
From: Vivien
Subject: Monitor Chores and process
Hi Jim,
thank you, it's helping me a lot. I would like to keep code and data inside TM1.
Your code focus on process. Is there anything about chore ? We would to get information such as:
- which chore launch process
- chore frequency configured
- chore active
- ...
best regards,
------------------------------
Vivien
Original Message:
Sent: Mon November 16, 2020 06:27 PM
From: Jim Hanifin
Subject: Monitor Chores and process
Vivien,
This depends on what you are trying to do. If you are looking to track TurboIntegrator processes and user queries in real-time, IBM has developed a new tool called Planning Analytics Administration (PAA) to replace Ops Console and TM1Top. Planning Analytics will need to be at least version 2.0.5 and Planning Analytics Workspace (PAW) needs to be running. For more information you can use the link below:
https://blog.quebit.com/blog/quebit-blog-goodbye-tm1top-farewell-tm1-operations-console
And for IBM's product documentation:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_administer_servers.html
However, if you are trying to view process details after their execution, this can be performed within TurboIntegrator. Typically, this is done by creating a Process Stats cube and then updating TurboIntegrator processes with code to populate details within the cube. You can find more information in the link below:
https://quebit.com/askquebit/IBM/why-you-need-a-process-statistics-cube-in-planning-analytics/
Hopefully this helps!
------------------------------
Jim Hanifin
Implementation Manager & Cross Solutions Architect
QueBIT Consulting
Original Message:
Sent: Mon November 16, 2020 11:26 AM
From: Vivien
Subject: Monitor Chores and process
Hi team,
I would like to monitor chore and process.
I am able to developp a TM1py script to get Chore properties by using REST API.
But I would like to keep my code inside Turbo Integrator.
- Do you know if there is a way to find Chore properties from and/or do REST API calls from TI without using other tools ?
- Cognos® TM1® Operations Console and Performance Management Hub are Deprecated in v2.0.9.3 is there any other tools to do the job ?
Thank you
------------------------------
Vivien
------------------------------
#PlanningAnalyticswithWatson