Presentations - 2001

You must have an Adobe Acrobat compatible reader installed to view our presentations. If you would like to have a copy of a paper or presentation we have given that has not yet been posted, please send an e-mail to papers@vlamis.com with the name of the conference and the year you need. Links to presentations will open in a new window.

AppsWorld 2001

 

OSA Catalogs and Properties: How does it all fit together?

Presented by David Fuston

Abstract not available.

Picking and Oracle Applications ASP: An IT Manager's Perspective

Presented by David Fuston

Abstract not available.

Structures & Catalogs: How Does Oracle Financial Analyzer Really Work?

Presented by David Fuston

Abstract not available.

IOUG Live! 2001

 

Business Intelligence Portals and Oracle Portal

Presented by Elizabeth Reardon

The presentation covers the Oracle business intelligence tools using an Oracle Portal 3.0 portal to publish and query Web site activities, explore and analyze customer behaviors, analyze trends and forecast. The entire e-business capabilities of advanced analysis (Express), enterprise reporting (Reports) and ad hoc query (Discoverer) are shown on a single integrated and comprehensive Web portal. Oracle Portal improvements over WebDB 2.2 is highlighted along with how to integrate both Oracle (Express, Reports, Discoverer) and non-Oracle applications for personalized content and controlled access. Ease of use is addressed by covering pre-packaged site templates, pre-built components and built-in services along with both Java and PL/SQL access.

Optimizing Oracle 8i for Business Intelligence

Presented by David Fuston

This presentation covers the DBA tools and techniques used in optimizing Oracle 8i relational database for business intelligence users. The background topics covered include star schema, creation and population of data mart, Express cubes design and development, as well as the differences in MOLAP, ROLAP and HOLAP performance. There is coverage of three different objectives: minimizing space required to build cubes, minimizing cube processing times and getting the best query execution times. Using sample queries, the session then shows examples of performance improvements from two real world data marts. BI optimization tips for both relational and multi-dimensional servers are summarized. Demonstration of both the Express RAA query statistics GUI provided with Express server and the Oracle 8i analyze statistics command are used.

OLAP Applications, BI Beans, and Java OLAP API

Presented by Chris Claterbos

Each attendee learns the components of an OLAP-ready RDBMS application. Using a broad brush, this session discusses the OLAP-ready relational models, analytically enabled SQL, relational OLAP performance and object-based API utilized by BIBeans. Then, it looks at how one can achieve the goal of "everything in 4GL that can be done declaratively can be manufactured in SQL statements." Samples of windowing functions, ranking functions, lag/lead functions and reporting functions are shown, along with Java class libraries, dimensional cursors, SQL generation and complex calculations. The end result is to show the framework for how one can achieve an integrated OLAP application using the new features supported in 9i and related technologies.

Oracle's SQL Analytic Functions in 8i and 9i

Presented by David Fuston

Oracle8i Release 1 added support for the CUBE and ROLLUP extensions to the SELECT statement's GROUP BY clause. Oracle8i Release 2 introduced a powerful group of SQL functions supporting business intelligence queries. These functions enable ranking, moving and cumulative aggregates, lead and lag and more. Along with the analytic functions, Oracle8i Release 2 also supports efficient multi-dimensional aggregations. These analytic functions and multi-dimensional aggregation features are a foundation for extending Oracle's analytic capabilities. Oracle 9i beta enhances this foundation and expands its functional use to include list partitioning, bitmap join indexes, OLAP server, new families of analytic functions and important extensions for the GROUP BY clause. This session reviews Oracle's SQL analytic functions, multi-dimensional aggregations and partitioning. Business examples are presented along with methods to utilize these potent enhancements.

Oracle 9i OLAP Services and Express--What Now?

Presented by Dan Vlamis

Oracle 9i OLAP services represents a radical change in the way OLAP applications are designed and built. No longer is the administration of an Express database separate from the star schema relational data warehouse. Oracle 9i OLAP services allow you to administer your multidimensional data with relational tools --because the data is truly stored in the relational database.

Come learn what Oracle 9i OLAP Services can do and how it compares to the 6.x Express environment. What does the new language look like? What can be done and what can't be done? What happens to legacy Express applications? What concepts carry over to the new environment and what don't? And what totally new design concepts are introduced? Oracle 9i totally changes the way Oracle OLAP applications are built.

University Class - How to Develop Applications with BI Beans and Jdeveloper

Presented by Chris Claterbos

This class presents the new technologies that will be introduced with Oracle 9i. These include analytical functions in the relational database, OLAP services, Java OLAP API, and BI Beans. The course is based upon a book that will be released by Chris Claterbos after the release of 9i. The outline consists of:

  1. Technology overview
  2. OLAP using the relational engine
  3. The BI Beans advantage
  4. The Java development environment
  5. BI Beans components
  6. Programming with BI Beans - the basics
  7. Debugging and deploying your application
  8. Advanced functions

Attendees are shown how to start developing applications using BI Beans and JDeveloper. A sample application is built during the class and all attendees have access to the resulting application code.

OAUG Spring 2001

 

Picking an Oracle Applications ASP - An IT Manager's Perspective

Presented by David Fuston

Abstract not available.

Using Business Intelligence with Oracle's E-Business Suite

Presented by Karla Loomis

Abstract not available.

OAUG Fall 2001

 

Using Business Intelligence with Oracle's E-Business Suite

Presented by David Fuston

Each attendee will receive a briefing in a proven methodology that assesses your readiness to implement a Business Intelligence Solution. Each attendee will learn the advantages and disadvantages of the products under Oracle's Business Intelligence umbrella. Finally, I will show how these two applications can be used with some of the modules in Oracle's E-Business Suite, including using the GL Link for OFA.

A Business Case for 11i OM and E-Commerce Gateway

Presented by Michael Banasik

The successful OM and E-Commerce Gateway implementation is filled with many challenges, but few are true technology issues. How you overcome the challenges determines how much of the technology is adopted. Process management affects the final outcomes, and what cultural changes evolve into end user acceptance.

Oracle OpenWorld 2001

 

Oracle's SQL Analytic Functions in 8i and 9i

Presented by David Fuston

Oracle 8i Release 1 added support for the CUBE and ROLLUP extensions to the SELECT statement's GROUP BY clause. Oracle8i Release 2 introduced a powerful group of SQL functions supporting business intelligence queries. These functions enable ranking, moving and cumulative aggregates, leads and lags and more. Along with the analytic functions, Oracle 8i Release 2 also supports efficient multi-dimensional aggregations. These analytic functions and multi-dimensional aggregation features are a foundation for extending Oracle's analytic capabilities. Oracle 9i enhances this foundation and expands its functional use to include list partitioning, bitmap join indexes, OLAP server, new families of analytic functions and important extensions for the GROUP BY clause. This session reviews Oracle's SQL analytic functions, multi-dimensional aggregations and partitioning. Also included will be specific code examples of using these enhancements as well as the business requirements behind the examples.

A Business Case for 11i OM and E-Commerce Gateway

Presented by Michael Banasik

Using a case study, we will start by describing the business and IT environments, look at the business objectives for the Oracle applications technology, and then review the IT strategy taken. Areas covered will include data conversion, upgrade paths, and IT staffing. We will then discuss the bugs discovered, workarounds used, and patch sets required for each client install, and show the results of our initial test scripts. Finally, we will review the outcome of the entire project, including the net effect of the project on the business.

The successful Order Management (OM) and E-Commerce Gateway implementation is filled with many challenges, but few are solely technology issues. How you overcome the challenges determines the extent to which the user community embraces the new technology.

SCOUG 2001

 

Picking an Oracle Applications ASP: An IT Manager's Perspective

Presented by David Fuston

Abstract not available.