To transform a Cognos or Cubing Services model into a dimensional-logical
data model, select and open a Cognos or Cubing Services model and
run a Cognos/Cubing Model to Dimensional-Logical Data Model transformation
configuration.
Before you begin
- You must have a Cognos or Cubing Services model that was imported
into the workbench.
- Analyze your Cognos or Cubing Services model to ensure that it
is valid before you transform it.
About this task
You create a transformation configuration to transform
your Cognos or Cubing Services model into a dimensional-logical data
model. You can reuse this transformation configuration.
Procedure
To transform a Cognos or Cubing Services model into
a dimensional-logical data model:
- Open a Cognos or Cubing Services model in the Data
Project Explorer.
- Click from
the main menu.
- On the Specify a Configuration Name and Transformation page,
select Cognos/Cubing Model to Dimensional-Logical Data
Model from the Transformation list,
type the name of the transformation, and click Next.
- On the Source and Target page, complete
the following steps:
- Select a Cognos or Cubing Services model file in the Selected
Source field.
- Select a project or an opened dimensional-logical or
logical data model in the Selected Target field
and click Next.
- On the Properties page, specify the
values for the following properties of the transformation configuration:
Property |
Description |
Overwrite files without warning |
If you select the True option, you
are not prompted to overwrite any files that exist. |
Source dimensional model |
Select the type of data model that you are transforming into
a dimensional-logical data model. |
- On the Common page, specify whether
to generate a log for the transformation, and click Finish. The transformation configuration opens.
- Click Run Cognos/Cubing Model to Dimensional-Logical
Data Model (
) from the toolbar.
Results
The dimensional-logical data model is created and displayed
in the
Data Models folder of your target project.
The new model is named after your Cognos or Cubing Services model.