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".
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".
In this case, the data that we are attempting to map looks like this:
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.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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"}}]
Was this topic helpful?
Document Information
Modified date:
24 April 2020
UID
ibm16199115