Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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
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:

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:

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

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.
0