Scribd Logo
Upload

Welcome to Scribd!

  • 253 views

    Al Kannan - OBIEE Implementation With EBS

    Uploaded by

    rafiansari20021988
    The document provides an overview of a simple Oracle Business Intelligence implementation using Oracle E-Business as the data source. It discusses the objectives of introducing OBIEE, an overview of the architecture including components like the presentation services, server, and data sources. It also demonstrates the repository creation process and provides examples of simple and star schema-based reports that can be created in OBIEE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Al Kannan - OBIEE Implementation With EBS

    Uploaded by

    rafiansari20021988
    253 views103 pages
    The document provides an overview of a simple Oracle Business Intelligence implementation using Oracle E-Business as the data source. It discusses the objectives of introducing OBIEE, an overview of the architecture including components like the presentation services, server, and data sources. It also demonstrates the repository creation process and provides examples of simple and star schema-based reports that can be created in OBIEE.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides an overview of a simple Oracle Business Intelligence implementation using Oracle E-Business as the data source. It discusses the objectives of introducing OBIEE, an overview of the architecture including components like the presentation services, server, and data sources. It also demonstrates the repository creation process and provides examples of simple and star schema-based reports that can be created in OBIEE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    253 views103 pages

    Al Kannan - OBIEE Implementation With EBS

    Uploaded by

    rafiansari20021988
    The document provides an overview of a simple Oracle Business Intelligence implementation using Oracle E-Business as the data source. It discusses the objectives of introducing OBIEE, an overview of the architecture including components like the presentation services, server, and data sources. It also demonstrates the repository creation process and provides examples of simple and star schema-based reports that can be created in OBIEE.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 103

    Overview of a simple Implementation with Oracle E-Business as the Data Source

    ,
    Feb 27th 2009 Presented by Al Kannan
    Discussion Outline

     Objectives & Audience


     Introduction to OBIEE
     Architecture
     Installation
     Repository Creation
     Simple Report Example
     Star Schema Report Example
     Next Steps
    Q&A
    Objectives & Audience

    Objectives
    • Introduction to OBIEE
    • Installation Basics
    • Demonstrate a simple repository creation
    • Demonstrate OBIEE Answer Requests and Dashboards

    Audience
    • Oracle Reports Developers with no OBIEE exposure
    • Oracle Discoverer Administrators and Developers with no OBIEE exposure
    • Traditional Oracle Report Users
    Introduction to OBIEE

    • It is a query tool

    • Unlike simple reporting tool, it allows users to carryout Analysis

    • It has far more rich features than Discoverer

    • It is completely web based design

    • It has an impressive common sense, intuitive user interface, very easy to learn

    • It came with Siebel acquisition, Siebel got it from nQuire Software in 2001, it was
    designed to be database/Applications vendor independent

    • It is a myth to assume OBIEE can improve performance, improving performance


    depends on optimal Data Source Schema design and accurate Metadata setup in the
    repository
    Architecture

    • Clients
    – Oracle BI Answers to build Requests (Reports)
    – BI Dashboards to Display results of the Answers Requests
    – BI Administration Tool to build repository
    • Oracle BI Presentation Services
    – Renders pages
    – Extension to Web Server
    – Users a catalog folder to store user content
    – Acts as an intermediary, receives data from Oracle BI server and provides it to
    the client
    • Oracle BI Server
    – Uses the RPD file (metadata) to form dynamic SQL
    – It can connect natively (Oracle OCI) or through ODBC to the RDBMS
    – It Structures the results set
    • Data Sources
    – Relational Database, OLAP databases, Flat Files, Spreadsheets, XML files
    Some of the Other Components

    • Oracle BI Scheduler
    – Just like Concurrent Manager, it schedules Answers Requests, Scripts,
    Alerts
    • Oracle BI Delivers
    – Few Web pages that allows us create alerts based on Answers
    Requests
    – IBOTS (OBIEE provides few web pages that allows us to create alert
    setups)
    – It works with the Scheduled
    • BI Administration tool to manage Analytics Metadata RPD files
    – (Windows Based only)
    Sample Request Processing

    1. Users views a dashboard or submits a request via


    Answers
    2. Oracle BI Presentation Services makes a request to
    Oracle BI Server to retrieve the requested data
    3. Using the repository file, Oracle BI Server optimizes
    functions to request the data from the data sources
    4. Oracle BI Server receives the data from the data
    sources and processes as necessary
    5. Oracle BI Server passes the data to Oracle BI
    Presentation Services
    6. Oracle BI Presentation Services formats the data and
    sends it to the client
    Install Options

    • It can run on both Windows and Linux

    • You can deploy all server based components in one server or in multiple
    servers (with cluster configurations)

    • Basic Install does not require a separate Applications Server, Advanced


    Install do.

    • Basic Install is available only on Windows and it is very easy to install

    • There are some tools such as BI Administration Tool that are windows
    based only
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Installation
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    Report Development Process
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    OBIEE REPORT CREATION
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    STAR Schema Report
    Next Steps

    You might also like