Skip to Content
0

Webintelligence longitude and lattitude data format

Jun 20, 2017 at 07:01 AM

62

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vidhya V Jun 20, 2017 at 07:23 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mikel Makmerphy Jun 20, 2017 at 12:01 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Mikel Makmerphy Jun 20, 2017 at 12:02 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Mikel Makmerphy Jun 20, 2017 at 01:06 PM
0

Solved, Note 2482462

Share
10 |10000 characters needed characters left characters exceeded