Edited this when I found out there is next to the country there is a State of Mexico in Mexico (strikken text)…Hi Mario
We discuss our maps concept in the
manuals:
You will find we refer to
github project that holds the the data we use. I noticed the readme does not really explain the concept so I will give it a go ;)
Assuming you are on CA v11.1.3 or higher, you will see in the administrative hierarchy file (xlsx) that in our
mapping system Mexico has 2 levels under the
country level: 32
estados and 2460
municipios.
When you check the administrative features you will find 1 line for the country of Mexico itself: CountryCode=MX, Name=Mexico. The
path column indicates the full hierarchy up to country, so here it is empty. The
Alias column contains all aliases we have for Mexico as a country (e.g. for us,
Estados Unidos Mexicanos is a valid alias for
Mexico (the country)). Note that this is a list of aliases, each separate alias is delimited using a #.
The 32 Estados are supposed to have Mexico in the path column, e.g. Chihuahua. The 2460 cities (municipales) are the next level which will have estado@Mexico as a Path, e.g. Chihuahua@Mexico is the Path value for Tule, El (Name, Aliases: El Tule).
That's the concept, but by now you might also have noticed, as did I, that we have actually two countries in the data for country code MX: Mexico and México. Also there 32 estados for Mexico AND 32 estados for México: so Chihuahua and the other states come back twice, once for Mexico and once for México)… and that is probably the reason why you always have ambiguity for those 32 states…
Explicitly adding Mexico for the country level in your map, should normally disambiguate…
I will ask our offering management to have a look at it.Kind regards,
Herman
------------------------------
Herman Nielens
------------------------------
Original Message:
Sent: Wed January 06, 2021 05:54 PM
From: Mario Olivera
Subject: Ambiguity Mapping Regions in Mexico
Dear Community please help me
PROBLEM:
Cognos is finding ambiguity in many Mexico's regions when pulling my file, and do not show them in the map. What should be the format of the info so that Cognos can recognize the geographical data?
Steps:
1. Upload my csv data file with Mexico's regions (geo info)
2. create a new slide
3. Pull from data columns on the left zone & price columns into the right window slide
4. Expecting to view all the regions correctly in the map, but some of them are not being showed, or are showing in another country, the map shows the amboguity message or cant find some locations.
What is the correct format or the list of places that we can choose from?
Thanks
------------------------------
Mario Olivera
------------------------------
#CognosAnalyticswithWatson