Skip to main content Skip to complementary content

IBM Cognos PowerPlay Transformer - Import

Availability-note AWS

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 http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html 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
*.mdl
*.pyj
  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  

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!