COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: consultantshaz on 23 May 2010 11:16:52 AM

Title: URGENT : MAP data referance to duplicate names
Post by: consultantshaz on 23 May 2010 11:16:52 AM

Hi Experts

Could you pls. tell me how I can resolve this error.

The map chart data contains references to duplicate point names. Review the chart data and the map dictionary.
Title: Re: URGENT : MAP data referance to duplicate names
Post by: joe22 on 24 May 2010 07:32:03 AM
Hi Shaz,
This means your data source where you are getting map elements have more than one record for the entities you want to show on the map.
What you will have to do is go to your go to your mapinfo file from where you are getting the data points and delete duplicate records for the location.
e.g. If you have a file which has States of the US then that will have say 3 records for Hawaii as they have disconnected geographic boundaries. But in your data mart/warehouse/schema there will only one entry for Hawaii. So, delete the records if accepatable for the smaller entries and remap with the map manager. This should do the trick.

HTH
Joe
Title: Re: URGENT : MAP data referance to duplicate names
Post by: imnini on 20 Mar 2011 11:02:19 PM
e.g. If you have a file which has States of the US then that will have say 3 records for Hawaii as they have disconnected geographic boundaries.But in your data mart/warehouse/schema there will only one entry for Hawaii. So, delete the records if accepatable for the smaller entries and remap with the map manager. This should do the trick.
--

I don't really understand what you mean. Please advise more. Thank you.

There were 3 records for Hawaii as they have disconnected geographic boundaries. <--That's the real location on the map. Hawaii need 3 records to display 3 disconnected geographic areas. If you delete the other 2, there will be only one area displayed on the map while report running. That's not correct.