Docstoc

COLLABORATE 08 — OAUG Forum Pres

Document Sample
COLLABORATE 08 — OAUG Forum Pres Powered By Docstoc
					Oracle Business
Intelligence SIG:
OBIEE Administration


PRESENTED BY:
Kofi Singleton
Senior Principal Consultant


April 2008
Oracle Business Intelligence SIG

•   Introduction
•   Roll Call
•   OBIEE for Dummies, Reference for the Rest of Us
•   A Little Something for the Techies
•   SPIN Control for Project Sponsors
•   Statements of Direction from Oracle
•   Q&A
•   Networking
Introduction

Kofi Singleton                • Supporting Technologies
Sr. Principal Consultant         – Application Server 10.1.3.x
Optimum Solutions                  – Web Center / Webroot
                                   Portlets
                                 – Application Server 10.1.2/4
•OBIEE Implementations
                                   – Portal / JSR-168 via
    –   BI for APPS                WSRP
    –   Standalone OBIEE         – 10.2 DB
    –   Fusion Intelligence      – Informatica / DAC
    –   BI Publisher
                              • Industries
                              • Education
Roll Call

• Group:
   –   Small/Med Business Owners
   –   Technology Evaluators for a larger firm
   –   New to Business Intelligence
   –   New to OBIEE, but experienced in Business Intelligence
   –   I know this better than you do, Kofi!!
• Find a Cohort Group
• Elect a Captain
• Now, What’s your problem?!
OBIEE Overview

• Oracle Business Intelligence…
  –   Server
  –   Dashboard
  –   Answers (ad hoc query and analysis)
  –   Delivers (proactive detection and alerts)
  –   Publisher
  –   Disconnected Analytics
  –   Server Administrator
Something for the Techies

• About…
  –   Architecture & Additional Data Sources
  –   Web Catalog Manager
  –   Administrator and RPD
  –   Plumbing underneath BI for Apps
  –   Informatica ETL & DAC
  –   Security
  –   Oracle Support
  –   Partner Support
BI Apps Architecture
                                                                                  •   Role Based Dashboards
                                                                                  •   Analytic Workflow
                                                        Oracle BI
                       Dashboards by Role               Presentation              •   Guided Navigation
                        Reports, Analysis /
                                                        Services                  •   Security / Visibility
                        Analytic Workflows                                        •   Alerts & Proactive Delivery

                              Metrics / KPIs                                      •   Logical to Physical Abstraction Layer
                   Logical Model / Subject Areas           Oracle BI              •   Calculations and Metrics Definition
                                                           Server
                                                                                  •   Visibility & Personalization
                              Physical Map                                        •   Dynamic SQL Generation
 Administration




                                   Data Warehouse /
                                      Data Model                                  •   Abstracted Data Model
                                                                                  •
                                                                       Metadata
                  Direct                                                              Conformed Dimensions
                  Access to          Load Process
                                                                                  •   Heterogeneous Database support
                                                                 DAC

                  Source
                  Data
                                      Staging Area         ETL                    •   Database specific indexing
                                   Extraction Process
                                                                                  •   Highly Parallel
                                                                                  •   Multistage and Customizable
                                                                                  •   Deployment Modularity
          Oracle       SAP R/3 Siebel PSFT           EDW
                     Federated Data Sources                    Other
Web Catalog Overview
                                                                                 •   Role based dashboards
                                                       Oracle BI                      –   Covering more than 100 roles
                      Dashboards by Role               Presentation              •   Navigation
                                                       Services
                       Reports, Analysis /                                            –   Most reports have at least one level of
                       Analytic Workflows
                                                                                          navigation embedded
                             Metrics / KPIs                                           –   Drill to details from many interactive
                                                                                          elements, e.g. chart segments
                                                          Oracle BI
                  Logical Model / Subject Areas
                                                          Server                 •   Guided Navigation
                             Physical Map                                             –   Conditional navigational links
                                                                                      –
Administration




                                                                                          Analytic Workflows
                                  Data Warehouse /
                                     Data Model                                  •   Action Links
                                                                                      –
                                                                      Metadata
                 Direct                                                                   Direct navigation from record to
                 Access to          Load Process
                                                                                          transactional while maintaining context
                                                                DAC

                 Source
                                     Staging Area         ETL
                 Data                                                            •   Alerts
                                  Extraction Process                                  –   Scheduled and Conditional iBots
                                                                                 •   Highlighting
                                                                                      –   Conditional highlighting that provides
         Oracle       SAP R/3 Siebel PSFT           EDW
                                                                                          context on metrics (is it good or bad?)
                    Federated Data Sources                    Other
OBI EE Vs OBI Apps Admin
Oracle Business Intelligence Enterprise Edition




Oracle Business Intelligence Applications –Prebuilt Metadata




      9
Physical to Business Model
Business Model to Presentation
OBI Apps – Plumbing
Inventory Compound Metrics- Inventory Turns Ex.




         12
OBI Apps – Plumbing
OBI Apps – Plumbing
Informatica Repository Console
DW Application Console (DAC)
DW Application Console (DAC)
•   DAC is a metadata driven administration and deployment tool for ETL and data
    warehouse objects
•   Used by warehouse developers and ETL Administrator
•   Warehouse Deployment
•   Application Configuration
     –   Manages metadata-driven task dependencies and relationships
     –   Allows creating custom ETL execution plans
     –   Allows for dry-run development and testing
•   Execution
     –   Enables parallel loading for high performance ETL
     –   Facilitates in index management and database stats
     –   Automates change capture for Siebel OLTP
     –   Assists in capturing deleted records
     –   Fine grain restartability
•   Monitoring
     –   Enables remote admin and monitoring
     –   Provides runtime metadata validation checks
     –   Provides in-context documentation
Informatica & DAC
Extraction
                                                                       Extract




                                                             PLP
             Oracle Data                                                 • Source-specific and Universal
             Warehouse
                                                                            Business Adapters
                                                                         • Expose simplified business entities
                                                                            from complex source systems



                                                             Load
  Source Independent Layer                                               • Converts source-specific data to
                                                                            universal staging table format
                                                                         • Lightweight and designed for
   Universal Staging Tables                                                 performance, parallelism
                                                                         • Extensible

                   Extract
                                                             Extract




                     Power         Power
                    Connect       Connect
  SQL



           SQL




                                                      SQL
                                    App Layer ABAP
                      SQL
                      App Layer




 Siebel
          Oracle                                     Other
 OLTP

                 PeopleSoft SAP
Load
                                                                       Source Independent Layer




                                                             PLP
             Oracle Data                                                 • Encapsulates warehouse load logic
             Warehouse
                                                                         • Handles:
                                                                              • Slowly changing dimensions
                                                                              • Key lookup resolution /



                                                             Load
  Source Independent Layer                                                       surrogate key generation
                                                                              • Insert/update strategies
                                                                              • Currency conversion
   Universal Staging Tables                                                   • Data consolidation
                                                                         • Uses Bulk Loaders on all db
                                                                           platforms
                   Extract
                                                             Extract




                     Power         Power
                    Connect       Connect
  SQL



           SQL




                                                      SQL
                                    App Layer ABAP
                      SQL
                      App Layer




 Siebel
          Oracle                                     Other
 OLTP

                 PeopleSoft SAP
Security
                                                                              Object
• Object Security                                                            Security


  What parts of the application can you see?
   – Business Logic Object Security                     Presentation Level
       • Controls access to Subject Areas,
                                                         Business Level
         Tables and Columns
       • EBS to OBIEE Responsibility Mapping              Physical Level

   – Web Object Security
       • Limits access to Dashboards, Reports
         and Web Folders
   – Query Blocking
       • Specified combinations of columns in queries
         can be blocked from running and the user is
         notified of the illegal query
Oracle Statement of Direction
• Informatica and Oracle Data Integrator (formerly Sunopsis)
  to be supported
• Informatica PowerCenter
   – OEM distribution extended together with full support for existing
     customer, including new Informatica versions
   – Informatica use: any sources, any extension of BI Applications,
     must be used to target BI Applications
• Oracle Data Integrator (ODI)
   – Plan to offer as alternative to Informatica
• Full ongoing support for both Informatica and ODI
• DAC to support both Informatica and ODI
Spin Control for Project Sponsors

• Why OBIEE?
• Tell me about Total Cost of Ownership
• Just how long does this take?
• How do I get started? Strategic Roadmap
• Just how technical does my team need to be?
• How can I involve executives and business users?
• Is there anyone who can help? Part-Time? Full-
  Time?
• Is there a set Methodology for accomplishing this?
Questions &
     Answers
Optimum Session Presentations
Be sure to add these sessions to your conference schedule:

E-Business:                 PeopleSoft:                  Demantra:
Replacing Ariba:            PeopleSoft Enterprise HCM:   The Logical Next Step to
Industry-leading Online     What's New in HCM 9.0?       Improving Your Forecast
Brokerage Firm Implements                                Accuracy Using Demantra
an Oracle Procurement       Mon., April 14, 2008
Solution                    8:00am - 9:00am              Tue., April 15, 2008
                            Room 301                     11:00am - 12:00pm
Wed., April 16, 2008                                     Room 302
8:30am - 9:30am
Room 403                    Customer Case Study:
                            Worldwide Benefits Using     Implementing Demantra
                            PeopleSoft HCM 9.0           in the Mid-Market Space:
                                                         The Springs Creative
                            Tue., April 15, 2008         Success Story
                            1:45pm - 2:45pm
                            Room 111                     Wed., April 16, 2008
                                                         8:30am - 9:30am
                                                         Room 106
   Contact Information



     “Quite simply, Optimum
is the best ERP implementer
                                  Kofi Singleton
         in the marketplace.”
                                  Senior Principal Consultant
              — G. Abatjoglou
            CFO, ChartOne, Inc.   Session ID: 3645
                                  kofi_singleton@optimumsolutions.com
                                  415.362.8200 ext 8071 or
                                  888-229-5707 ext 8071
Thank You

				
DOCUMENT INFO