Search found 23 matches

by PeteB
Fri Aug 16, 2013 3:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 5066

Re: TI SQL performance issue

Hi Nick and Steve, Thanks for your suggestions, but so far no luck. My main concern is why the same SQL code using the same ODBC connection returning the same data takes significantly longer in TM1 TI versus both Microsoft Query and Hyperion. In fact both Microsoft Query and Hyperion are too quick t...
by PeteB
Wed Aug 14, 2013 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 5066

Re: TI SQL performance issue

Hi Nick, Sorry, I should have said I had already tested the SQL both as a drill-through process and a standard process, just in case there was difference. As far as I can tell there is no difference between the drill-through process and a standard process from a TM1 perspective. Thanks for the SAL t...
by PeteB
Wed Aug 14, 2013 4:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 5066

TI SQL performance issue

I am having a performance problem running a SQL statement from TI. The exact same query pasted into Microsoft Query will return the 78 rows in under a second, while in TI it is taking over 2 hours to preview the results. TI is using the same ODBC connection as Microsoft Query on the same Windows ser...