Setting Up Data Sources for UNIX and Linux Cubes
Your models must be able to read data sources from the server where Cognos® Transformer is running. Because Cognos Transformer is intended for production environments, it is likely that these data sources contain large volumes of data. When you build a prototype, you must set up source files that provide access to a subset of the data that is sufficient for designing your model.
The data sources you use to build the prototype must have the same columns as those you intend to use later, in the UNIX or Linux® component. The names of columns used to define levels and measures in the models must match. However, the columns can be in any order and may be unused. If there are fewer categories in each column of the prototype source than in the production source, data records found in the production source which were not found in the prototype source will provide new categories for the UNIX or Linux server model.
IBM® Cognos Impromptu Query Definition (IQD) files are available only on supported IBM Cognos Series 7 platforms. IQD files are not a supported data source on Linux and HPUX Itanium platforms.
If you use data sources other than IQD files or IBM Cognos package and report data sources, you must set up separate physical sources of flat file data sources on the local computer used for the prototype, and on your UNIX or Linux server. Packages and reports are maintained in the model; however, the UNIX or Linux server requires database client connectivity to retrieve query results for cube building.