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 » Thu Feb 22, 2018 8:59 am

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 » 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.
[b][color=#FF0000]Rajesh[/color][/b]

User avatar
jim wood
Site Admin
Posts: 3617
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: TM1 Chore Schedule Information

Post by jim wood » Thu Feb 22, 2018 12:24 pm

Moved to correct forum
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

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

Re: TM1 Chore Schedule Information

Post by gtonkin » Thu Feb 22, 2018 1:12 pm

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: 10 1 1
Excel Version: 2010

Re: TM1 Chore Schedule Information

Post by andy_kendle » 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.

tm123
Posts: 113
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 » Thu Feb 22, 2018 4:30 pm

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: 1337
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Chore Schedule Information

Post by David Usherwood » Fri Feb 23, 2018 11:13 am

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

Re: TM1 Chore Schedule Information

Post by Wim Gielis » 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 ;-)
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

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

Re: TM1 Chore Schedule Information

Post by Wim Gielis » Sat Feb 24, 2018 11:46 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

andy_kendle
Posts: 2
Joined: Mon Oct 11, 2010 1:15 pm
OLAP Product: TM1
Version: 10 1 1
Excel Version: 2010

Re: TM1 Chore Schedule Information

Post by andy_kendle » Mon Feb 26, 2018 6:03 pm

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
Community Contributor
Posts: 264
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0
Excel Version: 2013
Location: Cleveland, Tennessee

Re: TM1 Chore Schedule Information

Post by PavoGa » Tue Mar 06, 2018 9:10 pm

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