Search found 705 matches

by rmackenzie
Mon Aug 25, 2008 12:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Loaded and Ready
Replies: 5
Views: 4805

Re: Server Loaded and Ready

Is there some kind of flag or trigger in TM1 or in Windows that I can leverage to send an email when the server is loaded and ready? Unfortunately, the short answer is no. I think you'd have to monitor the % processor usage of either the tm1s.exe or tm1sd.exe process and see when it dropped to zero...
by rmackenzie
Sat Jun 21, 2008 12:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Extract with TM1 API
Replies: 23
Views: 16342

Re: View Extract with TM1 API

Well, it seems like a good nights sleep will help any API problem...

Code: Select all

Do
    hLines = TM1ViewExtractGetNext(pPool, hExtract)
    ' do stuff with hLines
Loop Until hLines = 0
by rmackenzie
Fri Jun 20, 2008 7:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Extract with TM1 API
Replies: 23
Views: 16342

Re: View Extract with TM1 API

Code attached .... Option Explicit Dim hUser As Long Dim pPool As Long Dim hServer As Long Sub Test() Dim hCube As Long Dim hView As Long Dim hExtract As Long Dim hLines As Long Call Login hCube = TM1ObjectListHandleByNameGet(pPool, hServer, TM1ServerCubes, TM1ValString(pPool, "plan_BudgetPlan&...
by rmackenzie
Fri Jun 20, 2008 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Extract with TM1 API
Replies: 23
Views: 16342

View Extract with TM1 API

Hello all, Did anyone have any success generating a view extract via the TM1 API ? I'm stuck ! I've built a valid handle to the extract object of a pre-existing view, but I can't return any data from TM1ViewExtractGetNext - it only returns a TM1 index type variable (value is 1). I think the sticking...
by rmackenzie
Thu Jun 12, 2008 11:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI and ODBC Cleanup
Replies: 4
Views: 4450

Re: TI and ODBC Cleanup

Speculative suggestion - would running a TI with just an ODBCClose statement help at all ?