OBIEE-apViewer.doc

Oracle BIDW The Leading Database Platform for Business Intelligence Oracle BI and MapViewer Integration Introduction Session Objectives Learn how to integrate BI EE and MapViewer to produce compelling presentations. Understand how to use Oracle BI to develop a model that reflects your complex business requirements Gain a top-level understanding of the openness of Oracle BI when defining and querying spatial data Session Outline TOC \o 2-3 \h \z \u HYPERLINK \l _Toc156347708 Introduction PAGEREF _Toc156347708 \h 2 HYPERLINK \l _Toc156347709 Session Objectives PAGEREF _Toc156347709 \h 2 HYPERLINK \l _Toc156347710 Session Outline PAGEREF _Toc156347710 \h 2 HYPERLINK \l _Toc156347711 Overview of the Data Model PAGEREF _Toc156347711 \h 3 HYPERLINK \l _Toc156347712 Data Model PAGEREF _Toc156347712 \h 3 HYPERLINK \l _Toc156347713 Data Preparation PAGEREF _Toc156347713 \h 3 HYPERLINK \l _Toc156347714 Oracle Analytics and MapViewer Integration PAGEREF _Toc156347714 \h 5 HYPERLINK \l _Toc156347715 Task 1: Configure MapViewer PAGEREF _Toc156347715 \h 5 HYPERLINK \l _Toc156347716 Task 2: Create the Excel System DSN PAGEREF _Toc156347716 \h 14 HYPERLINK \l _Toc156347717 Task 3: Build the Analytics Repository PAGEREF _Toc156347717 \h 17 HYPERLINK \l _Toc156347718 Task 3: Activate the Repository PAGEREF _Toc156347718 \h 41 HYPERLINK \l _Toc156347719 Task 4: Build the Dashboard PAGEREF _Toc156347719 \h 44 HYPERLINK \l _Toc156347720 Oracle BI Pub and MapViewer Integration PAGEREF _Toc156347720 \h 52 Overview of the Data Model Data Model ExcelOracle Spatial Excel Oracle Spatial The data model used to capture expense data is a simple star schema. Data Preparation Describe Excel and Spatial here… Oracle Analytics and MapViewer Integration Task 1: Configure MapViewer Copy Lab Files TBD Update MapViewer Configuration File Access the MapViewer welcome page using the following URL: /mapviewer Click on the “Admin” link (or icon) at the top left of the