If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Imported map not showing data

Started by bdbits, 04 Feb 2010 10:04:13 AM

Previous topic - Next topic

bdbits

I have a map generated out of ESRI and imported to Cognos. I can see the region names in Map Manager. I have data with values that match the map region names (county names), and an associated value. I create a RS map using this data and set the location and colors, but it does not render any colored regions on the map. I have worked through the samples, they work fine and I am following the same steps, but with my data and map. I examine the report data in RS tabular view, it looks correct. I view the report in XML and the data looks fine. This looks so simple but I cannot see any reason for the region fills to fail. I don't have enough hair left to figure this out. :-P

What am I missing?

bdbits

Update: Cognos provides a US Map that includes county names for every state. It does not show any data rendered either. I am thinking I am missing something fundamental, but I assigned the color and location items just as the Cognos tutorial directed but using my data. It did not seem to require anything more and my setup is not really any different. So any ideas are appreciated, however far out there it may seem.

MFGF

It sounds suspiciously to me like your database region names are not matching up to the data points defined in the map.  Is it possible there are spaces embedded at the beginning/end of your names?

MF.
Meep!

bdbits

Short answer: it was trailing spaces. I figured it out late Friday and had not posted a followup yet.

That was my initial thought, too, spaces or case-sensitivity or something like that. But I had used the XML option in the viewer and it stripped the trailing spaces, so I had eliminated that possibility in my mind. (I think the same happened in CSV but I'm not sure.) Then I decided to export the data to a spreadsheet and use that as the datasource to make it easier to mess with. I went to edit the name cells and there they were, trailing spaces. That was extremely annoying, let me tell you.

MFGF

Glad you found the culprit!  These things can be very annoying (when everything looks like it should work but just doesn't).  Thanks for posting up the solution - hopefully this may be useful to others sometime.

Cheers!

MF.
Meep!