Chore Details
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Chore Details
Does anyone know where Chore details are stored? I know just about everything else is in a control cube somewhere but I can't find anything chore-related, except for the }Chores dimension. I've never had the need to look that stuff up before and now I've inherited a system full of chores and I'm trying to figure out the scheduling and what not and I don't want to have to turn off the scheduling and click through the buttons one by one to find out the schedule.
- gtonkin
- MVP
- Posts: 1211
- 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: Chore Details
Hi Tom, the schedule details are against a control code if you look in the .cho file-the frequency, hour, minute etc. are in one string-I can try unpack a bit later for you if you don’t find it-on my mobile at the moment
- gtonkin
- MVP
- Posts: 1211
- 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: Chore Details
Code: Select all
C:\TM1 Data\BBPS>type "User Group Extract.cho"
534,10
535,"User Group Extract"
530,20140425023148
537,0
531,001061218
532,1
...
in my example, run every 1 day , 6hours, 12 minutes and 18 seconds-(changed the details for purposes of posting otherwise you generally have lots of zeroes for realistic schedules)
Control Code 533 is for Active(1) / Inactive(0)
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Chore Details
Thanks for the info.
- gtonkin
- MVP
- Posts: 1211
- 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: Chore Details
Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.
-
- MVP
- Posts: 3128
- 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: Chore Details
Guess what...
http://www.tm1forum.com/viewtopic.php?t=13373
Tom, can you run the processes and provide feedback please ? Thanks!
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: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Chore Details
I'll give it a shot soon. Right now I don't have access to an 10.2.2 FP4 or later environment available to me.Wim Gielis wrote: ↑Thu Oct 19, 2017 10:05 pmGuess what...
http://www.tm1forum.com/viewtopic.php?t=13373
Tom, can you run the processes and provide feedback please ? Thanks!
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Chore Details
What I have done in the past is using Perl to extract chore details info from chore files into a summary file. Since Perl is good at regular expression, it is kind of easy to program based on that and in that way, it is not depending on any TM1 version.