Exporting Data to IBM Cognos Analytics

Cognos Analytics is a cloud-based application developed by IBM that allows sharing of data and information across workgroups as well as create and/or personalize dashboards and reports on various types of devices.

 

Exporting to Cognos Analytics is made possible through Monarch Complete and Monarch Complete with Table Extractor.

Some information are necessary to successfully export and work with your data in IBM Cognos Analytics:

• A correctly set up Cognos Analytics service

• Server URL – The URL of your Cognos Analytics service. This URL must be entered into the field provided in the Server > IBM Cognos Analytics sub-tab of the Application Default Settings dialog of Monarch Data Prep Studio.

• Namespace – The security connection type employed for the service

• Username

• Password

Steps:

1. Go to the Server tab of the Application Default Settings dialog and enter the URL of the IBM Cognos Analytics Service to which you are connecting. Select OK to save your changes.

2. Create a table and then export this table to IBM Cognos Analytics.

3. Enter the necessary information (e.g., namespace, username, password) into the dialog that displays. Click OK when you are finished. You will need to provide this information only once per Monarch Data Prep Studio session. Subsequent exports to the same service will use the information you provided upon first export to Cognos Analytics.

The export operation is executed and the Export Results panel is updated.

The table you exported should display in My Content when you log into your Cognos Analytics service.

More information on how to get started using IBM Cognos Analytics may be found here.

.