Objects and properties generated from the dimensional-physical data model-to-Cognos transformation

The dimensional-physical data model-to-Cognos transformation generates objects and properties for the physical data model from Cognos model elements.
The following table shows the correspondence between dimensional-physical data model objects and properties and Cognos data model objects and properties.
Table 1. Mappings from dimensional-physical data models to Cognos models
Dimensional-physical data model object or property Cognos Framework Manager object or property
Column QueryItem
Column - Name or Label QueryItem - Name
Column - Documentation QueryItem - Description
Column - Data Type QueryItem - Data Type
Database Model
Database - Name Model - Name (.xml file name)
Database Namespace
  • PhysicalView
  • LogicalView
  • DimensionalView
Database - Documentation Namespace - Description
Database - Name Namespace - Name
Diagram
  • Model
  • Namespace - PhysicalView
  • Namespace - LogicalView
  • Namespace - DimensionalView
Diagram - Name
  • Model - Name (.xml file name)
  • Namespace - Name
Diagram - Documentation Namespace - Description
Dimension table Regular dimension
Fact table Measure dimension
Hierarchy Hierarchy
Hierarchy - Name Hierarchy - Name
Level Level
Level - Name Level - Name
Level attribute Level attribute
Level attribute - Name Level attribute - Name
Level attribute - Role Level attribute - Role
Measure column Measure
Measure column - Aggregation function or rule Measure - Aggregation function or rule
Measure column - Type
  • Non-additive
  • Semi-additive
  • Additive
Measure - Type
  • N/A
  • Regular aggregate
  • Semi-aggregate
Relationship
  • Relationship
  • Scope relationship
Relationship - Name
  • Relationship - Name
  • Scope relationship - Name
Relationship - Cardinality
  • Relationship - Cardinality
  • Scope relationship - Cardinality
RelationshipEnd RelationshipEnd
RelationshipEnd - VerbPhrase or Inverse VerbPhrase RelationshipEnd - Name
RelationshipEnd - Cardinality RelationshipEnd - Cardinality
Schema
  • Model
  • Namespace - PhysicalView
  • Namespace - LogicalView
  • Namespace - DimensionalView
Schema - Name
  • Model - Name (.xml file name)
  • Model - Name
Schema - Documentation Namespace - Description
Table Query Subject
Table - Name or Label Query Subject - Name
Table - Documentation Query Subject - Description

Feedback