oracle discoverer overview

Upload: venkatesh-vykuntam

Post on 04-Jun-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/13/2019 Oracle Discoverer Overview

    1/11

    Oracle Discoverer - Technical

    Overview

  • 8/13/2019 Oracle Discoverer Overview

    2/11

    Agenda Overview of Oracle Discoverer Business Area

    Comparisons Limitations Administration Demo

  • 8/13/2019 Oracle Discoverer Overview

    3/11

    Oracle Business IntelligenceDiscoverer

    Discoverer is an intuitive ad-hoc query, reporting,analysis, and Web-publishing tool that empowersbusiness users at all levels of the organization to gain

    immediate access to information from data marts, datawarehouses, online transaction processing systems andOracle E-Business Suite.

    The latest release of Oracle Business Intelligence

    Discoverer 10 g offers exciting new functionality,including an integrated reporting and analysis interfacefor relational and multi-dimensional (OLAP) data.

  • 8/13/2019 Oracle Discoverer Overview

    4/11

    Discoverer Overview Databases are designed by information systems professionals whose

    primary goal is often transaction efficiency, not ease of use by people whowant to examine and analyze the data. For example, the database designerusually groups data elements into tables to optimize data capture, but rarelyis that grouping the best for people who want to view and use the data.Often the names of the database tables and their columns are cryptic orconfusing.

    In fact, almost universally, the design of an efficient transaction database isin conflict with the information needs of the people responsible for makingstrategic and day-to-day decisions about topics such as product mix, profitmargins, vendor selection, quality assurance, and work-force resources.Business analysts need a way to access a relatively small amount of data,and usually just a few specific records essential for their decision-making.

    That's where Discoverer comes in. Discoverer lets the businessprofessional find the data he/she needs, analyze it easily, and get answersto support business decisions. Thus, Discoverer provides an efficient way toretrieve a few select records or small amount of specific data from thedatabase.

  • 8/13/2019 Oracle Discoverer Overview

    5/11

    Discoverer operates in a client/server and web browser environmentand has three main components:

    Discoverer Plus, Discoverer 4i Plus and Discoverer 4i Viewer The component for end users comprises the Discoverer Plus(Windows), the Discoverer 4 i Plus and Discoverer Viewer; these

    provide the interface that professionals in your company use on aday-to-day basis to access, view and analyze data.

    Administration Edition This component is for you, the Discoverer administrator; it is the tool

    you use to design and present the subsets of data--called businessareas --that end users access from the Discoverer Plus. End User LayerTM The metalayer that shields end users from the complexity of the

    database. Conceptually, the EUL resides between the databasedictionary/table definitions and Discoverer. Physically, it comprises a

    number of database tables and views.

  • 8/13/2019 Oracle Discoverer Overview

    6/11

    Discoverer Plus Designed for business professionals who do not have a computer programming or database

    background, Discoverer Plus is an easy-to-use read-only data access tool. It provides logical andintuitive access to information from your organization's relational databases for ad hoc query,analysis, and reporting.

    Discoverer 4 i Plus Discoverer 4 i Plus is the internet version of the award-winning Windows product. The two versions

    are compatible; and you can share workbooks between them. Discoverer 4 i Viewer Discoverer 4 i Viewer is designed for viewing workbooks created by users of the Windows or Web

    releases of the Discoverer Plus. Using Oracle Discoverer's easy to use interface via a webbrowser, you can view database data.

    Administration Edition Discoverer Administration Edition builds and maintains the End User Layer. Its design determines

    how users access and view data. This is where administrators define the business areas used byDiscoverer Plus.

    End User Layer (EUL) The End User Layer (EUL) insulates end users from database complexity and constant change. It

    provides an intuitive, business-focused view of the database that can be tailored to suit each useror user group. As such, the EUL lets end users focus on business issues instead, not data accessissues.

    From an operating standpoint, the EUL generates SQL statements on the client andcommunicates with the database using SQL*Net (see Figure 1-1 ). When a user selects objects inthe business area, the EUL generates the appropriate SQL statements that define the selectionsfrom a table, view, or column. When a user executes a query, the EUL executes that SQLstatement and sends it to the database, which in turn sends the results to the Discoverer Plusinterface. Thus, the end user does not have to understand any SQL to access and retrieve data. Itis all handled by the EUL.

    http://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htmhttp://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htmhttp://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htmhttp://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htmhttp://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htmhttp://localhost/var/www/apps/orant/DOC/DISCVR4/admin/overview.htm
  • 8/13/2019 Oracle Discoverer Overview

    7/11

  • 8/13/2019 Oracle Discoverer Overview

    8/11

    What is a Business Area?

    A business area is a set of folders containingrelated information with a common businesspurpose. For example, shows information aboutbudget and revenue stored in a business area

    for the accounting department, while informationabout projects is stored in a business area forproject leaders. Although some of the data thatthese professionals need may be the same,such as the budgets folder, the exactcombination of tables and views for eachdepartment is usually unique.

  • 8/13/2019 Oracle Discoverer Overview

    9/11

  • 8/13/2019 Oracle Discoverer Overview

    10/11

    Using Discoverer Administration Edition, you can tailor the groupingof data to provide users with the proper access to the precise datathey need for ad hoc query, decision support, and presentation of

    results. Business Areas: Meet the specific data needs of the users Usually contain data from several different tables or views Have tables or views and their associated columns mapped to

    "folders" and "items" respectively Can contain many simple folders and complex folders May contain folders from one or more physical databases Include conditions, joins, calculations, formatting, hierarchy

    structures, and other custom features May be accessible to one or many user IDs or roles ; also, a user ID

    or role may be granted access to many business areas Let users access data, without having to understand the database

    structure

  • 8/13/2019 Oracle Discoverer Overview

    11/11