This class will present the new technologies that were introduced with Oracle9i and 9i Internet Developers Suite (9iDS). These include, analytical functions in the relational database, OLAP Services, 9i Oracle Warehouse Builder (OWB), Java OLAP API, and BI Beans. Attendees will see how to use Oracle9i, OLAP Services, 9i OWB, JDeveloper 9i and BI Beans to build an OLAP aware warehouse and then develop simple and complex applications to view the warehouse data. A comparison between thick and thin client applications will also be discussed. The outline consists of:
The attendees will be shown how to start building OLAP warehouses and developing applications using BI Beans and JDeveloper. A sample datamart will be build and an application will be built to access this data during the class and all attendees will have access to the resulting application code.
Download: This is not available for download. Please contact us if you are interested in this paper.
This presentation will detail the processes and the experiences that Vlamis Software had during the process of developing a commercial BI Application built using JDeveloper 9i and BI Beans. Attendees will see how to use Oracle9i, OLAP Service, JDeveloper 9i and BI Beans to develop simple and complex applications. A comparison between thick and thin client applications will also be discussed. The attendees will be shown how to start developing applications using BI Beans and JDeveloper. An actual application will be presented. The experiences of the development process will be presented along with tips and techniques.
Download: 
Paper
•
Presentation
With the introduction of Oracle9i and BI Beans, the landscape for development of BI applications has changed. This leaves clients with existing Express-based applications asking "How do we move our applications and data?" and "Do we store our OLAP data in RDBMS tables or analytic workspaces?". This presentation will address the issues involved in converting and migrating these types of applications over to the new technology. Case studies will be presented and used throughout the presentation.
Topics Include:
Download:
Paper
•
Presentation
With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i and Oracle9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9iOLAP and how to design and construct an Oracle9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP ready datamart. A complete End-to-End demonstration will be presented.
Download:
Paper
•
Presentation
Are you considering building a business intelligence/data warehousing solution? Are you experiencing integration pain from a "best of breed" solution or a metadata mess? Who has the latest data? What impact will this change have? How can you turn your queries into reports? How do you take advantage of the latest Oracle Database features? This technical session will discuss Oracle's business intelligence components (Warehouse Builder, Discoverer, BI Beans, Reports, and Portal). Incorporated in this "survey" of the Oracle BI stack will be demonstrations of some of these products. It concludes with a review of the advantages of an integrated approach. This information has been updated to include the latest information released at OracleWorld in September on future releases such as Oracle Database 10g and OracleAS Discoverer 10g.
Download:
Presentation
This presentation will produce an actual, completed, OLAP-ready datamart, with a working BI application. It will include the new OWB API and new OLAP migration wizards, with a step-by-step guide addressing implementation and design issues as well as how to use OLAP Service, JDeveloper 9i, and BI Beans to develop simple and complex applications. Tips on the development of a commercial BI Application built using JDeveloper 9i and BI Beans will also be presented.
Download:
Presentation
This presentation will describe the components of Oracle9i LOAP. Armed with information answering "What is an analytic workspace?" and "What metadata is required to support the Java OLAP API and BI Beans?", a designer will be able to design a data warehouse or data mart for use by a business intelligence application. In addition, a manager will understand what options are possible and how to gain maximum value from a data warehouse or data mart.
Download:
Presentation
With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i and Oracle 9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP based datamart. A complete End-to-End demonstration will be presented.
Outline:
Download:
Paper
•
Presentation