In versions earlier than IBM Cognos 8.4, Transformer modelers accessed IBM Cognos BI content by either saving report outputs as comma separated values (CSV) files and using those CSV files as data sources in Transformer, or they could generate Impromptu Query Definition (IQD) files through Framework Manager.
In IBM Cognos 8.4 and higher, it is possible to use existing IBM Cognos BI packages and reports found in the IBM Cognos BI Content Store as a data source in IBM Cognos BI Transformer.
This additional feature has made building data sources reflecting a "single version of the truth" that much easier.
Any existing work done in Framework Manager modeling and exposed as a package, or any work done in IBM Cognos BI reports can be leveraged in Transformer, improving development time and ensuring that the data is all coming from the same underlying data source.
The following Proven Practices document provides guidelines on using IBM Cognos BI packages, whether they are relational, dimensionally modeled relational (DMR), or other OLAP sources such as another PowerCube, as well as IBM Cognos BI reports.
The guidelines described in this document were tested against IBM Cognos 8.4.x and IBM Cognos 10.1.
Click here to access the complete document.
To recieve a tweet every time a new Proven Practice document is published, follow @basupp.