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

Going nuts with Maps

Started by Seveman, 14 Jun 2013 06:34:18 AM

Previous topic - Next topic

Seveman

I'm trying to create my first map and I'm going nuts. I'm using Cognos 8.3 and SQL Server 2005. I have a set of revenue data linked to countries. I drop the revenue fiel in the color tab, country in the location tab and when I dun it I get "RSV-RND-0094 The map chart data contains references to missing region names. Map file: 'world.cmf', missing region names: 'xxxxxxxxx'" all the countries
So I followed this steps:
I filetered the data down to Argentina to isolate the problem. The I exported from the dictionary the value "Argentina" to my table so there would be no mistyping match. I Created alias AR and Argentina in the dictionary. Only have 1 world.cmf file in the server.
I keep getting this error with any country in the database.
Any ideas?

Seveman

Well, it seems I found the problem, the solutin does not look so straightforward at least to me. The problem is that sql server 2005 pads the char field with blanks and that does not match well with Cognos map. I found this out after chopping the field in the databas and finding out that some copuntries, the ones with just the exact lenght of the table field showed up.
Now for the solution. I created a char(2) field and put aliases in there. But I use 2 dictionaries spanish and english.
How do I mass-update cognos spanish dictinary with aliases?