TM1 Chore Schedule Information

Post Reply
tm1buddy
Posts: 5
Joined: Mon Dec 05, 2016 6:17 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Office 2013

TM1 Chore Schedule Information

Post 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.
[b][color=#FF0000]Rajesh[/color][/b]
tm1buddy
Posts: 5
Joined: Mon Dec 05, 2016 6:17 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: Office 2013

Re: TM1 Chore Schedule Information

Post 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.
[b][color=#FF0000]Rajesh[/color][/b]
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 Chore Schedule Information

Post by jim wood »

Moved to correct forum
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: TM1 Chore Schedule Information

Post 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.
andy_kendle
Posts: 2
Joined: Mon Oct 11, 2010 1:15 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: 2016

Re: TM1 Chore Schedule Information

Post 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.
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

Re: TM1 Chore Schedule Information

Post 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)
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Chore Schedule Information

Post 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.
Wim Gielis
MVP
Posts: 3103
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: TM1 Chore Schedule Information

Post 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 ;-)
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
Wim Gielis
MVP
Posts: 3103
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: TM1 Chore Schedule Information

Post 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 ;-)
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
andy_kendle
Posts: 2
Joined: Mon Oct 11, 2010 1:15 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: 2016

Re: TM1 Chore Schedule Information

Post 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 ;-)
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: TM1 Chore Schedule Information

Post 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
Ty
Cleveland, TN
Post Reply