Submitted by Raj Kumar Thippani, Tata Consultancy Services Limited
This technique covers how to to migrate/switch the Impromptu Query Definition (IQD) to Package Data Source in IBM Cognos Transformer without impacting the existing structure of the Model and the Data Source Query Definition.
This technique will help when decommissioning IQD Data Sources smoothly and can leverage the new and better features available with IBM Cognos Package Data Sources like Security, Prompts, Governors etc.,
The scope of this technique is limited to the following:
IBM Cognos Transformer Models are using IQD Data Sources.
IQD Data Sources are created manually in a Notepad and/or generated from IBM Cognos Framework Manager.
Tested in 10.2.1 successfully.
The IBM Cognos Transformer Model is using IQD Data Sources and would like to migrate/switch them to IBM Cognos Packages without making any changes to the structure (Dimensions & Measures) of the Model and to the Data Source Definition (Queries).
The implementation involves two steps first is to convert the IQDs into a Package using IBM Cognos Framework Manager and second is to replace IQD Data Sources with Package Data Source using the IBM Cognos Transformer Model.
Keep up-to-date with IBM Business Analytics Support :
Business Analytics Client Center | Business Analytics Supportlink | My Notifications | Twitter