This tutorial covers using Oracle Map Builder and Oracle Map Viewer to build and embed maps for use in Oracle Business Intelligence analyses and dashboards.
Time to Complete
Approximately 90 minutes
In this Oracle by Example (OBE) tutorial you learn how to use Oracle Map Builder to build a map, use Oracle Map Viewer to bring the map online for integration with Oracle Business Intelligence (OBI), and then embed the map into a Map view in an OBI analysis. Please note that this tutorial provides only a basic introduction to Oracle Map Builder and Oracle Map Viewer for the purposes of building a map and then integrating the map into OBI. For more detailed information about Map Builder and Map Viewer, please refer to the Resources section at the end of this OBE.
This tutorial uses a sample map data schema, a pre-built OBI schema, and a pre-built OBI repository. All instructions for accessing and importing the schemas are provided in this tutorial. This tutorial does not provide instructions for uploading the pre-built OBI repository. It is assumed that you know how use Enterprise Manager 11g Fusion Middleware Control to upload an OBI repository. Please note that this tutorial was built using a Windows environment with all required components installed on a single machine. As a result you may need to modify some steps in this tutorial to match your environment. Before starting this tutorial, you should:
- Have access to or have Installed Oracle Business Intelligence 11g.
- Use Enterprise Manager 11g Fusion Middleware Control to upload the OBIEEMAP repository (obieemap.rpd) located here. The repository password is welcome1. Please note that this repository will not be ready for building analyses in OBI Presentation Services until after you complete the first topic in this OBE: Importing Schemas to Your Database.
Importing Schemas to Your Database
To import the required schemas for this OBE into your Oracle database, perform the following steps. In this tutorial you use a Map Viewer demo schema, mvdemo, and an OBI schema, obieemap. All instructions for accessing and importing these schemas are provided in this tutorial.
Creating a Map Viewer Data Source
To create a Map Viewer data source, make sure your Oracle database is up and then perform the following steps.
Installing and Configuring Map Builder
To install and configure Map Builder, perform the following steps:
Creating a Color Style
In this set of steps you use Map Builder to create a color style for rendering the States table. Styles are used to render and label spatial features. Color styles can be used to render area, linear and point features.
Creating a Marker Style
In this set of steps you use Oracle Map Builder to create a marker style for rendering cities. Marker styles can be used to render point features, and to label linear and point features. The base marker can be associated with an image, with a vector representation, or with a true type font.
Creating a Text Style
In this set of steps you use Oracle Map Builder to create two text styles, one for displaying city names and the other for state abbreviations.
Creating a States Theme
In this set of steps you use Oracle Map Builder to create a geometry theme based on the STATES table. A theme is a visual representation of a particular data layer. Typically, a theme is associated with a spatial geometry layer, that is, with a column of type SDO_GEOMETRY in a table or view. In this example, a geometry theme named THEME_STATES is associated with a spatial column named GEOM in the STATES table in the mvdemo schema.
Creating a Cities Theme
In this set of steps you use Oracle Map Builder to create a geometry theme based on the CITIES table.
Creating a Base Map
In this set of steps you use Oracle Map Builder to create a base map. Base map definitions are stored in USER_SDO_MAPS and consist of one or more themes to be used in rendering a map. You use a wizard to create base maps in Map Builder.
Creating a Tile Layer
In this set of steps you use Oracle Map Builder to create a tile layer. A tile layer is a map definition to be used in an Oracle Maps application. Each tile layer is associated with a base map. Please note that the steps for creating a tile layer can also be performed using the Map Viewer Admin interface. However, that method is not presented in this tutorial.
Integrating a Map with OBIEE
In this set of steps you integrate the map you created in Map Builder with Oracle Business Intelligence, so that you can display a map visualization within an OBI analysis. Before beginning this topic make sure you have uploaded the OBIEEMAP repository as described in the Prerequisites section.
Creating an Oracle BI Analysis with a Map View
In this set of steps you create an Oracle BI analysis with a map view.
This tutorial showed you how to use Oracle Map Builder and Oracle Map Viewer to build and embed maps for use in Oracle Business Intelligence analyses and dashboards.
In this tutorial, you have learned how to:
- Use Oracle Map Builder to build maps
- Use Oracle Map Viewer to bring maps online for integration with Oracle Business Intelligence
- Embed a map into a Map view in an Oracle Business Intelligence analysis
Please refer to the following resources for more information about the topics covered in this OBE:
- The mvdemo database schema, Map Viewer installer, and Map Builder installer used for this OBE, as well as additional information about these products, can be found on the Oracle Fusion Middleware Map Viewer web site.
- Oracle by Example - Business Intelligence Enterprise Edition
- Oracle Business Intelligence Documentation
- Oracle Technical Network (OTN) - Oracle Business Intelligence
- Oracle University
- Oracle Learning Library
- Lead Curriculum Developer: Jim Sarokin
To help navigate this Oracle by Example, note the following:
- Hiding Header Buttons:
- Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
- Topic List Button:
- A list of all the topics. Click one of the topics to navigate to that section.
- Expand/Collapse All Topics:
- To show/hide all the detail for all the sections. By default, all topics are collapsed
- Show/Hide All Images:
- To show/hide all the screenshots. By default, all images are displayed.
- To print the content. The content currently displayed or hidden will be printed.
To navigate to a particular section in this tutorial, select the topic from the list.