Print Page - Import data from Cognos 8 packages to TM1

Title: Import data from Cognos 8 packages to TM1
Post by: mizu on 03 Feb 2010 08:20:13 AM

Hello everyone,

does anybody know if it's possible to import data from Cognos 8 packages created by Framework Manager to TM1 cubes?

Could this be done by ODBO or ODBC connection in Turbo Integrator? How?

Thanks a lot.

Title: Re: Import data from Cognos 8 packages to TM1
Post by: MFGF on 03 Feb 2010 10:07:19 AM

Hi,

No - this functionality is not available in TM1. As an alternative, you could write a list report from the package using (say) C8 Report Studio, run and save the output as csv, then use the csv as a data source for TI. Not ideal, I know, but OK for a one-off. Plan B is to use ODBC to connect to the same data source(s) as FM and read the data directly from there.

MF.

Title: Re: Import data from Cognos 8 packages to TM1
Post by: mizu on 03 Feb 2010 12:28:24 PM

Thanks a lot for your reply.

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: mizu on 03 Feb 2010 08:20:13 AM