IBM Support

Creating Cognos package and report from Maximo objects

Technical Blog Post


Abstract

Creating Cognos package and report from Maximo objects

Body

I would like to explain the following topics.

 

1. How to create Cognos packages from Maximo objects?
2. How to create Cognos reports using the published package?
3. How to export your Report Specification to xml formatted text file?

 

 

1. How to create Cognos packages from Maximo objects?

- Click Menu: "System Configuration" -> "Migration" -> "Object Structures"

- Enter keywords to find the object

- Select the object you want to publish as package

  You can see the details of the Maximo object.

- Click Action: "Publish as Cognos Package"

  Once the object is published a message will be displayed.

 

2. How to create Cognos reports using the published package?

We will open Cognos Connection (Web based Cognos tool) to check the published package and create a report.

- Click Menu: -> "Administration" -> "Report Administration"

- Click Action: -> "Cognos Reporting"

- In the main page of Cognos, find the folder where you saved all the published packages.

  The folder name is configured in the setting: Maximo -> "Integration" -> "End Points" -> Search "MXCOGNOS" -> "CONTENT_STORE_PACKAGE_LOCATION"

- Click the package name to enter to the package.

- Click Menu: "Launch" -> "Report Studio"

- Click "Create new"

- You can see the package name. If you want to change to another package, click "..." then select another package name

- Select report type (e.g. Crosstab)

- Click "OK"

- From the data hierarchy shown in 'Cognos - Insertable Objects Pane' (on the left top section), drag each data item then drop into the location in the table (Rows, Columns, Measures)

- Click Run icon in the menu to run the report

  The Cognos Viewer is opened and the report is displayed.

 

3. How to export your Report Specification to xml formatted text file?

- Go to "Tools" menu
- Click "Copy Report to Clipboard"
- You will see the report specification in XML format
You can use this specification to check your report or move one report to another environment.

 

 

** These instruction is available on YouTube.

https://youtu.be/R1Xr9O6VzsE 

 

Thank you!

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11130517