IBM Cognos, User Manual, Page: 47 / 411

Change a Data Source Type
If you decide after you import a data source in Cognos Transformer that the data
can be more effectively sourced from a different data source type, you can change
the data source.
You cannot change a data source for a query in the model to match another query
already in the model.
You cannot add or remove columns when you change a data source type.
In the data source you want to change, all columns must match references in the
new data source; you cannot match only some of the columns in the original data
source.
Procedure
1. In the Data Sources list, right click the data source you want to change, and
click Change Source Type .
2. In the New Data Source wizard, in the Data source type box, click the
drop-down arrow to select the new data source type.
You cannot change the data source name.
3. Enter the required information about the new data source type:
v
For a package or report data source, click Browse to open the metadata
browser and select a package or report from the available list.
v
For other data source types, specify the required information about the data
source, or click
Browse to open the data source browser and select a data
source from the available list.
If you click Cancel , the entire change data source type action is canceled.
4. Click Finish .
5. In the Query Definition or Modify Columns dialog box, match the columns in
the original data source to the columns in the new data source:
v
In the Source list, select a column.
v In the Model list, select the corresponding column.
v
Click Match .
The
Add
and
Remove
buttons are disabled.
v
When you finish matching all the columns in the original data source to
columns in the new data source, click
OK .
The OK button is enabled only after all the columns in the original data
source are matched to columns in the new data source.
Create Dimensions from the Dimension Map Using OLAP and DMR
Packages
The Insert Dimension from Package option is available only from the Cognos
Transformer Dimension Map. This feature provides for dimensions to be created
efficiently to resemble the original dimensional structure from your OLAP or
dimensionally modeled relational (DMR) package as closely as possible.
When the data source is an IBM Cognos OLAP package, you must import the
dimensions from the package directly from the
Dimension Map . You subsequently
import the measures from any other data source Cognos Transformer supports.
Chapter 3. Data Sources for Your Model
33