TM1 Forum • Is there any way to use PL/SQL Procedure in TM1 TI Process.

Page 1 of 1

Is there any way to use PL/SQL Procedure in TM1 TI Process.

Posted: Fri Jan 20, 2012 1:11 am

by ryan

I am obliged if any one could guide me the steps in using a PL/SQL in TI process, if possible.

Thanks in advance.

Re: Is there any way to use PL/SQL in TM1 TI Process.

Posted: Fri Jan 20, 2012 9:50 am

by David Usherwood

Read the manuals - specifically the TI Manual on importing from an ODBC source and the TI 'Tutorial'
Setup an ODBC environment for Oracle on the TM1 server and make sure you can connect and query
(Need to use a System DSN)
Create a TI, select ODBC, select DSN, write query
Deal with the data coming back to fit your requirement

HTH