In this article, we will learn How to use Maps in IBM Cognos Analytics? To understand the concept of Maps we will create a report of World Populations. On click on any country, we will drill through to state report. Following is the Final Output for Report.
First, we need data. Download following excel file.
|WorldPopulation.xlsx||NA||16309||Login to Download|
|IndiaPopulation.xlsx||NA||10117||Login to Download|
|CityPopulation.xlsx||NA||10538||Login to Download|
In our Excel file, we are using three different sheets. The first sheet is for World population for the year 2018. On the second sheet, we have some dummy data for the Indian States and union territory data. In the last and the third sheet, we have population data for some Cities of Madhya Pradesh State. All the data are the dummy data and only for testing and clearing concepts. Population figures on the first sheet are not matching with the figures on the second sheet. Second sheet data are not matching with the third sheet data. For creating our report, we need to first upload it to IBM Cognos Analytics. First, upload World Population Data.
Next, upload India and City Population Excel. We have our required source data. We will use it for our new Data Module.
Our data is ready. Next, we will create a new Data Module. Create a new Data Module, select all three files as a source. For City data change the properties for Lat and Lon. Make Lat and Lon to an identifier. We don't need to perform any aggregation on Lat and Lon. Change the aggregation type to none. Also, change the Represents type as a Geographic Location. Select Latitude for Lat column and Longitude for Lon column. If required you can rename the columns.
We have data for World, India and City. We need to create a relationship between each excel file. Create one-to-many relationships between World and India using the columns ID and CountryID. Create another one-to-many relationship between India and City using the columns ID and StateID.
To create a relationship click on diagram icon. Right click on "World Population Xlsx" and select Create Relation. Inside new dialogue in Table2 selects India Population Xlsx. Create one-to-many relationships between ID and Country ID Column. Select ID for World Population Xlsx and CountryID for India Population Xlsx, then click on Match selected columns.
Also create relationships between "India Population Xlsx" and "City Population Xlsx".
Save the data module with name "World Population". Our data module is ready to use. Next we will create a City Report.
First, we will create a report for City data. Follow the steps to create a new report
In the city report, we used Latitude and Longitude option. We will use the first option for our Country Report. Following is the Download URL for report.
|City population Report.txt||NA||11375||Login to Download|
Our first report is ready. Next, we will create a Country Report. Follow the steps to create a new report
Following is the Download URL for report.
|Country Report.txt||NA||10938||Login to Download|
In the last two examples, we worked with for Cognos Reports. In this example, we will add Maps on Cognos Dashboards. Follow below steps to add a map in Cognos Dashboards.
We are done with Dashboard. Save it and Run it. Following video shows the final output for the report.
Please login to post your valuable comments.