BUG

Unable to join integer field in a map service to a IBM Cognos field

Last Published: April 25, 2020

Description

When configuring a Cognos shape layer by using a JOIN between a map service and an IBM Cognos field, no results are returned when the map service join field is in integer format.
[O-Image] Exampe Configuration

Cause

Currently Esri Maps for IBM Cognos does not support a join between an integer map service field and an IBM Cognos field.

Workaround

Add a new field to the map service formatted as a string and populate it with integer values. ID values should always be in string format; integers should only be used if some sort of arithmetic operation is to be performed on the field.

    Article ID:000011767

    Software:
    • ArcGIS Maps for IBM Cognos 4 0

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic