1 / 8

Oracle Discoverer Introduction

Oracle Discoverer Introduction. What have we learned so far?. Designer: Star Schema Design. Builder: Populate the data warehouse. ?. It’s Show Time!. Discoverer: a data access tool To help business professionals view the data they want from a data warehouse

Download Presentation

Oracle Discoverer Introduction

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle Discoverer Introduction

  2. What have we learned so far? Designer: Star Schema Design Builder: Populate the data warehouse ?

  3. It’s Show Time! • Discoverer: a data access tool • To help business professionals view the data they want from a data warehouse • To analyze data for supporting business decisions • To create reports to track business performance • Data Access Process

  4. Architecture User Edition Administrator Edition Workbook Workbook Business Area Business Area End User Layer Data Warehouse

  5. Concepts • End User Layer (EUL) • provides an intuitive, business-focused view of the data warehouse • Business Area • a set of folders containing related information with a common business purpose

  6. Concepts (cont.) • Workbook • A collection of worksheets for a specific task • Worksheet • An OLAP report for particular purpose

  7. Administrator Edition • Build and maintain EUL • Build and manage business area • User specific view of data • Create and manage attribute hierarchy for drill up and drill down

  8. User Edition • Use EUL and Business Area to generate • OLAP report • Ad hoc query • Drill up and drill down analysis

More Related