COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: sgyazuddin on 02 Feb 2009 12:04:31 AM

Title: ETL Mapping in Cognos Reoport
Post by: sgyazuddin on 02 Feb 2009 12:04:31 AM
Hello All;

Does any one let me know how to take the ETL mapping( Database Package) in cognos framework manager such that user can run the data load from the cognos report.

Thx & Reg,
S.Gyazuddin.
Title: Re: ETL Mapping in Cognos Reoport
Post by: blom0344 on 02 Feb 2009 05:43:49 AM
There is no ETL used in framework manager. The package creates a model with whom Cognos creates an SQL. This is executed at runtime against the database. I do not think it is proper semantics to talk about 'loading' data as the resultset is only used to display report output (i.e. no new tables are populated..)