IBM Cognos, User Manual, Page: 39 / 411

The order in which the data sources, queries, and columns appear in the list does
not impact the cube build performance. Also, regardless of this order, Cognos
Transformer automatically processes queries with measures last.
Creating a Model Using an IBM Cognos Package or Report
When the data source is a relational or dimensionally modeled relational (DMR)
package, you can import query items to create your structural or transactional
queries. You can have multiple data source queries associated with each package or
report you create as a data source.
You can create data source queries using reports created in Query Studio or Report
Studio using relational or DMR packages.
You cannot create data source queries using Cognos OLAP reports. For example,
Transformer does not support IBM Cognos Finance reports or packages as a data
source. However, you can create PowerCubes directly in Cognos Finance.
For more information, see “IBM Cognos Package or Report” on page 14, including
“Guidelines for Using IBM Cognos Packages and Reports as Data Sources” on
page 15.
For information about creating Cognos Transformer signons, see “Signons” on page
54.
Use the following tips when saving your model.
v
By default, Cognos Transformer saves models in the My Documents/
Transformer/Models directory. You can set the default location to which Cognos
Transformer saves models by changing the
Models directory setting on the
Directories tab of the Preferences property sheet on the File menu.
On Windows Vista, Cognos Transformer saves models in the
Documents/Transformer/Models directory.
v
When prompted to save in binary (.py?) or text (.mdl) format, use the latter
when exporting models or, to avoid possible fragmentation problems, when you
have made a lot of changes since your last save action.
v In addition to saving your models in .mdl format, you should regularly use the
Check Model
command from the
Tools
menu to help you diagnose and resolve
any problems in your model design.
v
In Windows, the .pyj model file extension is not automatically associated with
Cognos Transformer. To open a model in Cognos Transformer by double-clicking
the .pyj file, you must first create the association in Windows.
Procedure
1. From the Cognos Transformer Welcome page, click Create a new model .
Tip: If you are already in Cognos Transformer, click New from the File menu
to open the New Model wizard.
2. Type a name for your new model and click Next .
3.
In the
Data source name
box, enter the name of the data source and, in the
Data source type
box, select
Package
or
Report
.
Tip: If you want the data source name to default to the name of the package
or report that you select in the next step, leave the Data source name box
blank.
4. Click Browse to open the metadata browser and select a package or report
from the available list.
Chapter 3. Data Sources for Your Model
25