Cognos Analytics

 View Only
  • 1.  Ambiguity Mapping Regions in Mexico

    Posted Thu January 07, 2021 07:48 PM
    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


  • 2.  RE: Ambiguity Mapping Regions in Mexico

    Posted Fri January 08, 2021 10:44 AM
    Edited by System Fri January 20, 2023 04:17 PM
    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
    ------------------------------



  • 3.  RE: Ambiguity Mapping Regions in Mexico

    Posted Tue January 12, 2021 09:47 AM
    To add to Herman's reply: yes Mexico has a state called Mexico, which is why it occurs twice in the data. Cognos carries support for about 500K regions worldwide, and unfortunately there are no unique identifiers for a region that are used by everyone across the planet. If your datafile contains the exact names or any of the aliases contained in the Excel file linked below and you request all features at once, we can generally figure out your features are all in Mexico and will map them correctly.

    If not, as Herman indicated, it greatly helps if you can specify the country with the feature name when trying to map data. Create a column called country in your data, set all entries to "Mexico" or "MX". Then stack the column containing your feature name, below the column containing the country name in the map. If that doesn't work, please share the features you are trying to map and I'll take a look.

    ------------------------------
    Frank van Ham
    ------------------------------