Presentations - 2007

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.

Vlamis Software

These papers and presentations are not directly associated with a specific conference.

OLAP 11g Changes

We recently had a chance to "touch and feel" Oracle OLAP 11g beta. Here are screenshots and bullet point lists of features we found most exciting in this new release. For more information about OLAP in Oracle 11g see our blog entry and May newsletter.

Demonstration of Oracle BI EE Running on Oracle OLAP

This script and presentation were developed for use with the BI Challenge to Go (BIC2G) environment. The BIC2G environment was created by the Oracle Corporation in collaboration with partners like us. The BIC2G project is a self-contained and fully-functional installation of Oracle Business Intelligence that can be used for technical demonstrations, training, and proof of concepts.

Collaborate 2007

April 15-19 • Las Vegas, Nevada • Website

Building Cubes and Analyzing Data in Two Hours

Presented by Dan Vlamis

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 exercise will demonstrate the process of implementing Oracle OLAP using Analytic Workspaces. By creating cubes themselves in hands-on exercises, participants will gain first-hand knowledge of the process involved. Participants will also be able to analyze the data in their cubes using tools such as Discoverer, BI Beans, and the OLAP BI Spreadsheet Add-in for Excel. Armed withinformation such as "What is an Analytic Workspace", and "what metadata is required?", 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.

Integration of Oracle BI EE and Oracle Analytic Workspaces

Presented by Mark Thompson

Oracle's integration of Siebel Analytics into the Oracle product family provides exciting opportunities to extend the use of Oracle's multidimensional OLAP cubes to include Oracle's new customers who have previously adopted the Siebel environment. Siebel users can use the power of Oracle's multidimensional data engine and features, while still retaining the Siebel interface. This presentation will demonstrate the development and use of the OLAP_TABLE object for preparing multidimensional data cubes for use by Oracle BI EE (i.e. Siebel) analytics. We will briefly discuss the development of the multidimensional environment using Oracle Analytic Workspace Manager (AWM), then focus on the development of the corresponding OLAP_TABLE objects to be referenced by Oracle BI EE.

The presentation will provide a broad overview of the ability to integrate these two portions of the Oracle Business Intelligence product suite.

Using Warehouse Builder for Business Intelligence

Presented by Chris Claterbos

Using Oracle 10g R2 and Oracle Warehouse Builder (OWB) Release 2 we can now design, construct, load and view data in a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g Released2 and Oracle OLAP and show how to design and construct a Oracle 10g database that can be used for Business Intelligence. 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. Included in this presentation are Tips and Techniques that have been used over several projects to provide a fully functional Business Intelligence solution using one tool.

Working on Projects Remotely

Presented by Cathye Pendley

Have you contemplated either you, one of your employees, or a consultant working remotely? This session will go into the benefits of working remotely as well as some of the tools and techniques that can be used to help when working remotely. Topics covered will include:

  • Benefits for the employee/consultant
  • Time and stressed saved from not traveling
  • Balance of personal and professional life
  • Benefits for companies
  • Cost savings
  • Greater productivity
  • Hiring and retaining quality consultants
  • Tools and Techniques
  • Communication
  • Software
  • Processes

In the two plus years I have worked for Vlamis Software Solutions(VSS), I have worked for the same client, with only two short trips to the VSS office in Kansas City and two trips to my client. Working remotely has proved to be beneficial for me, our client and VSS. Come by this presentation and hear details on how to make working remotely a success for your business.

ODTUG Kaleidoscope 2007

June 18-21 • Daytona Beach, FL • Website

Implementing Oracle BI EE on Top of Oracle OLAP Cubes

Presented by Dan Vlamis

Oracle's integration of Oracle Business Intelligence Enterprise Edition (OBIEE) into the Oracle product family provides exciting opportunities to extend the use of Oracle's multidimensional OLAP cubes to include Oracle's new customers who have previously adopted the Siebel environment. We will briefly discuss the development of the multidimensional environment using Oracle Analytic Workspace Manager (AWM), then focus on the value of using these two technologies together. In a live demonstration, the presentation will highlight the benefits of using OBIEE against Oracle OLAP Analytic Workspaces (AWs). The demonstration draws on the strength of both products to show how the combination of OBIEE and Oracle OLAP can deliver attractive analysis of business data.

BIWA Summit

October 2-3 • Reston, Virginia • Website

Implementing Oracle BI EE on Top of Oracle OLAP Cubes

Presented by Dan Vlamis

Oracle's integration of Oracle Business Intelligence Enterprise Edition (OBIEE) into the Oracle product family provides exciting opportunities to extend the use of Oracle's multidimensional OLAP cubes to include Oracle's new customers who have previously adopted the Siebel environment. We will briefly discuss the development of the multidimensional environment using Oracle Analytic Workspace Manager (AWM), then focus on the value of using these two technologies together. In a live demonstration, the presentation will highlight the benefits of using OBIEE against Oracle OLAP Analytic Workspaces (AWs). The demonstration draws on the strength of both products to show how the combination of OBIEE and Oracle OLAP can deliver attractive analysis of business data.

Dallas Oracle Users Group - BI Forum

October 12 • Dallas, Texas • Website

Implementing Oracle BI EE Using Oracle OLAP Cubes

Presented by Mark Thompson

Oracle's integration of Oracle Business Intelligence Enterprise Edition (OBIEE) into the Oracle product family provides exciting opportunities to extend the use of Oracle's multidimensional OLAP cubes to include Oracle's new customers who have previously adopted the Siebel environment. We will briefly discuss the development of the multidimensional environment using Oracle Analytic Workspace Manager (AWM), then focus on the value of using these two technologies together. In a live demonstration, the presentation will highlight the benefits of using OBIEE against Oracle OLAP Analytic Workspaces (AWs). The demonstration draws on the strength of both products to show how the combination of OBIEE and Oracle OLAP can deliver attractive analysis of business data. We will also show how Oracle OLAP 11g makes this process easier, with built-in views against AWs, materialized view query re-direction, and other new features in Oracle OLAP 11g.

Oracle OpenWorld 2007

November 11-15 • San Francisco, California • Website

Oracle Business Intelligence Financial Services ASaP

Presented by Dan Vlamis

This session covers how the Oracle Business Intelligence toolset was used to build an application for QDecisions. This Active Server Pages (ASP) application delivers a rich query interface, analysis over 30+ dimensions, and a Flash-based dashboard. It boasts a metadata-driven cube building process for implementations at multiple clients and uses Oracle Database with the OLAP option and Oracle Business Intelligence to analyze bank services' financial performance.

IOUG: Using Oracle Warehouse Builder for Business Intelligence

Presented by Chris Claterbos

Using Oracle Database 10g Release 2 and Oracle Warehouse Builder Release 2, we can now design, construct, load, and view data in a data warehouse that is fully OLAP-ready. This session introduces Oracle Warehouse Builder 10g Release 2 and Oracle OLAP, shows how to design and construct an Oracle 10g database that can be used for business intelligence, and explores tips and techniques to provide a fully functional business intelligence solution using one tool.