IBM Cognos PowerPlay Transformer - Import
Bridge Requirements
This bridge:is only supported on Microsoft Windows.
requires the tool to be installed to access its SDK.
Bridge Specifications
| Vendor | IBM |
| Tool Name | Cognos PowerPlay Transformer |
| Tool Version | ReportNet 1.1 to Cognos 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) via COM API on MDL File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: IBM / Cognos PowerPlay Transformer version ReportNet 1.1 to Cognos 12.x via COM API on MDL File
See http://www.ibm.com/software/analytics/cognos/
Metadata: [Business Intelligence] BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage)
Component: CognosPowerPlayTransformer version 11.2.0
OVERVIEW
The bridge relies on the IBM Cognos Transformer OLE Automation API in order to import metadata. Therefore, IBM Cognos Transformer must be properly installed on the machine executing this bridge.
REQUIREMENTS
WARNING: This bridge uses the COM API of a Windows based tool client and/or SDK which must be (a) properly installed, (b) licensed on behalf of a Windows user capable of running this tool, and (c) capable of accessing the tool server content. In addition:
(1) As recommended by the tool vendor, the tool server must NOT be installed/coexist on the same machine where the tool client (and the bridge) is installed/running because of potential conflicts of resources, including with respect to COM API.
(2) Windows COM API based tools are notoriously unstable after repeated failures or lack of system resources, which requires a Windows reboot to make that tool COM API work properly again.
(3) If this bridge is running as an application, then it must be logged with the same above Windows user.
If the bridge is running as a Windows service, then go to the services manager of Windows, right-click on the MIMB Application Server service, and go to the "Log On" tab to define an account by name under which the service will run.
For the bridge to work properly, TransformerSDK.dll must be available on the user's system (it is included as part of the Transformer installation)
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
Q: How do I provide IBM Cognos Transformer metadata to the support team to reproduce an issue?
A: You need to locate your MDL and/or PYJ file and send it to support team.
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope | ||
| File | The path name of the Transformer Model Definition Language (MDL, PYJ) file to import. | FILE |
|
Mandatory |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"IBM Cognos PowerPlay Transformer" Metamodel Cognos BI Reporting (PowerPlay) |
Mapping Comments |
| DataAttribute | Column | |
| Description | Description | |
| InitialValue | Initial Value | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Optional | Optional | |
| PhysicalName | Physical Name | |
| Position | Position | |
| Usage | Usage | |
| DataSet | Data Source | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| PhysicalName | Physical Name | |
| DesignPackage | Data Sources, Dimension Map, Folder, Measure Folder | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Dimension | Measure Dimension, Dimension, Time Dimension | |
| Description | Description | |
| Hide | Hide | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Type | Type | |
| DimensionAttribute | DimensionAttribute | |
| Description | Description | |
| Hide | Hide | |
| InitialValue | Initial Value | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Optional | Optional | |
| OriginalName | Original Name | |
| Position | Position | |
| Sort | Sort | |
| Hierarchy | Hierarchy | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| PhysicalName | Physical Name | |
| Type | Type | |
| Level | Level | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| LevelAttribute | LevelAttribute | |
| Description | Description | |
| InitialValue | Initial Value | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Optional | Optional | |
| Position | Position | |
| Measure | Calculated Measure, Measure | |
| DefaultAggregation | Default Aggregation | |
| Description | Description | |
| Hide | Hide | |
| InitialValue | Initial Value | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| Optional | Optional | |
| Position | Position | |
| Sort | Sort | |
| OlapSchema | PowerCubes | |
| Description | Description | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| PhysicalName | Physical Name | |
| Stereotype | Stereotype | |
| StoreModel | Transformer Model | |
| Author | Author | |
| CreationTime | Creation Time | |
| Description | Description | |
| ModificationTime | Modification Time | |
| Modifier | Modifier | |
| Name | Name | |
| NativeId | Native Id | |
| NativeType | Native Type | |
| PhysicalName | Physical Name | |
| StoreType | Store Type | |
| SystemMajorVersion | System Major Version | |
| SystemMinorVersion | System Minor Version | |
| SystemReleaseVersion | System Release Version | |
| SystemType | System Type | |
| SystemTypeOld | System Type Old |