Presentations - 2008

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.

Using Oracle OLAP and Hyperion Essbase for BI - Webcast February 28, 2008

As you may know, Vlamis Software is getting to know Oracle's Essbase offering, bringing our 20 years of experience with Oracle OLAP and Oracle BI in general to the Essbase community. In the presentation, I plan to share our "external fair impressions" of Oracle OLAP and Essbase, and starting to explore how they could be used together. See our blog at www.vlamis.com/blog for other information on our impressions.

Click here to download video or play in an external player (38,140,422 bytes)

Larger .AVI Version (53,473,280 bytes)

Faster and Smarter Data Warehouses with Oracle OLAP 11g

Collaborate 2008

April 13-17 • Denver, Colorado • Website

Oracle BI, Oracle OLAP, Essbase: The Benefits and Cost of Openness

Presented by Dan Vlamis

4/14/2008 at 1:00 PM - 2:00 PM

Companies with heterogeneous environments need to analyze data from multiple sources, through multiple application servers, in multiple presentation environments. The "hot pluggable" products work well for this need: Oracle Data Integrator, Essbase, Real-time Decisions, Oracle Business Intelligence Enterprise Edition, and BI Applications. But what if these needs are not paramount in your organization? You can use Oracle's traditional products: Oracle Warehouse Builder, the OLAP and Data Mining options to the Oracle Database, Oracle Business Intelligence Standard Edition, and Daily Business Intelligence. Come and learn which products are appropriate for your situation, how Oracle's acquisition strategy led to this situation and how Oracle's product management structure propagates this situation. The session will especially focus on the differences between Essbase and the Oracle OLAP option--both very capable multi-dimensional databases, but with different goals.

Accelerate Your Oracle DW With OLAP 11g

Presented by Chris Claterbos

4/14/2008 at 3:30 PM - 4:30 PM

Oracle Database 11g OLAP provide several new features that can used to enhance performance of Oracle-based data warehouses. In addition, while providing a complete summary management capability, they can add additional calculation capabilities. Views are automatically created that allow standard SQL to access the original data, as well as any additional measures. By placing the calculations in the database, all of your business rules and measures can be securely stored in the database. All of this content can be accessed with any application, including Oracle Business Intelligence Enterprise Edition, Oracle Application Express, Oracle Discoverer, BI Publisher, Oracle SQL Developer, as well as non-Oracle tools.

Integrating Oracle BIEE with Oracle Analytic Workspaces

Presented by Mark Thompson

4/15/2008 at 9:45 AM - 12:00 PM

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. In this case study, we will briefly discuss the development of the multidimensional environment using Oracle Analytic Workspace Manager (AWM), then focus on the value that Genco Inc. found in 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 has delivered attractive analysis of business data to Genco's user community.

Building Cubes and Analyzing Data Using Oracle OLAP 11g

Presented by Chris Claterbos

4/15/2008 at 3:30 PM - 5:45 PM

Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? 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 demonstrate the process of migrating 10g cubes and dimensions to 11g and using Oracle OLAP 11g to create cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what it means to the Warehouse Architect and Users. OLAP 11g adds a lot of new features designed to help the DBA and Architect build multidimensional warehouses rapidly and integrate them seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications and help an application developer understand what options are possible and how to gain maximum value from a data warehouse

Implementing Oracle BI EE on Top of Oracle OLAP Cubes

Presented by Dan Vlamis

4/16/2008 at 8:30 AM - 9:30 AM

Oracle's integration of Oracle Business Intelligence Enterprise Edition Plus (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.

Investment Research and Portfolio Management Analytics using Oracle OLAP

Presented by:
Chris Claterbos
Peeyush Shukla, CFA, FRM, Mesirow Advanced Strategies, Inc.

4/16/2008 at 9:45 AM - 10:45 AM

Mesirow Financial is a diversified financial services firm headquartered in Chicago decided to step into the future and create a set of integrated tools and dashboards to help there analysts manage and analyze their performance. They had the following challenges:

  • Performant solution needed to aggregate complex hierarchies quickly
  • Replace existing quantitative statistical application
  • Data to be fed from Pervasive database to Oracle
  • Scalability of solution as the data volumes and users increase
  • Flexibility and speed of rollout essential as multiple different application to be rolled out, using same footprint
  • 10 years of historical data, from multiple data sources, to be stored and aggregated in one database
  • Support for dynamically changing model

This presentation provide a technical overview of the solution and demonstrate some of the unique solutions that were created to solve their problems using Oracle Database, OLAP, JDev and BI Beans.

ODTUG Kaleidoscope 2008

June 15-19 • New Orleans, Louisiana • Website

Oracle BI Oracle OLAP Essbase-The Benefits and Cost of Openness

Presented by Dan Vlamis

Companies with heterogeneous environments need to analyze data from multiple sources, through multiple application servers, in multiple presentation environments. The "hot pluggable" products work well for this need: Oracle Data Integrator, Essbase, Real-time Decisions, Oracle Business Intelligence Enterprise Edition, and BI Applications. But what if these needs are not paramount in your organization? You can use Oracle's traditional products: Oracle Warehouse Builder, the OLAP and Data Mining options to the Oracle Database, Oracle Business Intelligence Standard Edition, and Daily Business Intelligence. Come and learn which products are appropriate for your situation, how Oracle's acquisition strategy led to this situation and how Oracle's product management structure propagates this situation. The session will especially focus on the differences between Essbase and the Oracle OLAP option--both very capable multi-dimensional databases, but with different goals.

Building Cubes and Analyzing Data Using Oracle OLAP 11g

Presented by Dan Vlamis
Prepared by Cathye Pendley

Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? 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 demonstrate the process of migrating 10g cubes and dimensions to 11g and using Oracle OLAP 11g to create cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what it means to the Warehouse Architect and Users. OLAP 11g adds a lot of new features designed to help the DBA and Architect build multidimensional warehouses rapidly and integrate them seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications and help an application developer understand what options are possible and how to gain maximum value from a data warehouse.

Lies, Damn Lies, and Visualizing Data with Oracle BI

Presented by Tim Vlamis

Are you involved in generating reports for your business, but want to know which formats are best to use in which situations? Would you like a simple way of understanding when to use pie charts, bar charts, line charts and bubble charts? Want to know when data is presented objectively and when it's not? You'll learn basic design principles for writing reports and generating graphs. You'll see examples of how capabilities built into Excel and Oracle BI Enterprise Edition (formerly Siebel) both help and hurt in presenting and visualizing data in everyday situations. Join BI mavens Dan Vlamis and Tim Vlamis for an entertaining session on how managers typically manipulate, misuse, and abuse reports and analytics to conquer their companies on their way to world domination and what you can do to turn Oracle BI EE into a tool for the good!

Oracle OpenWorld 2008

September 21-25 • San Francisco, California • Website

Building Cubes and Analyzing Data with Oracle OLAP 11g (IOUG)

Presented by Dan Vlamis

Session S301022 Sunday 09/21 08:30 - 10:00 Moscone West Rm 2001

Can I move my existing multidimensional cubes to Oracle 11g? Can I really improve my warehouse performance with OLAP? What is the benefit of upgrading to Oracle OLAP 11g? Do you need those analytic workspace things if you're going to use Oracle Business Intelligence? This presentation demonstrates the process of migrating Oracle 10g cubes and dimensions to Oracle 11g and using Oracle OLAP 11g to create cubes and analyze data. It includes a practical look at the new features of OLAP 11g and what it means to warehouse architects and users.

Integration of Oracle Business Intelligence Suite Enterprise Edition and Oracle Essbase Plus (IOUG)

Presented by Mark Thompson

Session S301161 Sunday 09/21 14:30 - 16:00 Moscone West Rm 2008

This session demonstrates how Oracle Essbase Plus can be used as a datasource for Oracle Business Intelligence Suite Enterprise Edition. It uses a step-by-step approach in presenting the methodology for combining these two technologies.

Faster and Smarter Data Warehouses with Oracle Database 11g (IOUG)

Presented by Dan Vlamis

Session S300029 Monday 09/22 13:00 - 14:00 Moscone South Rm 302

Oracle Database 11g OLAP provides several new features that can be used to enhance the performance of Oracle Database-based data warehouses. In addition, while providing a complete summary management capability, they can add more calculation capabilities. Views are automatically created that enable standard SQL to access the original data and additional measures. With the calculations in the database, you can securely store all of your business rules and measures there, as this presentation illustrates.

BIWA Summit

Dec 2-3 • Oracle World Headquarters, Redwood Shores, California • Website

Having Your Business Intelligence the Way You Want It!

Presented by Chris Claterbos

Oracle's Business Intelligence (OBI EE+) is a platform from which to build your BI delivery the way you want it. This presentation discusses the various ways to provide data access to all users inside and outside the organization. Using the open service based architecture users can now access the OBI EE data in JDeveloper to produce custom applications and Apple iPhone users can view reports and receive alerts no matter where they are. Demonstrations of these technologies will illustrate how these new features can allow access to the BI data any way you want to see it.

Hands on with Essbase, Smartview, and Hyperion Visual Explorer

Presented by Tim Vlamis

Hyperion reporting and analysis tools, including Smartview, Hyperion Visual Explorer, and Smartspace give users an easy-to-use interface for manipulating and analyzing multi-dimensional data stored in Essbase cubes. Come gain first-hand knowledge of what is possible with Essbase in this interactive session.

Hands on With Oracle OLAP 11g for Smarter and Faster Data Warehouses

Presented by Mark Thompson

Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? 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?

In this hands-on session, participants will gain first-hand knowledge of what it's like to build Oracle 11g OLAP cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what it means to the warehouse architect and users. OLAP 11g adds a lot of new features designed to help the DBA and architect build multidimensional warehouses rapidly and integrate them seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications and help an application developer understand what options are possible and how to gain maximum value from a data warehouse.

Investment Research and Portfolio Management Analytics using Oracle OLAP

Presented by Peyush Shukla of Mesirow Financial and Chris Claterbos

Mesirow Financial, a diversified financial services firm, created a set of integrated tools and dashboards to help their analysts manage and analyze their performance. They had the following challenges:

  • Performant solution needed to aggregate complex hierarchies quickly
  • Replace existing quantitative statistical application
  • Data to be fed from Pervasive database to Oracle
  • Scalability of solution as the data volumes and users increase
  • Flexibility and speed of rollout essential for multiple applications with common footprint
  • 10 years of historical data, from multiple data sources
  • Support for dynamically changing model

This presentation provides a technical overview of the solution and demonstrates some of the unique solutions that were created to solve their problems using Oracle Database, OLAP, JDeveloper and BI Beans, including some complex calculations using the OLAP DML language.

BIWA Summit 2008 Opening Presentation

Presented by Dan Vlamis

Dan Vlamis, as the BIWA Summit 2008 Conference Chair, gave this opening presentation.

VSS Lightning Round

Presented by Dan Vlamis

A brief presentation on Vlamis Software Solutions.

BIC2G Virtual Appliance

Presented by Derick Cameron and Chris Claterbos

A hands-on demonstration of the capabilities of the BIC2G demonstration environment.