Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Map Viz with Zip Codes

    Posted Tue February 25, 2020 05:15 PM
    Looking for confirmation the Map Viz​ does or does not work with (US) zip codes.
    Splitting the value, defining as a string or as numeric has not worked.
    Must I bring in coordinates? If so, please note as most users have zip or province codes, not lat/long data, would be a nice enhancement.

    Thank you

    ------------------------------
    Elizabeth Griffin
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Map Viz with Zip Codes

    Posted Wed February 26, 2020 09:29 AM
    DOES work. You do not have to bring in lat/lon's. See sample provided with base install - Samples > Dashboards > California website visits.
    Cognos map zipcode example


    ------------------------------
    Kurt Rivard
    ------------------------------



  • 3.  RE: Map Viz with Zip Codes

    Posted Thu February 27, 2020 03:57 AM
    If Cognos can't do zipcodes (I don't know), then these datasets might be useful.

    US Zip Codes Database
    Simplemaps remove preview
    US Zip Codes Database
    We're proud to offer a simple, accurate and up-to-date database of US Zip Codes. It's been built from the ground up using authoritative sources including the U.S. Postal Service™, U.S. Census Bureau, National Weather Service, American Community Survey, and the IRS. What is a ZCTA (Zip Code Tabulation Area)?
    View this on Simplemaps >



    US Zip Code Latitude and Longitude
    Opendatasoft remove preview
    US Zip Code Latitude and Longitude
    The ZIP code database contained in 'zipcode.csv' contains 43204 ZIP codes for the continental United States, Alaska, Hawaii, Puerto Rico, and American Samoa.
    View this on Opendatasoft >





    ------------------------------
    Reinier Battenberg
    https://github.com/CognosExt
    ------------------------------



  • 4.  RE: Map Viz with Zip Codes

    Posted Tue March 03, 2020 03:43 AM
    Maps are supporting zipcodes - if you want to see what CA expects in terms of formats, take a look at: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/ca_concept_using_maps.html and the Github link in there.
    Very useful for seeing the region names and their alias'

    Torben

    ------------------------------
    Torben Noer
    ------------------------------