COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: jps on 10 Sep 2009 07:11:47 AM

Title: Easy way to replace IQDs with QUerySubjects from FM packages
Post by: jps on 10 Sep 2009 07:11:47 AM
It takes hell lot of time to replace the IQDs with QuerySubjects from FM packages in the Transformer Model.
One has to map column by column manually even though the columns names are the same. This is tedious and time consuming job when upgrading TMs.
Does anyone has any trick to share to make this work simpler?

Thanks
JPS
Title: Re: Easy way to replace IQDs with QUerySubjects from FM packages
Post by: nybble on 08 Oct 2009 03:30:18 PM
Use 8.4, right-click on the IQD and do "Change Source Type". Change to a Package and pick an appropriate package.

You can then do "Auto Match" in the Modify Columns dialog to match up the columns to query items in the package.