obi 11g-rittmann creating dashboards
TRANSCRIPT
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
1/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Venkatakrishnan Srinivasan, Principal Consultant, Rittman MeadAIOUG Sangam Conference, Bangalore December 2011
Overview of Creating Analyses and Dashboards in OBIEE 11g
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
2/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Introductions
Venkatakrishnan Srinivasan
Principal Consultant, Rittman Mead 12+ Years IT Experience
Experience in BI/DW and CRM
Email: [email protected]
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
3/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Oracle Business Intelligence Enterprise Edition 11g (OBIEE 11g)
Complete Business Intelligence platform from Oracle
Delivers rich analytic and reporting functions for an enterprise by:
a) Collecting up-to-date data from valid sources to ensure single
version of truth,
b) Presenting the collected data in a lucid formats for easyunderstanding, and
c) Delivery of such reports in a timely manner.
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
4/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE Part of Fusion Middleware
Leverages the advantages that Oracle Fusion Middleware offers in terms of
application infrastructure
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
5/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Oracle Business Intelligence Enterprise Edition 11g
Released in July 2010
Current version is 11.1.1.5 Can be downloaded at following link
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
6/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
New Visualization Features in OBIEE 11g
Many new visualization features
Updated user interface that combines all the reporting tools Updated dashboard, catalog, search and home page
Integration with Oracle MapViewer
New KPI and scorecard features
An updated version of BI Publisher
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
7/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Unified Framework
Single UI for Answers, Dashboards, Delivers, BI Publisher
Common menus, controls, menu buttons One-click access to common functions, catalog areas
Requires IE7+, FF3+
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
8/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
9/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
Common Header
Consistent menus and links Search access to catalog Links to administration, help, log off Menus for New .. And Open
Shortcut to Home Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
10/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
11/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
Task-Based Menu
Create/Open catalog objects Browse catalog folders Scoped to user privileges
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
12/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
13/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Home Page
Recent and Popular Catalog Objects
Most recently accessed by you
Most popular amongst your groups
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
14/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Catalog Page
Catalog Folder View
My Folders Shared Folders
Nested view of catalog contents
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
15/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Catalog Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
16/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Catalog Page
Catalog Tasks
Context-SpecificCatalog-wide tasks (Archive etc)
Object-specific tasks (Open, Edit, etc)
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
17/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Catalog Page
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
18/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Catalog Page
Object Listing
Listing of all objects for selected folder,search, etc
Shortcuts to common actions Optional preview of analysis
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
19/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
20/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
Subject Area Folder Listing
Listing of one or more subject areas
Presentation Tables Attribute columns
Hierarchical columns Measure columns
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
21/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
22/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
Catalog Folder Listing
Same listing as on Catalog Place My Folders and Shared Folders
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
23/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
24/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
Criteria Listing
List of all selected columns Edit formulas
Edit column properties Add filters Set sort criteria
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
25/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
26/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Criteria View
Filter Listing
List of filters Save filters
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
27/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Results View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
28/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Results View
Views Listing
List of all available views Add view to analysis, eidt view Moved from previous location above
compound layout
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
29/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Results View
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
30/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Answers - Results View
Result View
Default to compound layout
Preview of the analysis Edit View Add totals, Change layout, etc
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
31/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Dashboard Editor
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
32/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Dashboard Editor
Dashboard Objects Listing
Columns, Sections Alert Section Action Link, Action Link Menu
Link or Image, Embedded Content Text Catalog folder view
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
33/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Dashboard Editor
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
34/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
OBIEE 11g Dashboard Editor
Dashboard Editor
Add and move sections, columns Edit section and column properties Edit analysis Change report links etc
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
35/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
New Answers and Dashboards Features in OBIEE11g
Improved support for OLAP-style reporting
Hierarchical columns
Support for ragged and skip-level hierarchies
Dynamic re-arrangement of pivot tables in the dashboard
New visualizations and dashboard controls
New gauge types and graphics
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
36/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Hierarchical Columns
OBIEE 11g supports concept of "hierarchical columns"
In-column drilling up and down a hierarchy
Regular columns are renamed "attribute columns"
Supports level-based and ragged (parent-child) hierarchies
Works with both relational and
OLAP (Essbase, Oracle OLAP, etc) data sources
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
37/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Master-Detail Linking
Columns can be enabled for Master-Detail Linking
Selecting a column causes master-detail messages to be sent to other views
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
38/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Analyses and Dashboard
Demonstration
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
39/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Key Performance Indicators
KPIs can be defined in the web catalog
Requires measures for actual and target
Thresholds for good, bad etc performance can be set
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
40/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
KPI Watchlists
Users can define watchlists, to monitor their KPIs
Supports collaboration with KPI owner
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
41/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
KPI Scorecards
Arrange KPIs into hierarchies, strategies etc
Define strategy trees, cause-and-effect relationships etc
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
42/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Mapping and Location Intelligence
OBIEE 11g ships with Oracle MapViewer 11g
Used in conjunction with Oracle RDBMS and spatial datasets to add map views
Good way to help visualize geographic/location element of BI dataset
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
43/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Creating a Map View Step 1 : Link Maps to Dataset Columns
Administration task, one-off at system configuration stage
Import maps from Oracle MapViewer and associate theme keys with subject area
columns
Columns then need to be included in the request criteria when map created
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
44/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Creating a Map View Step 2 : Add View to Analysis
Select New View > Map from Answers Results tab
Requires setup in advance (integration with MapViewer, Spatial dataset)
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
45/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Creating a Map View Step 2 : Add View to Analysis
Select New View > Map from Answers Results tab
Requires setup in advance (integration with MapViewer, Spatial dataset)
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
46/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Creating a Map View Step 3 : Select Graphs for Layer Themes
Graphs and other visualizations can be added for individual layers in view
Pie charts, bar charts, variable size bubbles, icon selection etc
Shade polygons based on measure binning/value ranges
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
47/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Creating a Map View Step 4 : Embed in Dashboard, Pan & Zoom
Embed map in dashboard, use as any other view
Link to dashboard prompts, Master-Detail links etc
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
48/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Map Views
Demonstration
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
49/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Summary
OBIEE 11g comes with significant improvements in reporting
Updated version of Answers has better support for OLAP analysis
New task-based UI integrates reporting across product areas
KPIs, Scorecards, Map Views add further functionality to OBIEE
Read more about OBIEE 11g at http://www.rittmanmead.com
Write to us at [email protected] for more details
Thank you for attending!
-
7/30/2019 OBI 11g-Rittmann Creating Dashboards
50/50
T : +44 (0) 8446 697 995 or (888) 631 1410 (USA) E : [email protected] W: www.rittmanmead.com
Venkatakrishnan Srinivasan, Principal Consultant, Rittman MeadAIOUG Sangam Conference, Bangalore 2011
Overview of Creating Analyses and Dashboards in OBIEE 11g