Presentations - 2002

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 2002

 

9iAS and Discoverer 4i Plus - A How to Guide

Presented by David Fuston

Oracle 9iAS Discoverer is a key component of the Oracle 9i Application server (Oracle 9iAS) in integrated business intelligence solution. Discoverer is the ad hoc tool for queries, reporting, analysis and publishing over the web. During this presentation, I will demonstrate how to setup and implement Oracle 9iAS Discoverer environment. This presentation will utilize an already established Oracle 9i database instance and an Oracle 9iAS instance. We will walk through how to create, modify and execute ad hoc queries as a Discoverer Analyst or Report Builder. We will then access these queries as if we were the casual user viewing and navigating our predefined reports and graphs. And last, but not least, we will export a crosstab report to MS Excel.

IOUG Live! 2002

 

Migrating Express Data to Oracle9i

Presented by Dan Vlamis

Oracle 9i presents new possibilities for OLAP applications. Data can be stored in RDBMS tables or in an analytic workspace, which is simply a new term for an Express database. Which is the right storage vehicle for your needs? How do you migrate the data? What information is lost in the transition?

This presentation will focus on strategies for migrating data from Express databases to Oracle 9i, using Oracle Warehouse Builder, and other techniques. Also included will be a comparison of the benefits of migrating the data implications of storing the data in different ways.

Oracle 9iOLAP--How Does It Really Work?

Presented by Dan Vlamis

In Oracle 9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. What's the magic that makes this work? How does this impact performance? What operations are precluded by various design decisions? Why would you want to use Oracle 9i OLAP or BI Beans instead of simply using regular RDBMS tables with Oracle Discoverer?

This presentation will describe these components in a "behind the scenes" tour of Oracle 9i OLAP. Armed with information such as "what is an analytic workspace", and "what metadata is required to support the Java OLAP API and BI Beans?", will help a DBA prepare a database and design schemas for use by an OLAP application and help an application developer understand what options are possible and how to gain maximum value from a data warehouse or data mart.

Converting Express Applications to Oracle9i and BI Beans Applications

Presented by Chris Claterbos

With the introduction of Oracle 9i and BI Beans, the landscape for development of BI applications is changing. This leaves clients with existing Express based applications developed in Express Web Agent and Oracle Express Objects (OEO) asking "How do we move our applications?". The direct migration of such applications is not fully supported but there is hope. This presentation will address the issues involved in converting and migrating these types of applications over to the new technology. Example applications will be presented and used throughout the presentation.

Topics Include:

  • Overview of the Oracle 9i and BI Beans Architecture
  • Data Migration Issues
  • What Can and Cannot Be Migrated/Converted
  • Conversion vs. New Development - Which is Best or Possible
  • Development Process (steps)
  • Tips and Techniques
  • Design and Implementation Issues

Using Oracle Warehouse Builder 3i and Oracle9i to Create OLAP-Ready Warehouses

Presented by Chris Claterbos and Elizabeth Reardon

With the use of the new features found in Oracle's Warehouse Builder (OWB) 3i 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 3i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation. Design and implementation issues will also be addressed. A step-by-step guide will be presented with the end result being an OLAP-ready datamart.

Topics Include:

  • New Features of OWB 3i
  • Overview of OLAP Features of Oracle 9i
  • Designing a Multidimensional Database with OWB
  • CWM Metadata in 9i
  • Designing the Datamart
  • Updating the 9i Metadata
  • Loading and Viewing Data
  • Design and Implementation Issues

OAUG Spring 2002

 

9iAS and Discoverer 4i Plus

Presented by David Fuston

Abstract not available.

Oracle Financial Analyzer (OFA) and the GL Link

Presented by David Fuston

This presentation will cover the DBA tools and techniques used in customizing Oracle Financial Analyzer. The background topics to be covered include OFA architecture, how OFA interacts with Express Server and Personal Express, and OFA Structures and Catalogs. The major portion of the presentation will be a discussion of how to maintain the catalogs behind the scenes in Express 4GL, as well as loading data and structures. Some of the structure differences between using Oracle G/L link and a standalone OFA application will be discussed. We will demonstrate the advantages and limitations of using the three tools (OFA front-end, Express 4GL and Express Administrator) for performing maintenance and customizations.

Particular will place particular emphasis on illustrating best practices in customization and maintenance. Particular emphasis will be placed on DM.CATALOG (dimensions), LC.CATALOG (local code), MD.CATALOG (models), HI.CATALOG (hierarchies), FD.CATALOG (financial data item) and RL.CATALOG (attributes) showing best practices in customization and maintenance. We will demonstrate the process of adding items to the menu and tool bar. Each attendee will receive a technical diagram showing the detailed interrelationships among OFA catalogs.

Each attendee will learn the advantages and limitations of the three tools (OFA front-end, Express 4GL, and Express Administrator) used by a DBA for maintaining and customizing OFA databases. Attendees will gain a detailed understanding of the properties of several catalogs critical to implementing, maintaining, and customizing OFA databases.

Organizational Structures of a Multi-Org Setup

Presented by Mike Banasik

We will cover the organizational structures involved in setting up a Multi-Org environment. We will run the Multi-Org Validation Report to identify any problems with the configuration and highlight related profile options, errors, and warnings that may be generated.

This presentation will cover the organizational structures involved in the setup of a Multi-Org environment on a single installation of Oracle Applications. The Multi-Org architecture determines how transactions flow through different organizations and how those organizations interact with each other. Organizations can be sets of books, legal entities, operating units, or inventory organizations. We will discuss the Multi-Org hierarchy, along with considerations for multiple charts of accounts. We will cover the various aspects involved in setting up a Multi-Org environment, including identifying some potential pitfalls. We will highlight the information shared across organizations and discuss information that may be specific to each organization. Finally, we will run the Multi-Org Validation Report to identify any problems with configuration and highlight the related profile option and point out possible errors and warnings that may be generated.

OAUG Fall 2002

 

OFA and GL Link Tips, Tricks and Traps

Presented by Mike Banasik and David Fuston

Attendees will learn the advantages and limitations of the three tools (OFA front-end, Express 4GL, and Express Administrator) used by a DBA for design and maintenance of OFA databases. Attendees will gain a detailed understanding of the properties of several catalogs critical to implementing, maintaining, and customizing OFA databases and GL Link.

This presentation will cover the DBA tools and techniques used in customizing Oracle Financial Analyzer (OFA). The background topics to be covered include OFA architecture, how OFA interacts with Express Server and Personal Express, GL link procedures and process, and how OFA structures and catalogs work behind the scenes. The major portion of the presentation will be a discussion of how to maintain the catalogs behind the scenes in Express 4GL, as well as loading data and structures via GL Link and custom data loaders. Some of the structure differences between using Oracle G/L link as a data loader and a standalone OFA application will be discussed. A sample custom data loader program will be shown as a take-home example of optional customizations. The advantages and limitations of using the three Oracle Express tools (OFA front-end, Express 4GL and Express Administrator) in conjunction with GL administrator for performing maintenance and customizations will be demonstrated.

Particular emphasis will be placed on the General Ledger setup, including chart of accounts, key and descriptive Flexfields, segment concatenation, rollup groups, parent/child relationships, and summary accounts. We will discuss the GL Link setup limitations, changing structures over time, and GL to OFA mapping. We will review known GL link issues, bugs, and workarounds.

We will discuss best practices in OFA customization and maintenance. Particular emphasis will be placed on DM.CATALOG (dimensions), LC.CATALOG (local code), MD.CATALOG (models), HI.CATALOG (hierarchies), FD.CATALOG (financial data item) and RL.CATALOG (attributes) showing best practices in customization and maintenance. Examples of adding items to the menu and tool bar will be demonstrated. A technical diagram applicable to Express 6.3 and GL 10.7, 11, and 11i showing the detailed interrelationships among OFA catalogs will be given to each attendee.

ODTUG 2002

 

9iAS and Discoverer 4i Plus

Presented by David Fuston

9iAS and Discoverer 4i Plus training will be broken down into three segments: 1) Setup and Connectivity for Discoverer 4i Plus, 2) Warehouse and Dimensional Strategy, and 3) Building and Executing a Query. This presentation will use an already established Oracle 9i database instance and an Oracle 9iAS instance.

Setup and Connectivity for Discoverer 4i Plus
This part of the presentation will be almost exclusively hands-on demonstration starting with setting up the user disco4. Then we will run through JInitiator installation, starting OracleDiscover4i service, modifying tnsnames.ora file, registering the collector, preferences, and the session.

Warehouse and Dimensional Design
We will review the terminology and schemas used in data warehousing. Then we will discuss best practices and an assessment of whether your company is ready for a business intelligence solution.

Building and Executing a Query
During this phase of the demonstration we will create a new workbook via the Workbook Wizard from the data warehouse tables, and select certain options for formatting and gridlines. We will then filter our results along with pivoting and changing the worksheet layout. During this discussion, we will address some common problems, including when and how to customize the crosstab reports for your environment.

How To Develop Applications With BIBeans and JDeveloper

Presented by Chris Claterbos and David Fuston

This class will present the new technologies that were introduced with Oracle 9i. These include analytical functions in the relational database, OLAP Services, Java OLAP API, and BI Beans. Attendees will see how to use Oracle 9i, 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 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. Building Custom Applications
  8. Debugging and Deploying your Application
  9. Advanced Functions

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

OracleWorld 2002

 

Building BI Portals, Using Oracle9i, 9i Developer, and BI Beans

Presented by Chris Claterbos

This presentation details the developing and deploying of a Business Intelligence Portal for the Web using Oracle Portal 9i (9iAS 9i R2), Oracle 9i, JDeveloper 9i, BI Beans and other components of the 9i Developer Suite. An overview of the various architectural components with optional deployment considerations is given. Specific topics include:

  • Overview of programming with JDeveloper 9i and BI Beans
  • Architectural Review-How everything works together
  • Using BI Beans, JDeveloper and Portal over Web
  • Templates and dynamically generated HTML
  • Using OLAP Beans and JDeveloper
  • Integrating with other BI Tools (Reports and Discoverer)
  • Do's and Don'ts

Developing Applications with BI Beans and Oracle9i JDeveloper-Our Experience

Presented by Chris Claterbos

This presentation will present how custom applications can be built using JDeveloper 9i, 9i OLAP and BI Beans. The attendees will be shown how to start developing applications using BI Beans and JDeveloper. We will also address the experiences we had developing our product VSS Business Analyzer and share with the attendees how they can also develop simple and complex applications. A comparison between thick and thin client applications will also be discussed. The outline consists of:

  1. Programming with BI Beans - The Basics
  2. Building Custom Applications
  3. Adding Advanced Functions
  4. Our Experiences
  5. Tips and Techniques

Effectively Using 9i OLAP in Business Intelligence Applications

Presented by Dan Vlamis

Oracle 9i OLAP enables all Oracle data warehouses and data marts to be analyzed with OLAP applications. In Oracle 9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. This eases the whole process of developing applications. More importantly, it opens up previously inaccessible data to new business applications. How do we now capitalize on these new capabilities?

What's the magic that makes this work? How does this impact performance? What operations are precluded by various design decisions? Why would you want to use Oracle 9i OLAP or BI Beans instead of simply using regular RDBMS tables with Oracle Discoverer?

This presentation will describe the components of Oracle 9i OLAP. Armed with information such as "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.