IBM Cognos to Power BI Conversion Report
This topic provides a comprehensive report of IBM Cognos conversion. The conversion pipeline converts legacy datasets and reports to Power BI equivalent.
- Total BI Objects: Displays the number of BI objects. It also gives a segregated view of how many objects are successfully converted and how many failed.
- Status: Provides status of the BI Conversion stage.
- Description: A brief description of the stage is displayed.
- Time Taken for Execution: The time taken for conversion.
In This Topic:
BI Objects
This section showcases the conversion reports for each dataset and report. The converted datasets and reports can be directly consumable in the modern BI platform. The left panel lists all the datasets along with the conversion status. The right panel shows information about datasets and reports. It includes information about the type, status, and remarks. Remarks displays an error message if the dataset or report fails to convert.
It helps you understand the error and guides you to fix it.
Package
This topic provides converted datasets and reports in pbip file format which can be executed directly on the target platform. Select 
to download the converted artifacts for offline use.
The below image shows the converted dataset which contains the data model.
The below image shows the converted Power BI equivalent report.
In addition, you can access the cognos_conversion_additional_help.xlsx, cognos_conversion_logs.xlsx, and todo.txt reports, each offering detailed error specifications and troubleshooting information to help you quickly detect and resolve issues during code transformation.
- The cognos_conversion_additional_help.xlsx report contains a detailed error specifications generated during the transformation process. Error specifications include:
- Error messages with clear explanations for quick issue resolution.
- Unsupported components or properties that cannot be auto converted and LeapLogic has not implemented alternative logic or methods for conversion.
- Technical limitations that prevent the conversion of certain properties or components.
- Partially supported components.
- The cognos_conversion_logs.xlsx report contains information about the components or properties that are not supported in target environment and require manual intervention for successful conversion. In such cases, LeapLogic has implemented alternative logic or methods to convert the source components or properties to the target-equivalent.
- The todo.txt report contains all error messages and issues encountered during code transformation. It includes warnings, errors, alerts, and informational messages to guide further actions for the successful conversion of components or properties to the target equivalent.
Additionally, you can also see a cognos_conversion_report.xlsx report which provides detailed information about the cognos conversion including the number of total, failed, successfully transformed charts, visual objects, calculations, filters, and more. It also includes information about the automation level indicator along with deductible and deducted script quota.
Data Flow Diagram
Here, you can see the entity relationship diagram for the dataset. This Data Flow Diagram gives a clear representation of data flow along with the cardinality. The cardinal relationships are:
|
Cardinal relationship |
Description |
Notation |
|
one-to-one |
One instance of a table is associated with only one instance in another table |
 |
|
one-to-many |
One instance of a table is associated with multiple instances in another table |
 |
|
many-to-one |
Multiple instances of a table are associated with one instance in another table |
 |
|
many-to-many |
Multiple instances of a table are associated with multiple instances in another table |
 |
Leaplogic