Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cities in France displayed in other countries when we use FDI Map

Accepted answer
21
Views
1
Comments
Ayoub AFRASS
Ayoub AFRASS Rank 2 - Community Beginner
in Oracle Fusion HCM Analytics

Dear team,

We are facing an issue while trying to display our positions by city in the map. the data for some french cities are displayed in other countries.

please see the picture below

subject Area ; HCM Position using City and #Position Headcount

Example of City : Charlevilles Mezieres that is in France but displayed in Australia

image.png
Tagged:

Best Answer

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    Answer ✓

    @Ayoub AFRASS - A zip code level join is required when comparing data at the city level to resolve the issue. This is because if multiple cities share the same name across different states, incorrect behavior may occur without a zip code-level join.

    To address this, a custom zip map layer needs to be created in the DV application.

    For more details on creating zip code-level joins, please refer to the following note:
    OAC Map Incorrect Visualization Data Due to Same City Names in Different USA States (Doc ID 3050094.1).

    Hope this helps!