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

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:

  1. Open a Cognos or Cubing Services model in the Data Project Explorer.
  2. Click File > New > Transformation Configuration from the main menu.
  3. 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.
  4. On the Source and Target page, complete the following steps:
    1. Select a Cognos or Cubing Services model file in the Selected Source field.
    2. Select a project or an opened dimensional-logical or logical data model in the Selected Target field and click Next.
  5. 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.
  6. On the Common page, specify whether to generate a log for the transformation, and click Finish. The transformation configuration opens.
  7. Click Run Cognos/Cubing Model to Dimensional-Logical Data Model (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.

Feedback