 |
|
|||||||
 |
   
|
|
||||||
|
|
|||||||
|
|
|
||||||
| Vendor | Cognos (an IBM company) |
| Tool Name | Cognos 8 Framework Manager Services |
| Tool Version | RN 8.1.* and C8 v8.1 to 8.4 |
| Tool Web Site | http://www.cognos.com/products/framework_services/ |
| Supported Methodology | [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Expression Conversion) via XML File |
Import tool: Cognos (an IBM company) Cognos 8 Framework Manager Services RN 8.1.* and C8 v8.1 to 8.4 (http://www.cognos.com/products/framework_services/)
Import interface: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Expression Conversion) via XML File from Import bridge: 'CognosRnFrameworkManager2' 6.0.2 - Aug 20 2008 19:34:57
| Parameter Name | Description | Type | Values | Default | Mandatory |
| File | The bridge uses the native XML file from Cognos Framework Manager: Use the ellipsis (...) button to navigate to the project's directory you want to import and select the file 'model.xml'. |
FILE | Yes | ||
| Folder representation | Select how folders from Cognos Framework Manager should be represented. 'Ignore' - Folders are ignored 'Flat' - Folders are represented as Diagrams. Their hierarchy is not preserved 'Hierarchical' - Folders are represented as Diagrams and their hierarchy is preserved |
ENUMERATED | Ignore Flat Hierarchical |
Ignore | |
| Package representation | Select how the packages from Cognos Framework Manager should be represented. 'Ignore' - Ignore subject areas (default) 'Subject Areas' - Represent packages as subject areas 'Model' - Represent the package as the model (For published packages only) |
ENUMERATED | Ignore Subject Areas Model |
Ignore | |
| Reverse engineer relationships | Select whether the relationships between two dbQueries from Cognos Framework Manager should be reverse engineered as referential integrity constraints. 'True' - reverse-engineer the relationships as referential integrity constraints (default) 'False' - ignore these relationships |
BOOLEAN | True | ||
| Tables design level | This option controls the design level of the imported tables. It is particularly relevant when exporting metadata to a target tool which supports two views of the model: a logical view and a physical view. Some Data Modeling tools support this concept, where you can decide if a table appears both as a physical table and as a logical entity. Some Business Intelligence tools also support this concept, where you can decide if a table appears both in the physical model and in the business view of the model. 'Logical and physical' - the tables will appear both in the logical view and in the physical view of the model. 'Physical' - the tables will appear only in the physical view of the model (default). |
ENUMERATED | Physical Logical and physical |
Physical | |
| Ignore usage property | Specify whether the usage property of a queryItem should be used. 'True' - a queryItem of usage attribute will be represented as a dimension attribute, and a queryItem of usage fact will be represented as a measure. (default) 'False' - ignore query items |
BOOLEAN | True |
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"Cognos 8 Framework Manager Services" Metamodel |
Mapping Comments |
| Name | parameterName | |
| Argument | ProcParameter | |
| DefaultValue | value | |
| Kind | mode | |
| Name | parameterName | |
| Position | Position of the ProcParameter in the xml file | |
| AssociationRole | No equivalent, see Join Role | |
| Attribute | QueryItem | All QueryItems of a dbQuery will be mapped to an Attribute |
| Description | description | |
| Name | name | |
| Optional | nullable | |
| PhysicalName | columnName | |
| Position | Position of the QueryItem in the xml file | |
| BaseType | QueryItem | Computed from the datatype of the QueryItem |
| DataType | datatype | |
| Length | precision,size | Use Precision if it is not null, use Size otherwise |
| Name | datatype | |
| Scale | scale | |
| CandidateKey | Key | The first key by position in the xml file will be mapped as the primary candidate key of the dbQuery |
| Name | name | |
| UniqueKey | Always set to true | |
| Class | dbQuery | All dbQueries will be mapped to a Class |
| Description | description | |
| Name | name | |
| ClassDiagram | Folder, Package | A Class Diagram will be created for each folder if the option "Import folders" is not set to "No". And a Class Diagram will be created for each package if the option "Import packages" is set to "Yes". |
| Description | description | |
| Name | name | |
| ClassifierMap | modelQuery,Filter,Relationship | A Classifier Map will be created for each modelQuery/Filter/Relationship |
| Name | The name will be computed from the name of the modelQuery/Filter/Relationship | |
| DatabaseCatalog | Data Source | A Catalog will be created for each Datasource with a non empty catalog. |
| Name | catalog | |
| DatabaseSchema | Data Source | A Schema will be created for each Datasource with a non empty schema |
| Name | schema | |
| DerivedType | QueryItem | Computed from the datatype of the QueryItem |
| DataType | datatype | |
| Length | precision,size | Use Precision if it is not null, use Size otherwise |
| Name | datatype | |
| Scale | scale | |
| DesignPackage | Namespace, Folder | A Package is created for each namespace, and for each folder if the option "Import folders" is set to "Hierarchical" |
| Description | description | |
| Name | name | |
| UserDefined | Set to false only for the packages created to keep the folder hierarchy. | |
| Dimension | modelQuery | |
| Description | description | |
| Name | name | |
| Type | Set to "FactDimension" if the Dimension contains at least one measure | |
| DimensionAttribute | QueryItem | All QueryItems of usage "attribute" or "identifier" of a modelQuery will be mapped to a Dimension Attribute |
| Description | description | |
| Hide | hidden | |
| Name | name | |
| Sort | unsortable | |
| Name | name | |
| Name | name | |
| FeatureMap | QueryItem,Filter,Relationship | A FeatureMap will be created for each QueryItem of a modelQuery and each expression of a Filter/Relationship |
| Name | The name will be computed from the name of the queryItem or Filter/Relationship | |
| Operation | expression | |
| Filter | Filter | |
| Description | description | |
| Name | name | |
| Hierarchy | Hierarchy | |
| Name | name | |
| HierarchyLevelAssociation | Hierarchy,Level | |
| Index | Index | |
| Generate | Always set to true | |
| Name | A name will be computed | |
| IndexMember | Index,QueryItem | |
| Name | The name will be computed from the name of the QueryItem | |
| Position | Position of the QueryItem in the xml file | |
| Join | Relationship | |
| Type | cardinality | |
| JoinRole | Relationship | |
| Multiplicity | cardinality | |
| Level | Level | |
| Name | name | |
| LevelAttribute | Level,QueryItem | |
| Name | name | |
| LevelKey | Level | |
| Name | name | |
| Name | The name will be computed from the name of the queryItem or Filter/Relationship | |
| Measure | QueryItem | All QueryItems of usage "fact" of a modelQuery will be mapped to a Measure |
| DefaultAggregation | regularAggregate | |
| Description | description | |
| Hide | hidden | |
| Name | name | |
| Sort | unsortable | |
| Model | Namespace | The Model is the root Namespace. |
| Description | description | |
| Name | Name | |
| Projection | Graphical information of Classes | |
| RelationshipProjection | Graphical information of Associations | |
| SQLViewAssociation | No equivalent, see SQLViewEntity | |
| SQLViewAttribute | No equivalent, see SQLViewEntity | |
| SQLViewEntity | Not mapped: all dbQueries will be mapped as Class. See Class. | |
| StoredProcedure | StoredProcedure,Function | |
| CppAbstract | Not used | |
| CppConcurrency | Not used | |
| CppFriend | Not used | |
| CppScope | Not used | |
| CppStatic | Not used | |
| CppVirtual | Not used | |
| Description | description | |
| Name | name | |
| Postcondition | Not used | |
| Precondition | Not used | |
| Transformation | A Transformation will be created for each model. | |
| Name | The name will be computed from the name of the model | |
| Name | The name will be computed from the name of the queryItem or Filter/Relationship |
Last updated on Mon, 25 Aug 2008 19:35:05
