COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: babu babu on 08 Feb 2011 12:54:04 PM

Title: Cognos Package as datasource in 8.1
Post by: babu babu on 08 Feb 2011 12:54:04 PM
Hi,

Previously i have worked on cognos8.4 and there i can ceate transformer model by using cognos framework manager package but right now i moved to cognos8.1 but i am not able to see the cognos package as data source connection.Please can you suggest regarding this.

Thanks!
Babu.
Title: Re: Cognos Package as datasource in 8.1
Post by: MFGF on 09 Feb 2011 06:50:46 AM
Hi,

FM packages were only added as valid Transformer data sources at the 8.3 release.

As I see it, your limited options in 8.1 are both achieved through externalising query subjects, either as csv files or as IQD files.

In FM, create a new query subject containing the data you wish to include in your Transformer data source.  In the properties of the query subject, set the Externalise method property to either csv or IQD.

Define a new package containing the query subject, then begin the publish process.  As you publish, check the option to create externalised query subjects - this will then force FM to build either a csv or IQD which you can then pick up and use in Transformer as a data source.

Regards,

MF.
Title: Re: Cognos Package as datasource in 8.1
Post by: babu babu on 09 Feb 2011 12:00:10 PM
THANKS MF