I got a data source with two columns long and lat, and I would like to indicate to pentaho that those two columns are geographic.

However I can't understand how I'm suppose to do that, if I use the data source editor, I can create a level in the hierarcht that has the geographic type lat/long, and map my own long/lat columns to those properties. The problem is that pentaho want me to assign a column to the geogrphaic attribute itself, but I have no column since I already used lat and long.

Since I think my explanation isn't very clear, here is a picture of my problem : the subLocal level of the hierarchy is declared geographic, but I don't know which column assign to it.

Name:  problem.jpg
Views: 30
Size:  19.0 KB

Any idea ?

Thank you