Chore Details

Post Reply
tomok
MVP
Posts: 2831
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
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: Chore Details

Post by gtonkin »

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
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: Chore Details

Post by gtonkin »

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
...
Control code 531 relates to the schedule-format dddhhmmss
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)
tomok
MVP
Posts: 2831
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

Post by tomok »

Thanks for the info.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
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: Chore Details

Post by gtonkin »

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.
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: Chore Details

Post by Wim Gielis »

gtonkin wrote: Thu Oct 19, 2017 6:27 pm 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.
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
tomok
MVP
Posts: 2831
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

Post by tomok »

Wim Gielis wrote: Thu Oct 19, 2017 10:05 pm
gtonkin wrote: Thu Oct 19, 2017 6:27 pm 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.
Guess what...

http://www.tm1forum.com/viewtopic.php?t=13373

Tom, can you run the processes and provide feedback please ? Thanks!
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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Chore Details

Post by macsir »

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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply