Chris Claterbos and Dan Vlamis
This class will present the technologies that were introduced with Oracle 9i/10g 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 Oracle 9i, 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 attendees will be shown how to start building OLAP warehouses and developing applications using BI Beans and JDeveloper. A sample datamart will be built and an application will be built to access this data during the class. 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.
Chris Claterbos
When building business intelligence applications data is important, but the key piece is making the data easily accessible so that the end-user can use it to improve upon the business. This session explains how developers can take advantage of their existing J2EE and data warehouse servers as a platform to create extremely powerful interactive business intelligence applications, which can be used for guided analyses by management. Attendees will see how to use Oracle 9i, OLAP Service, JDeveloper 9i and BI Beans to build a powerful forecasting and what-if analysis application. An actual application will be presented. The experiences of the development process will be presented along with tips and techniques.
Download: 
Paper
•
Presentation
Dan Vlamis
Discoverer release 10g uses BI Beans to present Oracle OLAP data. It gets its power from BI Beans. How does this strategy give Discoverer users the flexibility to analyze OLAP data? What features does this expose to the users over what has been available previously? Custom applications that use BI Beans have many of the capabilities that are in the Discoverer 10g application. When would you want to use Discoverer and when would you want to code an application directly in BI Beans? This presentation will contrast Discoverer 10g with custom-built BI Beans applications and discuss why you should consider these products.
Download:
Paper
•
Presentation
Dan Vlamis
The Oracle OLAP Spreadsheet Add-In provides access to Oracle OLAP data from within Microsoft Excel. This presentation will demonstrate how this add-in can provide users access to very powerful analytics within an application they are already comfortable using.
Download:
Presentation
Chris Claterbos
In Oracle9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. Physically, data can be stored in relational tables, or in Analytic Workspaces (multidimensional storage). Analytic Workspaces make possible all sorts of interesting business intelligence applications, such as collaborative budgeting, collaborative forecasting, predictive analysis, and modeling applications. All of this is now available within the Oracle9i database. With this new freedom comes new challenges in managing these tables and analytic workspaces. How are AWs updated? What is the best storage location for your data? When should the OLAP option be used? What are the major new capabilities in Oracle OLAP 10g and how does this affect the design of a data warehouse? We will discuss exactly that these mysterious Analytic Workspaces are. We will also present best practices and strategies pulled from a decade of experience with these analytic workspaces in their former life, as Express databases as well as multiple projects involving analytic workspaces. Attendees will see how Oracle tools such as Oracle Warehouse Builder, Oracle Enterprise Manager, Analytic Workspace Manager, and OLAP Worksheet can be used to manage the Oracle OLAP environment.
Download: This is not available for download. Please contact us if you are interested in this paper.
Dan Vlamis
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 Oracle9i OLAP 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 based datamart. A complete End-to-End demonstration will be presented.
Download:
Presentation
•
Oracle Enterprise Manager Viewlet
•
Oracle Warehouse Builder Viewlet
Dan Vlamis
This presentation will produce an actual, completed, OLAP-ready datamart, with a working BI application. It will address the steps necessary and options in building a Oracle OLAP cubes, including using Oracle Warehouse Builder, Oracle Enterprise Manager, and Analytic Workspace Manager. It will then move into developing simple and complex applications using JDeveloper, and BI Beans. Tips on the development of a commercial BI Application built using JDeveloper and BI Beans will also be presented.
Download:
Presentation
Dan Vlamis
This presentation will describe the components of Oracle OLAP. Armed with information answering the questions "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. In a live demonstration, we will show how Discoverer for OLAP or another BI application can use Oracle OLAP to answer real business questions.
Download:
Presentation
Dan Vlamis
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 presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, 9i Internet Developers Suite (9iDS), and OracleAS Discoverer 10g. These include:
The attendees will be shown how to start building OLAP warehouses and how to develop simple and complex applications using BI Beans and JDeveloper. A sample datamart will be built and an application will be shown that accesses this data during the presentation. A comparison between thick and thin client applications will also be discussed.
It concludes with a review of the advantages of an integrated approach.
Download:
Presentation
Dan Vlamis
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 presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, Oracle Developer Suite, and OracleAS Discoverer 10g. These include:
It concludes with a review of the advantages of an integrated approach.
Download:
Presentation
Dan Vlamis
Discoverer release 10g uses BI Beans to present Oracle OLAP data. It gets its power from BI Beans. How does this strategy give Discoverer users the flexibility to analyze OLAP data? What features does this expose to the users over what has been available previously? Custom applications that use BI Beans have many of the capabilities that are in the Discoverer 10g application. When would you want to use Discoverer and when would you want to code an application directly in BI Beans? This presentation will contrast Discoverer 10g with custom-built BI Beans applications and discuss why you should consider these products.
Presented through: IOUG
Download:
Paper •
Presentation
Chris Claterbos
When building business intelligence applications data is important, but the key piece is making the data easily accessible so that the end-user can use it to improve upon the business. This session explains how developers can take advantage of their existing J2EE and data warehouse servers as a platform to create extremely powerful interactive business intelligence applications, which can be used for guided analyses by management. Attendees will see how to use Oracle 9i, OLAP Service, JDeveloper 9i and BI Beans to build a powerful forecasting and what-if analysis application. An actual application will be presented. The experiences of the development process will be presented along with tips and techniques.
Presented through: IOUG
Download:
Paper •
Presentation
Cahtye Pendley
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 presentation will discuss the latest technologies for building business intelligence and data warehousing systems introduced with Oracle 9i/10g, Oracle Developer Suite, and OracleAS Discoverer 10g. These include:
It concludes with a review of the advantages of an integrated approach
Presented through: ODTUG
Download:
Presentation