Chore Details

Post Reply
User avatar
tomok
MVP
Posts: 2349
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 » Thu Oct 19, 2017 2:56 pm

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: 521
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Chore Details

Post by gtonkin » Thu Oct 19, 2017 4:00 pm

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: 521
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Chore Details

Post by gtonkin » Thu Oct 19, 2017 4:56 pm

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)

User avatar
tomok
MVP
Posts: 2349
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 » Thu Oct 19, 2017 6:10 pm

Thanks for the info.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

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

Re: Chore Details

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

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

Re: Chore Details

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

User avatar
tomok
MVP
Posts: 2349
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 » Fri Oct 20, 2017 12:07 pm

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
Community Contributor
Posts: 447
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

Re: Chore Details

Post by macsir » Wed Oct 25, 2017 4:51 am

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