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

Post Reply
ryan
Posts: 59
Joined: Thu May 26, 2011 5:04 am
OLAP Product: COGNOS
Version: 9.0
Excel Version: 2007

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

Post 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.
Last edited by ryan on Mon Jan 23, 2012 11:32 pm, edited 1 time in total.
Configuration Details
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 32 GB
using IBM Cognos Express Xcelerator (Version 10.1)
MS-Office Excel 2010 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5
Top
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

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

Post 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
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”