Search found 3 matches
- 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: 8930
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....
- 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: 8930
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...
- Thu Nov 18, 2010 11:33 pm
- Forum: Useful code, tips and tricks
- Topic: Using Dates And Times In TM1
- Replies: 18
- Views: 113293
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...