Presentations - 2005

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.

IOUG Live! 2005

May 1-5 • Orlando, Florida • Website

University Course: Managing Oracle OLAP 10g

Presented by Chris Claterbos and Dan Vlamis

In Oracle10g, Oracle has introduced significant new features in the OLAP Engine. These new features increase the possibility of creating many sorts of business intelligence applications, such as collaborative budgeting, collaborative forecasting, predictive analysis, and modeling applications. All of this is now available within the Oracle 10g database. With this new freedom comes new challenges in managing the database. How are cubes built and 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 what new tools are used to manage OLAP and how easy it is to create comprehensive OLAP databases. We will also present best practices and strategies pulled from a decade of experience with Oracle OLAP technologies.

Oracle OLAP--How Does it Really Work?

Presented by Dan Vlamis

In Oracle OLAP, 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 OLAP or BI Beans instead of simply using regular views or relational tables?

This presentation will describe these components in a "behind the scenes" tour of Oracle OLAP. Armed with information such as "What is an Analytic Workspace", and "what metadata is required to support 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. Also included will be the metadata structures used ("AW Standard Form") to describe AW data and how this results in AWs being automatically enabled for BI Beans in OLAP 10g.

Front-End Tools to View OLAP Data

Presented by Dan Vlamis

Prior to the 10g release of Discoverer, companies that wanted to present Oracle OLAP data had to develop their own applications using BI Beans, typically in JDeveloper. With recent releases, there are now several choices for front-ends that display Oracle OLAP data: Discoverer 10g, Custom-built BI Beans, Spreadsheet Add-in for OLAP, OLAP Web Agent, or 3rd party tools.

Discoverer release 10g gets its power from BI Beans to present Oracle OLAP data. 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 or other products.

Oracle Warehouse Builder 10g and OLAP - What is New?

Presented by Chris Claterbos

With the use of the new features found in recently updated Oracle's Warehouse Builder (OWB) and Oracle 9i/10g we can design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g and Oracle OLAP and how to design and construct a Oracle 10g database that can be used for OLAP analysis and presentation. The many new features that improve on the ability to build OLAP warehouses taking advantage of the many new features in Oracle 10g will be presented. 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.

Developing Advanced Business Intelligence

Presented by 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. Oracle's introduction of the 2nd Generation of BI Beans (10g R2) significantly improved the ability of inexperienced Java developers to create Complex Rich Business Intelligence Applications with minimal effort. This session explains how developers can take advantage the new features in JDeveloper and BI Beans 10g 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/10g, Oracle OLAP, JDeveloper 10g 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.

ODTUG Now! 2005

June 18-22 • New Orleans, Louisianna • Website

Front-End Tools to View OLAP Data

Presented by Dan Vlamis

Prior to the 10g release of Discoverer, companies that wanted to present Oracle OLAP data had to develop their own applications using BI Beans, typically in JDeveloper. With recent releases, there are now several choices for front-ends that display Oracle OLAP data: Discoverer 10g, Custom-built BI Beans, Spreadsheet Add-in for OLAP, OLAP Web Agent, or 3rd party tools.

Discoverer release 10g gets its power from BI Beans to present Oracle OLAP data. 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 or other products.

Oracle OLAP--How Does it Really Work?

Abstract | Presentation

Presented by Dan Vlamis

In Oracle OLAP, 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 OLAP or BI Beans instead of simply using regular views or relational tables?

This presentation will describe these components in a "behind the scenes" tour of Oracle OLAP. Armed with information such as "What is an Analytic Workspace", and "what metadata is required to support 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. Also included will be the metadata structures used ("AW Standard Form") to describe AW data and how this results in AWs being automatically enabled for BI Beans in OLAP 10g.

Oracle Open World 2005

September 11-15 • San Francisco, California • Website

Oracle Warehouse Builder 10G and OLAP -- What's New?

Presented by Dan Vlamis

So you've heard of Oracle OLAP, huh? Maybe you've heard about how it speeds up calculations, about the lightning-fast response times on queries, about how users can customize their own environment and queries without bothering the IT department. Or maybe you've already experienced some of this and see the promise in OLAP, but can't seem to get that one little piece working that will make it all worthwhile. It all looked so simple in the demo you saw!

This presentation will start with a brief demo/overview of Oracle OLAP and the cube-building process, followed by case studies and a discussion of some of the real-world topics that we have encountered as we work on Oracle OLAP implementations, including: attribute dimensions, ragged and skip-level hierarchies, loading data at multiple levels of a cube, duplicate keys in a dimension, surrogate keys, accessing source tables on a different instance, compressed composites, sparsity issues, and NA row suppression.

Oracle OLAP in the Real World: Case Studies from the Trenches

Presented by Chris Claterbos

With the use of the new features found in recently updated Oracle's Warehouse Builder (OWB) and Oracle 9i/10g we can design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g and Oracle OLAP and how to design and construct a Oracle 10g database that can be used for OLAP analysis and presentation. The many new features that improve on the ability to build OLAP warehouses taking advantage of the many new features in Oracle 10g will be presented. 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.

Twin Cities Oracle User Group

October 13 • Bloomington, MN • Website

Oracle BI and Oracle OLAP--What's All This About?

Presented by Dan Vlamis

So you've heard of Oracle Business Intelligence and Oracle OLAP, huh? Maybe you've heard how it speeds up calculations; the lightning-fast response times; how users can customize their own environment and queries without bothering the IT department.

What are those "multi-dimensional cubes" anyway? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?

This presentation will describe the architecture of Oracle OLAP and take you through creating a cube from start to finish. Then, the various front-end choices in the Oracle BI suite (including Oracle Discoverer, Oracle Spreadsheet Add-in and Oracle BI Beans) will be shown and compared using the cubes built earlier in the presentation. Finally, Dan will discuss some of the real-world topics that he has encountered while working on several Oracle OLAP implementations.

Kansas City Oracle User Group

October 24 • Overland Park, KS • Website

OracleBI and Oracle OLAP--What's All This About?

Presented by Dan Vlamis

So you've heard of Oracle Business Intelligence and Oracle OLAP, huh? Maybe you've heard how it speeds up calculations; the lightning-fast response times; how users can customize their own environment and queries without bothering the IT department.

What are those "multi-dimensional cubes" anyway? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?

This presentation will describe the architecture of Oracle OLAP and take you through creating a cube from start to finish. Then, the various front-end choices in the Oracle BI suite (including Oracle Discoverer, Oracle Spreadsheet Add-in and Oracle BI Beans) will be shown and compared using the cubes built earlier in the presentation. Finally, Dan will discuss some of the real-world topics that he has encountered while working on several Oracle OLAP implementations.

ITEC - Kansas City

October 26 • Overland Park, KS • Website

BI for Everybody

Presented by Dan Vlamis

Competitive Business Intelligence (BI) software tools offer varying features and functionality. But, they represent a significant investment for your organization. How do you evaluate them and find the right fit for your organization? How do you maximize their use? What are the pitfalls? We'll review the latest offerings that can help you manage the process of collecting, organizing, and analyzing intelligence information.

Ohio Oracle User Group

October 27 • Columbus, OH • Website

Oracle BI and Oracle OLAP--What's All This About?

Presented by Dan Vlamis

So you've heard of Oracle Business Intelligence and Oracle OLAP, huh? Maybe you've heard how it speeds up calculations; the lightning-fast response times; how users can customize their own environment and queries without bothering the IT department.

What are those "multi-dimensional cubes" anyway? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you?

This presentation will describe the architecture of Oracle OLAP and take you through creating a cube from start to finish. Then, the various front-end choices in the Oracle BI suite (including Oracle Discoverer, Oracle Spreadsheet Add-in and Oracle BI Beans) will be shown and compared using the cubes built earlier in the presentation. Finally, Dan will discuss some of the real-world topics that he has encountered while working on several Oracle OLAP implementations.

BI for Everybody

Presented by Dan Vlamis

Competitive Business Intelligence (BI) software tools offer varying features and functionality. But, they represent a significant investment for your organization. How do you evaluate them and find the right fit for your organization? How do you maximize their use? What are the pitfalls? We'll review the latest offerings that can help you manage the process of collecting, organizing, and analyzing intelligence information.