TM1 Forum

Hi

I have problem, i'm bulding import from odbc (mssql - query). This process will be started by another process, which will provide a parameter to the sub-processes.
Parameter should be used in sql query after "where", for example select * from locations where location_code = parameter.
How to do it? in advanced tab, i don't see sql statement, so i can't put my parameter

P.S Sorry for my english

There were only about 2841 threads on that subject.

Two options:

1) You can include any variable reference directly in the query box, enclosing it in question marks, e.g. 'where location code = ?pParameter?'.

2) You can construct the entire query in Prolog and replace whatever you have in the query box with the constructed query string at runtime. The variable you need is DatasourceQuery. Also check out the other TI Local Variables, they can be extremely useful.

Niezamaco.

qml wrote:There were only about 2841 threads on that subject.
Niezamaco.

Sorry , and thank You
"Nie ma za co"

Motyl wrote:Sorry , and thank You
"Nie ma za co"

Oj tam, oj tam.