TM1 Chore Schedule Information
-
- 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
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.
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]
-
- 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
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.
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]
- jim wood
- Site Admin
- Posts: 3952
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- gtonkin
- MVP
- Posts: 1203
- 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
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.
-
- 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
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.
-
- 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
*.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)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.
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 Chore Schedule Information
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:
http://tm1py.readthedocs.io/en/latest/a ... m1-objects
Extracts from the docs:
You need Python 3 of course.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)
-
- MVP
- Posts: 3123
- 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
Thanks for posting.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.
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
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
-
- MVP
- Posts: 3123
- 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
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
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
-
- 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
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 amThanks for posting.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.
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
- PavoGa
- MVP
- Posts: 618
- 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
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
And, Andy, how about those b-ball Vols?! SEC regular season champions.
Ty
Ty
Cleveland, TN
Cleveland, TN