This is a finishing post in the series about using the OpenStreetMap data with OBIEE 12c. Actually, I have a few more ideas, but they aren't for a short term perspective. This post describes how to setup OBIEE 12c (but this information is also applicable to 11g) and some map tweaks as well.
Let's start with OBIEE part. Log in to http://yourserver:9502/analytics (9502 - default port).
Navigate to Admistration/Manage Map Data
Now we need to create some layers to display data and define which tile layers should be used to expose them. Go to Layers tab and click Create button. It is in the top right corner.
Here we can see all layers from the database that is used by MapViewer. I select FEDERAL_LAND and press OK.
New layer is created, but it is not mapped to any subject area. To do it, select the layer and click Modify button.
Here goes one issue. As you can see on the screenshot, Layer Key drop-down list is empty. That is because when I created layers in the MapBuilder, I changed only properties relevant to map presentation, and left untouched all other. And I did it for a purpose. This issue is very typical, and I want to illustrate it and show how to correct it, instead of magical "everything works by itself".
The root of this issue is the absence of an identifying attribute that would allow OBIEE to create a connection between data and relevant map element (Federal land in my case). OBIEE should somehow understand that if the data is 100 for Bavaria, and 150 for Hamburg, it should change a colour of two particular polygons but not the others. In order to achieve it, we need to use Oracle Map Builder tool.
Open Map builder, open the layer for edit and go to Advanced tab. Click Edit button.
Add new info column.
Select NAME column and give it some name. This will allow me to create a link between NAME column and Federal land name attribute of a subject area. I could add more info columns here, for example for some code or short name and so on.
It is possible that even after this you will still get empty drop-down list. In this case, go to MapViewer interface and purge theme as shown on the screenshot.
Now I can see my info column as a layer key in the drop-down list. And it means I can add some subject areas to be used with this layer.
I created a simple subject area for this demonstration.
I should select a field from my subject area which corresponds to the layer key.
You can add multiple subject areas to one layer.
Next step is to add a base map. Press Add button.
Select one of the tile layers.
It's likely that I can create map reports right now. But I prefer to check if my layers are added to the base map. For this I select the base map and click Edit.
Interactive BI Layers and Feature Layers shows that FEDERAL_LAND layer is added to this base map and visible at all zoom levels.
I can create many base maps with different settings. For example a world base map for countries data, and a country base map for national data and so on.
A simple report for checking if everything is OK.
OBIEE specialist since 2007 and Oracle Discoverer before. DWH architect, BI enthusiast, blogger. Lazy cats owner. All opinions are my own and not the views of my employer.