To transform a dimensional-physical data model into a Cognos
or Cubing Services model, select and open a dimensional-physical data
model and run a Dimensional-Physical Data Model to Cognos/Cubing Model
transformation configuration.
Before you begin
- The source model must have dimensional notation enabled. The facts,
dimensions, and other dimensional modeling objects must be specified.
- Analyze your dimensional-physical data model to ensure that it
is valid before you transform it.
About this task
You create and run a transformation configuration to transform
a dimensional-physical data model into a Cognos or Cubing Services
model. You can reuse this transformation configuration.
Procedure
To transform a dimensional-physical data model into
a Cognos or Cubing Services model:
- Open a dimensional-physical data model in the Data
Project Explorer. You can transform from a .pdm
file that has dimensional notation enabled.
- Click from
the main menu.
- On the Name and Transformation page,
select Dimensional-Physical Data Model to Cognos/Cubing
Model from the Transformation list,
enter the name of the transformation, and click Next.
- On the Source and Target page, complete
the following steps:
- Select a database, schema, or diagram in the Selected
Source field.
- Select a project in the Selected Target field.
- Click Next.
- Optional: On the Properties page,
change the default options that are used during transformation:
Property |
Description |
Data source name [Cognos Model] |
Specify the name of the data source for a Cognos Framework
Manager model. By default, this option is blank. The workbench will
determine the name of the data source. For example, the workbench
will use the database name to create the name for the resulting data
model. |
Generate namespace for database schema [Cognos
Model] |
Use this property to specify whether to generate a namespace
for the database schema. If you select True,
a namespace is generated. |
Name source of table and column for Logical /
Dimensional view |
Use this property to specify how the names of tables and
columns are derived. Table and column names can be specified by the Label or Name of
the source data object. |
Target dimensional model |
Select the type of dimensional model to create as a result
of the transformation. You can create a Cognos Model or
a Cubing Model. |
- On the Common page, specify whether
to generate a log for the transformation, and click Finish.
- Click Run Dimensional-Physical Data Model to
Cognos/Cubing Model (
) from the toolbar.
Results
The Cognos or Cubing Services model is created and displayed
in the
XML Schemas folder of your target project.
The new dimensional model is named after the name of your database,
schema, or diagram that you selected as the source. For example, if
the source database was named
GSDB, the new
XML file would be
GSDB.xml.