TM1 Forum

Does the complexity of a SQL statement affect how long a TI process takes to open? Is there some processing/validation that takes place during the initial opening of a TI process - i.e. does it validate the SQL or reparse the variables? For one of my TI processes, the initial Data Source window takes a long time to display and the Variables window also takes a long time. My other TI processes with simple SQL are fine.

I'm more or less sure that it _runs_ the SQL when you open the TI. Yes, it can be a real pain....

You might find this post useful: http://forums.olapforums.com/viewtopic. ... 668&p=8758

Martin

thank you for validating that I am not insane...

MarioRubbo wrote:Does the complexity of a SQL statement affect how long a TI process takes to open? Is there some processing/validation that takes place during the initial opening of a TI process - i.e. does it validate the SQL or reparse the variables? For one of my TI processes, the initial Data Source window takes a long time to display and the Variables window also takes a long time. My other TI processes with simple SQL are fine.

You might also find Vizier useful. It is a TM1 development environment that among other things includes a fully featured TI editor which only refreshes the SQL query when actually asked to do so!