Oracle Analytics Cloud and Server

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

How to draw latitude and longitude coordinates in OBIEE 12c Standard Edition

Question
1
Views
0
Comments
3669710
3669710 Rank 1 - Community Starter

We need to paint latitude and longitude points in OBIEE 12c Standard Edition. We've stored these points in the database Oracle 12c as number data type and SDO_GEOMETRY enabled by Oracle Spatial:

pastedImage_0.png

We have OBIEE 12.2.1.3.0 and It doesn't  have enabled the access to embebed HTML, reason which We had to use Mapviewer to draw that points. We created styles, theme and base map in Map Builder:

pastedImage_1.png

Now we need to integrate it in OBIEE, but we import the column SDO_GEOMETRY in the RPD the data type shows as UNKNOWN:

pastedImage_2.png

Hence, we need to know how to draw SDO_GEOMETRY columns in OBIEE 12c Standard Edition or if possible draw the numeric columns (contains latitude and longitude) without use HTML.

Thanks in advance.