obiee 11g - overview of mapping capability
DESCRIPTION
Obiee 11g - Overview of Mapping CapabilityTRANSCRIPT
-
Peak Indicators Limited
Oracle Business Intelligence 11g Overview of Mapping Capability
Antony Heljula
Technical Architect
-
Peak Indicators Limited 2
Agenda
Overview of Mapping Capability
Spatial Interactions
Oracle Spatial Architecture
NAVTEQ Digital Maps
Administering Maps in OBIEE
-
Peak Indicators Limited 3
Overview of Mapping Capability
The ability to embed maps in to Oracle BI Dashboards is an exciting new development for OBIEE 11g
Report developers have the power to build colourful and interactive maps within their BI Dashboards.no coding or technical know-how required!
-
Peak Indicators Limited 4
Overview of Mapping Capability
Oracle MapViewer is a java application used to render maps on behalf of other applications
Oracle MapViewer is installed as part of the standard OBIEE 11g installation
It is deployed onto WebLogic. Default URL http://[biserver]:9704/mapviewer
No extra licenses required for OBIEE customers to render maps
Oracle MapViewer
-
Peak Indicators Limited 5
Overview of Mapping Capability
Create an Analysis within Answers as you normally would
Then just add a Map view to the Analysis
You just need to make sure at least one of the columns can be rendered on a map!
In this example, each Organization Name corresponds to a geographical country and this has been configured for display on a Map by the OBIEE administrator
Creating Maps is Easy!
-
Peak Indicators Limited 6
Overview of Mapping Capability
Types of Layer
Colour Fill Bar Graph Pie Graph
Bubble Variable Shape Image
-
Peak Indicators Limited 7
Overview of Mapping Capability
The user can choose which layers to display on the map
Enabling/Disabling Layers
Turn off a layer simply by
unchecking the corresponding
check-box
-
Peak Indicators Limited 8
Overview of Mapping Capability
Custom Point Layers are where the co-ordinates are taken from the Analysis itself
Mapping coordinates can come from any type of data source!
Longitude/Latitude co-ordinates can be provided in a single column or separate columns
Supported with Bubble, Variable Shape and Image layers
Custom Point Layers
-
Peak Indicators Limited 9
Overview of Mapping Capability
It is possible to interact with Maps just like you can with other any other OBIEE chart
Just click on the area that is of interest
Interaction
Action Link to open up a different analysis
Drill-Down to a lower hierarchy level
-
Peak Indicators Limited 10
Overview of Mapping Capability
OBIEE 11g does support download and print options for Maps:
Printing and Downloading
Powerpoint PDF
-
Peak Indicators Limited 11
Spatial Interactions
-
Peak Indicators Limited 12
Spatial Interactions
One of the key benefits that comes with OBIEE 11gs mapping capability is the ability to interact with the maps just like they were standard Table/Chart views
-
Peak Indicators Limited 13
Spatial Interactions
When you click on the map, an info window will appear displaying information about the polygon/point you just clicked on
you can configure this info window to display extra columns
Info Window
-
Peak Indicators Limited 14
Spatial Interactions
By default, you will get the same default Drill-Down interactions as you get with any other Table/Chart
If you click on Business Group then you will drill-down just as if you clicked on the Business Group column heading on the table underneath the map
You should see all Organizations being returned
Drill-Downs : Heading
-
Peak Indicators Limited 15
Spatial Interactions
By clicking on the Business Group link we get a new map showing data by all the child Organizations
Note how the Table underneath the map has also changed to list data for all Organizations
Drill-Downs : Heading
-
Peak Indicators Limited 16
Spatial Interactions
Now this time we shall instead click on Vision Nordics
We should drill-down just as if had clicked on the Vision Nordics value in the table underneath the map
You should see all Organizations being returned for Vision Nordics
Drill-Downs : Value
-
Peak Indicators Limited 17
Spatial Interactions
And heres the result! We get a new map showing just the Organizations for Vision Nordics
NOTE:
The map zoomed in automatically!
Drill-Downs : Value
-
Peak Indicators Limited 18
Spatial Interactions
Master-Detail linking works even from maps as well!
Master-Detail Linking
Clicking on the map will initiate a Master-Detail
event to change the data displayed in the Graph
-
Peak Indicators Limited 19
Spatial Interactions
It is also possible to set up Action Links for your maps for navigation between dashboards/analyses:
Action Links
-
Peak Indicators Limited 20
Oracle Spatial Architecture
-
Peak Indicators Limited 21
Oracle Spatial Architecture
An Oracle Spatial Architecture will typically consist of the following components: Oracle Database
Stores the definitions of spatial objects (using special geometry data types)
Locator database option for querying, filtering, joining spatial data
Spatial database option for manipulating and aggregating spatial data
Oracle MapViewer A J2EE application used for rendering interactive map images and features-of-
interest (FOI)
Invoked via a series of XML, Java, PL/SQL and Javascript APIs
Provides a layer of caching
Oracle MapBuilder The development tool for MapViewer
A graphical Map builder tool that enables you to define the content and structure of maps and their rendering rules
-
Peak Indicators Limited 22
Oracle Spatial Architecture with OBIEE
Base Map + Layer
IMPORTANT NOTE: With OBIEE 11g (release 11.1.1.5) the External Map Provider can source external base maps from Oracle eLocation, Web Map Services, Google Maps and Bing Maps
-
Peak Indicators Limited 23
Oracle Spatial Architecture
The Management screens allow you to perform administrative tasks such as :
Configure MapViewer server
Configure Map Tiles
Configure data sources
Clear geometry caches
MapViewer
-
Peak Indicators Limited 24
Oracle Spatial Architecture
MapBuilder
-
Peak Indicators Limited 25
Oracle Spatial Architecture
Each schema on the database has a set of system views to contain the 4 areas of metadata used by MapBuilder/MapViewer:
USER_SDO_STYLES
USER_SDO_THEMES
USER_SDO_MAPS
USER_SDO_CACHED_MAPS
Metadata
-
Peak Indicators Limited 26
NAVTEQ Digial Maps
-
Peak Indicators Limited 27
NAVTEQ Digital Maps
One method of rendering maps within OBIEE 11g is to have all your spatial data stored in an Oracle Database
Spatial data is stored in the Oracle Database using a special spatial data type called SDO_GEOMETRY As an example, If you want to render Country boundaries you will have a table that
stores the geometries for each Country
This map will consist of many different sets of geometries all layered on top of each other: Country Boundaries
Ocean Boundaries
City Locations
Highways
State Boundaries
Lakes
etc
-
Peak Indicators Limited 28
Maps
NAVTEQ Sample Maps
NAVTEQ sample map data is available for download (with install instructions) from OTN:
http://www.oracle.com/technology/software/products/mapviewer/index.html
Data provided goes down to postcode level in 3 locations: London
San Francisco
Sydney
Maps covering further detail can be purchased directly from NAVTEQ
Digital map data is approx 300MB in size
-
Peak Indicators Limited 29
Administering Maps in OBIEE
-
Peak Indicators Limited 30
Administering Maps in OBIEE
The OBIEE 11g Administration screen contains a new option that allows you to configure your map data:
Manage Map Data
-
Peak Indicators Limited 31
Administering Maps in OBIEE
First of all, you define one or more Layers that can be rendered on top of a map. Layers can be either:
Points
Polygons
In order to use maps with OBIEE, you must have at least one Layer
Layers
Import / Delete / Edit Layer options
-
Peak Indicators Limited 32
Administering Maps in OBIEE
When you choose to import a new Layer, OBIEE will obtain the Layers that exist within the data source you choose
The Layers listed correspond to the Themes you defined in MapBuilder which are stored in the table USER_SDO_THEMES
Importing Layers
-
Peak Indicators Limited 33
Administering Maps in OBIEE
Once the Layer is imported, you can edit configure it for use with OBIEE:
Specify Geometry Type (Either Point or Polygon)
Specify which Subject Area columns can be used for this layer (i.e. which columns can be used to join to the spatial data)
Edit Layer
In this example, the Layer is keyed on ORGANIZATION.
This means we can
link it to the Organization Name
column in three Subject Areas:
Sales Forecast Sales Orders
Service Incidents
-
Peak Indicators Limited 34
Administering Maps in OBIEE
Once your Layers have been defined, you can import Background Maps and then configure which Layers can use them:
Background Maps
Import / Delete / Edit Background Maps
-
Peak Indicators Limited 35
Administering Maps in OBIEE
When you choose to import a new Background Map, OBIEE will obtain the Map Tile Layers that exist within the data source you choose
The maps listed correspond to the same Map Tiles which are defined in MapViewer, and are stored in the database table USER_SDO_CACHED_MAPS
Importing Background Maps
-
Peak Indicators Limited 36
Administering Maps in OBIEE
Once the Background Maps is imported, you can edit configure it for use with OBIEE:
Specify which Layers can use the map, and at which zoom levels
Configure the order in which the Layers appear on top of each other on a map
Edit Background Maps
This Background Map has 3 Layers, with OBIEE_CUSTOMERS displayed
on top of the others
-
Peak Indicators Limited 37
Administering Maps in OBIEE
You can import your own custom Images for use on your maps
When you choose to import an image, the images listed correspond to the images defined within MapBuilder and are stored in the database table USER_SDO_STYLES
Images
-
Peak Indicators Limited
Helping Your Business Intelligence Journey