Ti Response Time on SQL

[camhale]

Hi,

We are a lengthy SQL statement in a Ti and it is taking quite some time to load the TI editor. Is there a switch on the cfg file that we can stop the query from running on opening? The reason being that we want to edit the code in the advanced tabs.

server is 64 bit
tm1 9.1 sp4

response time is same via client and server

[kpk]

Hi,

We are a lengthy SQL statement in a Ti and it is taking quite some time to load the TI editor. Is there a switch on the cfg file that we can stop the query from running on opening? The reason being that we want to edit the code in the advanced tabs.

As far as I know there is no such a cfg parameter.

One possible workaround:
If you change the ODBC definition on your PC to a wrong source then you get an error message about it soon after the double click on the process.
Then you can edit and save the TI process.

Do not forget to change the ODBC connection back at the end:) On the other hand TM1 will use the ODBC on the server side so you can leave it wrong at the developer PC.

Regards,
Peter

[Alan Kirk]

Hi,

We are a lengthy SQL statement in a Ti and it is taking quite some time to load the TI editor. Is there a switch on the cfg file that we can stop the query from running on opening? The reason being that we want to edit the code in the advanced tabs.

server is 64 bit
tm1 9.1 sp4

response time is same via client and server

That's why they put the "F" in F.A.Q. (http://forums.olapforums.com/viewtopic.php?f=3&t=1332)

Under "TurboIntegrator", see the heading "ODBC Data Source; Suppressing the Preview Display".

[camhale]

thanks