Page 1 of 1
TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 8:59 am
by tm1buddy
Hi Friends,
I am looking for Chore schedule information. Can some one tell me, does this information gets stored in any control cube or we have to de-activate the chore to know the schedule information. Thanks.
Re: TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 10:47 am
by tm1buddy
We can check chore active status and schedule in TM1 web prior to 10.2 version.
Currently my TM1 version is 10.2.2, I don't see any direct option where I can check these details with out deactivating the chore.
Let me know if there any way to figure it out.
Re: TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 12:24 pm
by jim wood
Moved to correct forum
Re: TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 1:12 pm
by gtonkin
Have a look
here - Wim has done a lot of work around this, alternatively, look into the CHO file itself. There are some posts on interpreting the CHO file.
Re: TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 2:41 pm
by andy_kendle
At least in 10.2.2 FP4 there is a cube called }StatsByChore that has some good stuff in it. You have to do the crazy serial date conversion math but it will give you the up coming schedule and last completion time.
Re: TM1 Chore Schedule Information
Posted: Thu Feb 22, 2018 4:30 pm
by tm123
tm1buddy wrote: ↑Thu Feb 22, 2018 10:47 am
We can check chore active status and schedule in TM1 web prior to 10.2 version.
Currently my TM1 version is 10.2.2, I don't see any direct option where I can check these details with out deactivating the chore.
Let me know if there any way to figure it out.
*.cho files are text files and it's easy to write a TI to Read them and pull the chore attributes and store them in a 2-dimensional cube (one of dimensions being }Chores)
Re: TM1 Chore Schedule Information
Posted: Fri Feb 23, 2018 11:13 am
by David Usherwood
Marius Wirtz' TM1py has some sample code which appears to address what you want:
http://tm1py.readthedocs.io/en/latest/a ... m1-objects
Extracts from the docs:
class TM1py.ChoreService(rest)
Service to handle Object Updates for TM1 Chores
activate(chore_name)
create(chore)
create_task(chore_name, chore_task)
deactivate(chore_name)
delete(chore_name)
execute_chore(name_chore)
get(chore_name)
get_all()
get_task(chore_name, step)
set_local_start_time(chore_name, date_time)
update(chore)
update_task(chore_name, chore_task)
You need Python 3 of course.
Re: TM1 Chore Schedule Information
Posted: Sat Feb 24, 2018 11:44 am
by Wim Gielis
andy_kendle wrote: ↑Thu Feb 22, 2018 2:41 pm
At least in 10.2.2 FP4 there is a cube called }StatsByChore that has some good stuff in it. You have to do the crazy serial date conversion math but it will give you the up coming schedule and last completion time.
Thanks for posting.
A requirement is that the }StatsByChore cube is filled in - e.g. bu turning on the Performance Monitor. This is not by default so I would be cautious when relying on that cube for automated processes. For an ad hoc analysis and you turn on the Performance Monitor, it can be good.
What would we be the crazy serial date conversions ?
I did a test by dividing by 60, again by 60, then 24 to get days, adding 21916, but then I got stuck
Re: TM1 Chore Schedule Information
Posted: Sat Feb 24, 2018 11:46 am
by Wim Gielis
tm123 wrote: ↑Thu Feb 22, 2018 4:30 pm*.cho files are text files and it's easy to write a TI to Read them and pull the chore attributes and store them in a 2-dimensional cube (one of dimensions being }Chores)
That's indeed the approach taken in the link that George posted to a kind of documenter tool by myself.
It has a custom dimension to store the chores (instead of }Chores) but it will not be difficult to change it if wanted - mind you, it's a lot of code to go through
Re: TM1 Chore Schedule Information
Posted: Mon Feb 26, 2018 6:03 pm
by andy_kendle
Here is what I've gleamed from the great Alan Kirk's post. (INT(NextActivationTime/86400)+21916+(-5/24)). The -5 at the end is to convert GMT to local time. I did forget to mention that you have to have Performance Monitoring turned on to get the }Stats cubes.
Wim Gielis wrote: ↑Sat Feb 24, 2018 11:44 am
andy_kendle wrote: ↑Thu Feb 22, 2018 2:41 pm
At least in 10.2.2 FP4 there is a cube called }StatsByChore that has some good stuff in it. You have to do the crazy serial date conversion math but it will give you the up coming schedule and last completion time.
Thanks for posting.
A requirement is that the }StatsByChore cube is filled in - e.g. bu turning on the Performance Monitor. This is not by default so I would be cautious when relying on that cube for automated processes. For an ad hoc analysis and you turn on the Performance Monitor, it can be good.
What would we be the crazy serial date conversions ?
I did a test by dividing by 60, again by 60, then 24 to get days, adding 21916, but then I got stuck
Re: TM1 Chore Schedule Information
Posted: Tue Mar 06, 2018 9:10 pm
by PavoGa
Make sure you turn logging off in the }Stats cubes or get of lot of useless log files...
And, Andy, how about those b-ball Vols?! SEC regular season champions.
Ty