Wednesday, January 05, 2011

TM1 TI process SQL preview killing

If your TI process datasource consists of a sql statement that takes a long time to run then it will become annoying when you want to make changes to that TI and the sql executes every time you open the TI process.

There is though a simple workaround.

At the end of your sql add the to your WHERE condition “1” =’?pCondition?’

 Then in your Prolog tab at the very start add a line  pCondition = '1';

 By having the sql where clause not being populated until run time (execution of the TI) it means your TI will now open without running the SQL statement