Transforming a dimensional-physical data model into a Cognos or Cubing Services model

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:

  1. Open a dimensional-physical data model in the Data Project Explorer. You can transform from a .pdm file that has dimensional notation enabled.
  2. Click File > New > Transformation Configuration from the main menu.
  3. 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.
  4. On the Source and Target page, complete the following steps:
    1. Select a database, schema, or diagram in the Selected Source field.
    2. Select a project in the Selected Target field.
    3. Click Next.
  5. 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.
  6. On the Common page, specify whether to generate a log for the transformation, and click Finish.
  7. Click Run Dimensional-Physical Data Model to Cognos/Cubing Model (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.

Feedback