Search found 3 matches

by KWS
Wed Aug 10, 2016 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Select Count statement in TM1
Replies: 12
Views: 8878

Re: SQL Select Count statement in TM1

Yeah, kinda figured that. I built a check process that gets the count, and if it returns a zero count, it throws an error. I put a call to that process at the top of the main process. If the check process fails, the main process fails too, before we get into the nuts and bolts. Thanks for the reply....
by KWS
Wed Aug 10, 2016 7:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Select Count statement in TM1
Replies: 12
Views: 8878

Re: SQL Select Count statement in TM1

Resurrecting an old thread. I need to get a count out of a database and put that result into a TI variable. I've got a monthly process that will zero out some intersections, pull new data from a database, and put the new data back into the zero'd out intersections. All that works fine. I've got a da...
by KWS
Thu Nov 18, 2010 11:33 pm
Forum: Useful code, tips and tricks
Topic: Using Dates And Times In TM1
Replies: 18
Views: 111307

Re: Using Dates And Times In TM1

I realize this is an old post, but I came across it looking for a similar problem. I've known about the single quote trick for writing dates to Excel for a while now and that has worked for me in Perspectives up until today. I have one workbook writing to a string element that, depending on how I se...