IBM Cognos Framework Manager (FM) - Export
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | IBM |
| Tool Name | Cognos Framework Manager |
| Tool Version | Cognos 8.1 to 12.x |
| Tool Web Site | http://www.ibm.com/software/analytics/cognos/ |
| Supported Methodology | [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Conversion) via XML File |
SPECIFICATIONS
Tool: IBM / Cognos Framework Manager version Cognos 8.1 to 12.x via XML File
See http://www.ibm.com/software/analytics/cognos/
Metadata: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage, Expression Conversion)
Component: CognosRnFrameworkManager2 version 11.2.0
OVERVIEW
This bridge converts a metadata model into an IBM Cognos Framework Manager model.
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at MIMB Known Limitations or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
SUPPORT
Provide a troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| File | The bridge uses the native XML file from IBM Cognos Framework Manager: 1. Create a new project in IBM Cognos Framework Manager. 2. Navigate to the project's directory and export in the 'model.xml' file. |
FILE | *.xml | Mandatory | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IBM Cognos FM Version | The version of IBM Cognos Framework Manager. | ENUMERATED |
|
Cognos 10.2 - XML v60.3 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Logical/Physical representation | The chosen representation of logical and physical information in IBM Cognos Framework Manager. 'Integrated' Logical and physical objects are represented as one object in IBM Cognos Framework Manager. 'Separated' Logical and physical objects are represented as two related objects in IBM Cognos Framework Manager. 'Separated (verbose)' Logical and physical objects are represented as two distinct objects in IBM Cognos Framework Manager. |
ENUMERATED |
|
Separated | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Dimensional/Logical representation | The chosen representation of dimensional information in IBM Cognos Framework Manager. 'Integrated' Dimensional objects are represented as one dimensional object in IBM Cognos Framework Manager. 'Separated' Dimensional objects are represented as one dimensional and one logical object in IBM Cognos Framework Manager. |
ENUMERATED |
|
Integrated | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Diagram representation | The chosen representation of Diagrams in IBM Cognos Framework Manager. 'None' Diagrams are ignored. 'As Namespaces' Diagrams are represented as Namespaces only to IBM Cognos Framework Manager. 'As Packages' Diagrams are represented as Packages only to IBM Cognos Framework Manager. 'Both' Diagrams are represented both as Namespaces and as Packages to IBM Cognos Framework Manager. The default is to represent Diagrams as both Namespaces and Packages. The recommended values are: 'As Packages' When migrating metadata from a business intelligence design tool 'Both' When migrating metadata from a data modeling tool |
ENUMERATED |
|
Both | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Namespace hierarchy | Specify how Packages are represented in IBM Cognos Framework Manager. The CWM/UML (Common Warehouse Metadata/ Unified Modeling Language) notion of package is represented as namespace in IBM Cognos Framework Manager. 'None' The hierarchy of Packages is lost. 'Dimensional level only' The hierarchy of Packages is kept in the dimensional Namespace only. 'Logical level only' The hierarchy of Packages is kept in the logical Namespace only. 'Physical level only' The hierarchy of Packages is kept in the physical Namespace only. 'All' The hierarchy of Packages is kept in all the Namespaces. |
ENUMERATED |
|
All | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Logical only classes | Specify whether the logical only Classes should be represented in IBM Cognos Framework Manager. 'Ignore' Logical only Classes are ignored. 'Show' Logical only Classes are shown along with all their Attributes. |
ENUMERATED |
|
Show | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Logical only attributes | Specify whether the logical only Attributes should be represented in IBM Cognos Framework Manager. Note that this option does not affect logical only Attributes in a logical only Class (see option 'Logical only classes'). 'Drop' Logical information of a Class is not shown if it contains a logical only Attribute. 'Ignore' Logical only Attributes are ignored. 'Show' Logical only Attributes are shown. |
ENUMERATED |
|
Show | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Unreferenced dimension attributes | Specify how to represent unreferenced dimension attributes (i.e. the ones that do not participate in a level and are not referenced by any other dimension attribute). The option allows to discriminate against the unreferenced dimension attributes that participate in a join as the joins are all represented in the physical layer and not in the dimensional layer. 'Show all' All unreferenced dimension attributes are shown. 'Show join' Unreferenced dimension attributes participating in a join are shown. 'Ignore join' Unreferenced dimension attributes participating in a join are ignored. 'Ignore all' Unreferenced dimension attributes are ignored. |
ENUMERATED |
|
Show all | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Dimensions without dimensional information representation | Specify how to represent dimensions that do not contain any dimensional information (hierarchy or level) in IBM Cognos Framework Manager. 'Dimension' Create a dimension and a default hierarchy and level. 'ModelQuery' Create a modelQuery. |
ENUMERATED |
|
Dimension | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Create cubes | Specify whether the bridge should create cubes in IBM Cognos Framework Manager. The cubes will be represented as a namespace containing all the necessary information from the fact dimension, the dimensions and the joins necessary to build it. | BOOLEAN | True | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Populate screentip | Specify whether the bridge should duplicate the description field into the screenTip field. This option allows to see the description field as a screentip in IBM Cognos Query Studio or IBM Cognos Report Studio. | BOOLEAN | False | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource name | The name of the dataSource in Content Manager. | STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource default catalog name | The name of the default catalog for the specified dataSource in Content Manager. | STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource default schema name | The name of the default schema for the specified dataSource in Content Manager. | STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Target DataBase | Specify the target database type. 'Auto Detect' means that the bridge will try to auto-detect the target database from the source model. | ENUMERATED |
|
Auto Detect | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Model locale | The locale that should be used to generate the model. | ENUMERATED |
|
en-us | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name of the namespace containing the dimensional information | Type in the desired name for the namespace that will contain the dimensional information. | STRING | Dimensional Model | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name of the namespace containing the logical information | Type in the desired name for the namespace that will contain the logical information. | STRING | Logical Model | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name of the namespace containing the physical information | Type in the desired name for the namespace that will contain the physical information. | STRING | Physical Model | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Name of the namespace containing the subject areas | Type in the desired name for the namespace that will contain the subject areas. | STRING | Subject Area | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Logical Attribute Order | Determines the order of the logical attributes: 'Logical Attribute Order' Matching the entity's attribute order of the source logical data model if available. 'Physical Column Order' Matching the table's column order of the created DB query items |
ENUMERATED |
|
logical attribute order |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"IBM Cognos Framework Manager (FM)" Metamodel CognosRnFrameworkManager2 |
Mapping Comments |
| Name | parameterName | |
| Argument | ProcParameter | |
| DefaultValue | value | |
| Kind | mode | |
| Name | parameterName | |
| Position | Order in the xml file | |
| Association | Relationship | |
| Name | name | |
| AssociationRole | Relationship | |
| Multiplicity | cardinality | |
| Attribute | QueryItem | |
| Description | description | |
| Name | name | |
| Optional | nullable | |
| PhysicalName | columnName | |
| Position | Position of the QueryItem in the xml file | |
| DataType | datatype | |
| Length | precision,size | Use Precision if it is not null, use Size otherwise |
| Name | datatype | |
| Scale | scale | |
| CandidateKey | Key | |
| Name | name | |
| Class | dbQuery | |
| Description | description | |
| Name | name | |
| PhysicalName | name | Depending on the value of the option "Logical/Physical representation" the physical name might be used as the name of the dbQuery |
| ClassDiagram | Namespace,Package | Depending on the value of the option "Diagram representation", a Class Diagram will be mapped to a namespace, a package, both or none. |
| Description | description | |
| Name | name | |
| ClassifierMap | modelQuery | Used to build the sql statement of a modelQuery |
| Condition | Filter.Relationship | A condition is used to build the expression of a filter/relationship |
| DatabaseSchema | Data Source | A Schema will be created for each Datasource with a non empty schema |
| Name | schema | |
| DerivedType | QueryItem | |
| DataType | datatype | See datatype conversion array |
| Length | precision | |
| Name | datatype | |
| Scale | scale | |
| DesignPackage | Namespace | |
| Description | description | |
| Name | name | |
| UserDefined | Set to false only for the packages created to keep the folder hierarchy. | |
| Dimension | modelQuery | |
| Description | description | |
| Hide | If set to "true", the modelQuery will be hidden in all the packages in belongs to | |
| Name | name | |
| DimensionAttribute | QueryItem | |
| Description | description | |
| Hide | If set to "true", the QueryItem will be hidden in all the packages in belongs to | |
| Name | name | |
| Sort | unsortable | |
| Name | name | |
| Name | name | |
| FeatureMap | QueryItem | Used to build the expression of a QueryItem |
| Description | patterMapping | Mapped to the custom property "patternMapping" |
| Operation | expression | |
| Filter | Filter | |
| Description | description | |
| Name | name | |
| Generalization | Relationship | A relationship will be created between each supertype and each subtype of the generalization |
| Name | The name will be computed from the name of the generalization, of the supertype and of the subtype involved. | |
| GeneralizationRole | Relationship | |
| Hierarchy | Hierarchy | |
| Name | name | |
| HierarchyLevelAssociation | Hierarchy | |
| Position | Order in the xml file | |
| Index | Index | |
| Generate | Always set to true | |
| Name | A name will be computed | |
| IndexMember | Index | |
| Description | Order in the xml file | |
| Name | The name will be computed from the name of the QueryItem | |
| Join | Relationship | |
| JoinRole | Relationship | |
| Multiplicity | cardinality | |
| Level | Level | |
| Name | name | |
| LevelAttribute | Level | |
| Name | name | |
| LevelKey | Level | |
| Name | name | |
| Measure | QueryItem | |
| DefaultAggregation | regularAggregate | |
| Description | description | |
| Hide | If set to "true", the QueryItem will be hidden in all the packages in belongs to | |
| Name | name | |
| Sort | unsortable | |
| Projection | Graphical information of Classes | |
| RelationshipProjection | Graphical information of Associations | |
| SQLViewAttribute | QueryItem | |
| Description | description | |
| Expression | sql | |
| Name | name | |
| PhysicalName | columnName | |
| Position | Order in the xml file | |
| SQLViewEntity | dbQuery | |
| Description | description | |
| Name | name | |
| PhysicalName | name | Depending on the value of the option "Logical/Physical representation" the physical name might be used as the name of the dbQuery |
| WhereClause | sql | |
| StoreConnection | Data Source | A datasource will be created for each catalog |
| Name | catalog | |
| StoreModel | Namespace | The Model is the root Namespace. |
| Description | description | |
| Name | Name | |
| StoredProcedure | StoredProcedure,Function | A stored procedure is mapped to a function if it has a return parameter |
| Description | description | |
| Name | name |