IBM Support

Multiple datapoints are mapped to a single location on a map

Troubleshooting


Problem

In IBM Cognos Analytics - Reporting 11.1.6 this is flagged as a data integrity issue that requires manual intervention before data is presented to the report consumer.

Symptom

A map doesn’t render in Cognos Analytics reports with the following warning: Multiple datapoints map to a single location [“location A”, “Duplicate of Location A”], [“location B”, Duplicate of location B”].

Cause

This essentially means that the data column has multiple regions that refer to a single location.
In the following example, single locations (the states of Washington and South Carolina) are referred to by their complete and abbreviated names: "Washington" and "WA", and "South Carolina" and "SC".
image 3052
In this case, the data that we are attempting to map looks like this:
image 3055
 

Resolving The Problem

You need to manually resolve the data inconsistencies, and confirm the result before presenting it to the report consumer.
In our example, the data must be updated so that each individual location is named consistently. Either“WA” or “Washington” must be used as the Washington state name, and either “South Carolina” or “SC” as the South Carolina state name.
The following examples show ways of updating the data to resolve this data inconsistency issue.
image 3054
 

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl4fAAC","label":"Reporting->Visualizations"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.6","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 April 2020

UID

ibm16199115