Skip to Content

Webintelligence longitude and lattitude data format

Hello

We try to implement geography reporting in POC project, but have hit the stumbling block with data format. We do not want to create chart based on City / Region name , but we have defined all cities and places as Dimension Attribute string , here is an extract. But Webintelligence do not recognize last 2 columns as longitude/latitude.

STATION0606Customer55.498498

28.573246

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 20, 2017 at 07:23 AM

    Hi Mister,

    Try to bring last two columns(longitude/latitude) under city dimension. I mean to say, create the detail dimension for city and then pull the two columns.

    Please share me any screens shots to proceed futher.

    Regards,

    Vidhya.C

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 12:01 PM

    The same nothing changes, we have varchar(255) in DB for these 2 columns and both are defined as longitude/latitude attributes for City. I cannot choose these objects as Longitude/latitude from the list, nothing is being shown there in drop-down list

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 12:02 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2017 at 01:06 PM

    Solved, Note 2482462

    Add comment
    10|10000 characters needed characters exceeded