ODTUG Kaleidoscope 2008
 
HOME | SPEAKERS | ABSTRACTS | VENDORS | ODTUG.COM    
color bar
 

>>CONFERENCE UPDATES<<

2009 LOCATION ANNOUNCED
ODTUG is going to Monterey, California!

RELIVE THE ODTUG BRIGADE
A Slide show of the day is now available!
>>Watch Now

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
 
 

Fusion Middleware l Application Express l Business Intelligence l Hyperion l Methodology l Oracle Tools l Professional Development l Third-Party Tools l Java EE and SOA l Development DBA l Vendor Presentations      

denotes Oracle Ace
denotes Oracle Ace Director

Back to main abstract page  
 

Fusion Middleware

Aino Andriessen, AMIS Services
Fusion Middleware - ADF BC
ADF Development: Live from the Trenches

Let's take a ride and learn from our experiences with ADF deve lopment and how you can benefit from them. This session will provide you with tips 'n tricks, best practices, things to avoid, and much more from recent ADF projects. ADF and JDeveloper provide a great productivity boost to J2EE application development but as with all technologies, the development path is laden with pitfalls, steep slopes, and many more obstacles. Experience may help to avoid them. So learn from us, from our positive and negative experiences, and from the lessons we've learned. See how you can apply them to your own environment to enhance your ADF development experience and to increase the quality of your applications.

Back to the Top

Andrejus Baranovskis, VGO Software
Fusion Middleware - JDeveloper
Development with Oracle JDeveloper/ADF 11g Reusing 10g Best Practices

Andrejus Baranovskis, Oracle ACE director, will describe with practical demonstrations how Oracle JDeveloper/ADF 11g simplifies J2EE development. Oracle JDeveloper/ADF 11g brings new technology, which empowers developers to build new generation enterprise systems. However, when working with Oracle JDeveloper/ADF 11g the same best practices acquired when working with 10g can be reused. This presentation will focus on real development. Andrejus will share best practices in ADF business components development, validation logic development and testing, and user interface development using ADF Faces 11g. Real application will be developed and steps will be explained.

Back to the Top

Patrick Cimolini, Cayman Islands Government
Fusion Middleware - Other
Case Study: Selecting, Installing, and Configuring Universal Content Manager (UCM)

Oracle’s Universal Content Manager (UCM) is a recent addition to Oracle’s Fusion Middleware Stack. In 2007, the Cayman Islands Government selected UCM as its content management tool of choice. The product was procured and installed in 2007 with the configuration pilot project scheduled for the first quarter of 2008. First, this case study presents a brief overview of the general issue of content management. Second, the reasons for selecting UCM over competing products are reviewed. Third, a summary of the installation, training, and configuration projects is outlined from a lessons learned point of view. Finally, references are listed so that the audience can quickly get more in-depth material.

Back to the Top

Edwin Biemond, Ordina
Fusion Middleware - JDeveloper
ADF Taskflow in Full Action

How easy it is to make an application with ADF taskflow. In this presentation I will make a simple order application with Jdeveloper 11g. The purpose of this session is to explain what ADF taskflow really does and to demostrate how easy and effective ADF taskflow is. It will show how you can reuse certain parts of the application and how you can integrate WS (BPEL ,ESB) with taskflow in your application.

Back to the Top

Steven Davelaar, Oracle Corporation
Fusion Middleware - Building Custom Applications using Fusion Middleware
Oracle JHeadstart: Unprecedented Productivity in Developing Oracle ADF Applications

In maybe the coolest demo of this conference, the speaker uses Oracle JHeadstart to build a complete enterprise-class application from scratch in one hour. Features include trees, shuttles, multi-select lists of values, advanced search, tabbed regions, wizards, conditionally dependent items, deep linking, flex fields, role-based security, dynamic menus, drag and drop, and more. This presentation is a MUST-SEE for developers with a Forms/4GL background who are considering moving to J2EE.

Back to the Top

Steven Davelaar, Oracle Corporation
Fusion Middleware - Building Custom Applications Using Fusion Middleware
Beyond Drag and Drop: ADF Faces Advanced Techniques

In this presentation, Steven explains how JSF and ADF Faces actually work "under the covers", and how ADF integrates with the JSF Page Lifecycle. This knowledge is indispensable for developers who want to build more sophisticated user interfaces using ADF Faces. The concepts are illustrated with step-by-step demos to build common UI requirements like conditionally dependent items and deeplinking.

Back to the Top

Peter De Vaal, Transfer Solutions
Fusion Middleware - OAS
Robust App Server Topologies for Deploying Highly Critical Applications

The application server has become the most important part of an IT infrastructure for the deployment of any kind of application. It is often very important to choose application server topologies that offer scalability, reliability, and security. The design of such topologies should be made in an early phase of a project in order to make the right choices and to let application developers and architects get acquainted with aspects such as load-balancing, session fail-over, authentication using single sign-on, and deployment independent packaging. These aspects will be demonstrated in an implementation case of a highly critical system for one of the largest airports in the world.

Back to the Top

Lynn Munsinger and Susan Duncan, Oracle Corporation
Fusion Middleware - JDeveloper
Who Moved My Code? – Team Development in Oracle JDeveloper

Developing applications as a team introduces several considerations, including source and version control for files and utilizing shared resources. This session details the use of integrated source control via Subversion in JDeveloper 11g and how your team can package and share resources such as deployed services. Through realistic demonstrations, this session explains best practices in team development and shows how to coordinate check-in procedures and shared files across a development team. Come see JDeveloper product managers create an application using the team development features of JDeveloper, and learn how your team can leverage these features for maximum productivity.

Back to the Top

Susan Duncan, Oracle Corporation
Fusion Middleware – Jdeveloper
Seven Secrets (and More) of Successful JDeveloper Database Designers

In JDev 11 R1 the database features take a big step forward, and customers are now increasingly using JDeveloper to design bigger and more complex databases. This frequently means teams of designers working together. This paper will introduce and demonstrate features for live, connected modeling (compared to file based modeling), enhanced file-based modeling, ERD syntax modeling,  Oracle & third party database DDL generation and round-trip engineering. We show how these can be used effectively in a multi-user team to manage versioning, sharing and access controlling your models in an open-source SCM repository such as Subversion.

Back to the Top

John Flack, Synectics for Management Decisions, Inc.
Fusion Middleware - Building Custom Applications using Fusion Middleware
Google Maps, ADF Faces, and Oracle Locator: A Backstage Tour of the New Treatment Locator

This is a guided tour of a prototype locator application that uses Oracle Locator, PL/SQL, ADF Business Components, ADF Faces, and the Google Maps API. It shows how to use a REST Web service from PL/SQL, call PL/SQL from an ADF BC Application Module, use a PL/SQL table function as the basis for an ADF BC View Object, and include maps from the Google Maps API on an ADF Faces Page.

Back to the Top

Harish Gaur and Brian Gilbertson, Oracle Corporation and Hitachi Consulting
Fusion Middleware – Service Oriented Architecture (SOA) Suite
SOA Suite Customer Story
Oracle SOA Suite, a member of Oracle Fusion Middleware, is a comprehensive solution offering to build and deploy SOA and composite applications. Why do customers adopt SOA? What are the key sweet spots to get the biggest bang for the buck? What are the best practices around building service oriented architecture? In this session, you will learn about Oracle SOA Suite, customer adoption patterns, and best practices. You will also hear from a customer about their SOA journey detailing their implementation and key learnings/challenges. If you are thinking about SOA or already doing SOA, you don't want to miss this session.

Back to the Top

Kenton Ho, Perfit Computer Systems Group, Inc.
Fusion Middleware - ADF BC
Our First Oracle ADF/JSF Based Product: What They Didn't Teach You in the Demos and Courses...

This presentation will be beneficial to those developers that have been inspired to get into the world of Oracle ADF/JSF development. We’ve all seen the demos and we’ve all done the hands-on labs, but what are we missing to develop and deploy business applications? Our emphasis is to help the new ADF/JSF Developer focus on what they need to learn after they’ve left the conference. We’ll answer common questions, such as, how do my users login? We’ll highlight the most important chapters that we’ve had to understand in the 1,160 page Developer’s Guide For Forms/4GL Developers in addition to other resources we’ve used. We’ll also talk about the things you need to consider when you deploy your application. This presentation contains the hig hlights of a six-part course that we teach in our organization to get our Oracle Forms developers transitioned into Oracle ADF/JSF developers.

Back to the Top

Ann Horton, Oracle Corporation
Fusion Middleware - Other
Using the Oracle Business Process Analysis (BPA) Suite

The Oracle Business Process Analysis Suite is a mature, repository-based tool for analyzing and modeling business processes. It is a key component of Oracle's complete Business Process Management (BPM) solution. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This suite is being leveraged to deliver Fusion Application Reference Models. This presentation will present the capabilities of the BPA Suite, teach you to use this tool, and explain why you will want to use it.

Back to the Top

Jerry Ireland, Rightsizing, Inc.
Fusion Middleware - BPEL/BAM
BPEL for Workflow Developers

Attendees of this presentation will learn the basic differences between Oracle Workflow and BPEL. They will also see, through a specific example, how some of the important components are actually built. This knowledge will be essential to anyone who is contemplating future versions of any of the Oracle applications.

Back to the Top

Vinay Jain, Oracle Corporation
Fusion Middleware
Learn About Oracle’s Implementation of SOA: Application Integration Architecture
Oracle Application Integration Architecture (AIA) provides an open standards based framework for creating cross-application business processes that support the way you run your business today, while paving the way for your long term, strategic, business transformation plans. In this session, you'll learn what AIA is, how it works, and how it enables service-oriented architecture (SOA) to empower you to utilize the applications of your choice to create composite processes unique to your business.

Back to the Top

Lucas Jellema, AMIS Services
Fusion Middleware
BPEL and ESB: What's in It for Oracle Database Developers
SOA is a hot topic and Oracle is pushing the BPEL Process Manager and in its wake the Enterprise Service Bus so forcefully that probably something is going on. However, many Oracle Database developers are not really clear about what it is or what it means to them. Is BPEL a world apart from plain old PL/SQL programming? Is SOA irrelevant to database designers and SQL programmers? Or should they care?
This presentation explains in a high level overview what the key SOA concepts are. It also describes the respective roles of BPEL PM and the Enterprise Service Bus. It will then demonstrate how from PL/SQL programs (and even from SQL queries) SOA Services offered in BPEL or ESB can (and sometime meaningfully should) be leveraged, for example to perform operations across databases or even heterogeneous data stores.
The presentation will spend quiet some time on the ways the Oracle SOA Suite (both ESB and BPEL PM) can work with the Oracle Database through the Database Adapter.

Back to the Top

John King, King Training Resources
Fusion Middleware - BPEL/BAM
Beeple, B-Pel, Beepul? Understanding BPEL and Its Role in SOA

Business Process Execution Language (BPEL) is an important part of the Oracle Fusion SOA Suite and helps fulfill the orchestration component of Service Oriented Architecture (SOA). Two key promises of SOA are reusability and integration. Once services have been defined and tested, it is important that organizations be able to leverage them elsewhere. Oracle Fusion Middleware's BPEL Process Manager provides a process-centered mechanism for orchestrating services from different systems. Further, Oracle's BPEL supports the industry standard and eases integration with systems developed in non-Oracle environments (e.g. IBM, Microsoft, BEA, etc.). This presentation will help developers understand the role of BPEL, using BPEL to develop services, and using BPEL to integrate services.

Back to the Top

Peter Koletzke, Quovera
Fusion Middleware - Building Custom Applications using Fusion Middleware
Birds Do It: Migrating Forms to Java EE Web, A Case Study

This case study examines the migration of an enterprise-level, character-mode, Oracle Forms 6.0 application to Web technologies based on Java Platform Enterprise Edition (“Java EE,” formerly known as “J2EE”). It explains the decision points for choosing Fusion ADF and focuses on how ADF provided the pivot point around which technology decisions were made. The presentation discusses why Fusion development technologies–ADF Faces, UIX, and ADF Business Components–were selected. It also describes why the decision was made to leverage thick database techniques for business rules logic and user interface support. The presentation then explains and offers insight on the techniques used to migrate the skills of staff Forms developers to the new technologies. Finally, it lists successes and lessons learned during the application migration.

Back to the Top

Peter Koletzke, Quovera
Fusion Middleware - JDeveloper
Made from the Same Mold: Template Techniques for Fusion Applications

Users will more easily understand your application and will therefore be more productive if all pages of your Web application are designed to look and act the same. The requirement for a common look and feel has traditionally been met by the use of templates. However, the methods for implementing template systems change with each new technology. This presentation discusses how to work with templates and other common look-and-feel options in JDeveloper 10g and 11g. It explains and provides code examples for template systems using ADF Faces mentions JSP tags as well as additional Java templating frameworks. It also describes the Oracle Browser Look and Feel (BLAF), which is used for the E-Business Suite. The presentation also describes the ADF Faces skinning feature, as well as how the JHeadstart plug-in to JDeveloper plug-in, JHeadstart, uses templates.

Back to the Top

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 1: Fusion Development and JDeveloper Overview

These days, development shops have been mandated to develop new applications using Java Platform, Enterprise Edition (Java EE) Web technologies. This can prove to be challenging for traditional Oracle developers because the main Java EE languages and the style of development are very different. Oracle is developing the next wave of Oracle Applications/E-Business Suite (Oracle Fusion) using JDeveloper and Application Development Framework (ADF) technologies such as ADF Business Components and ADF Faces. With JDeveloper 11g, Oracle offers a tool that helps Web developers from every discipline transition more easily than ever to Java EE Web development. Its declarative and visual development environment rivals that of traditional tools, yet it creates standard Java EE code that can be deployed on any Java EE server such as Oracle Application Server. This presentation series, presented by the co-authors of the Oracle Press book Oracle JDeveloper 10g for Forms and PL/SQL Developers, explains how to use JDeveloper and ADF with the Fusion technology stack that Oracle is using for Fusion Applications. It also builds a comprehensive sample application to demonstrate the techniques and best practices you can use to create custom applications. The first presentation in this series provides an introduction to JDeveloper’s visual and declarative tools and shows how to start creating the application.

Back to the Top

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 2: Developing the Model Layer

This presentation uses the tools discussed in the first part of the series to create the Model layer the application uses to interact with database objects such as tables, views, and PL/SQL packages. The presentation explains how ADF Business Components (ADF BC) allows you to declare components that query, insert, update, and delete data. It demonstrates these techniques and shows how you can also write code snippets to perform actions not provided by the ADF BC components.

Back to the Top

Peter Koletzke and Duncan Mills, Quovera and Oracle Corporation
Fusion Middleware - JDeveloper
A Guide to Fusion Web Development with JDeveloper 11g – Part 3: Developing the View Layer

This final presentation in the series completes the picture of Fusion Web development using JDeveloper 11g by explaining the components you use to create the View layer code for the user interface. It discusses how you tie the ADF BC database components you created for the Model layer to the components on the page. It then demonstrates how you can work in the visual layout and declarative editing tools within JDeveloper and ADF to build the UI.

Back to the Top

Peter Lorenzen, Logica Company
Fusion Middleware - Other
A Practical Introduction to Oracle Web Service Manager

Web Services are more and more widely used thanks to the adoption of SOA strategies. This leads to an increased need for ways to secure Web services. Oracle Web Service Manager (OWSM) provides a unique way of doing just that. OWSM is a standard based platform that makes it possible to secure Web services declaratively without any modifications to the existing Web services implementation. We will start with an overview of the different components and move on to a simple demonstration, which will make it easier to understand concepts like gateways, agents, and policies. After the demonstration we will look at some of the components in a bit more detail. The presentation will also introduce some of the standards that OWSM is based on like WS-Security.

Back to the Top

Grant Ronald , Oracle Corporation
Fusion Middleware - Building Custom Applications using Fusion Middleware
Oracle ADF 11g: New Declarative Development Features for Fusion Applications Development

ADF is the framework of choice for Oracle's own Fusion Applications developers. Whether you are building applications to extend or integrate with Fusion Applications, or you are simply looking for a framework to enable declarative development of 'home-grown' applications, JDeveloper and ADF provide the tooling you need to accomplish these tasks. This session explains all of the new declarative development features in ADF 11g. Through demonstrations, this session shows how to build business services with ADF business components, expose those services to the user interface using ADF Faces Rich Client components, and orchestrate application logic using the new ADF controller.

Back to the Top

Lynn Munsinger, Oracle Corporation
Fusion Middleware - JDeveloper
7 Things That You Should Know When Using JDeveloper 11

Turns out that not everything is in the guide books. This session reviews helpful tips and tricks that will get you more productive when using JDeveloper 11. Not for the newbies, but rather for the more experienced developer, this session covers tips on everything from new coding features and other hidden gems in the core IDE to finding the information you need to get your work done.

Back to the Top

Robert Nocera, Vgo Software, Inc
Fusion Middleware - ADF BC
Using ADF 11g as a Platform for Oracle Client/Server Forms Conversions

With the introduction of ADF 11g, both the back-end Business Components and the front-end ADF Faces Rich Components applications can now viably be converted from Client/Server applications to Web applications. This presentation explores some of the difficulties in recreating such applications in a Web environment and shows how ADF 11g can be used to alleviate some of those difficulties. The presentation will explore a real-life proof-of-concept project that uses ADF 11g as the target platform for a client/server migration project. Real-life problems, their solutions, and code examples will be reviewed.

Back to the Top

Shaun O'Brien, Oracle Corporation
Fusion Middleware - JDeveloper
Keeping Your Leftovers Fresh with JDeveloper – New Reusability Features in 11g

Reusability is crucial to the productivity of development efforts as well as to ensure the consistency of systems within an organization. Even the most stringent of guidelines are going to end up being violated after being repeated enough times. Obviously, the more that this can be packaged into actual code artifacts the more reliable this solution is going to be. JDeveloper 11g has been specially augmented with a focus to take these use cases into consideration. In this session, JDeveloper 11g new features will be examined with special care given to the reusability features including an end-to-end demo illustrating several of these as well as providing a sneak preview of the new metadata driven systems for runtime customization of content.

Shaun O'Brien , Oracle Corporation
Fusion Middleware - ADF BC
Service Oriented Development with Oracle ADF Business Components and BPEL

BPEL is a powerful language for orchestrating services into composed business processes. This session provides a deep-dive into the new features of ADF Business Components as they relate to BPEL processes. Through demonstrations, this session explains how an ADF BC component can be consumed by Web service-savvy applications, including BPEL processes, and how to trigger a BPEL process from an ADF application using events.

Back to the Top

Chris Ostrowski , TUSC
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Internal and External Application Integration — Oracle Fusion Web Services

Having ventured down the path of a full-bore implementation of internal and external application integration in what I perceived as the most efficient and cost effective manner, you'll get the benefit of my hindsight introspections today. specifically, I implemented a lightweight Service Oriented Architecture (i.e. Web Services) wherever it made sense. This presentation will discuss the good, bad, and ugly about this approach that was taken. Knowing what I know today, I would in fact take this approach again. In fact, I highly recommend my self-named lightweight SOA. Using Web Services, your customers (whether internal or external) are able to seamlessly access your core technology as if that technology is running in its own environment. This presentation will include a demonstration of the above mentioned application in action. If you have customers or vendors who have provided you with Web Services that you need to integrate into your existing applications, you'll want to attend this presentation.

Back to the Top

Jim Powell and Maiko Rocha, Oracle Corporation
Fusion Middleware – Service Oriented Architecture (SOA) Suite
Building Next Generation of Composite Applications Using WebCenter, SOA, and Web 2.0.

The real challenge in building composite applications is determining the right approach to take and knowing when to use which component of the Oracle Fusion Middleware stack. During this session, we will build an application from scratch including, modeling, service creation, etc.  We will leverage services-oriented architecture (SOA), WebCenter Services, WebCenter Framework, WebCenter Composer, and Oracle Application Development Framework (ADF) to build a composite application.

Back to the Top

Grant Ronald, Oracle Corporation
Fusion Middleware - ADF BC
Step by Step Redeveloping a Forms Application Using Oracle ADF: A Case Study

You have heard how Oracle JDeveloper and Oracle ADF can bring you "Forms like" productivity when building on the Enterprise Java stack. Truth or Hype? This case study takes a typical Forms application and step-by-step redevelops it using Oracle JDeveloper and Oracle ADF. Building the application from the database up to the UI, this presentation will guide you on how closely many of the Forms concepts you rely on can be mapped to the Java world.

Back to the Top

Matt Topper, IT Convergence
Fusion Middleware - Other
Oracle Identity Management – The Total Identity Solution

Over the past three years Oracle has acquired major players in every aspect of the Identity Management realm. This leaves a lot of questions with what is going to be continued to be supported and what is not. This is a real-world from the trenches talk that discusses actual identity implementations. This presentation will cover all of the components of the Oracle Identity Management Suite, how they function, their similarities and differences, and the best practice solutions for each component.

Back to the Top

Clemens Utschig, Oracle Corporation
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Beyond WS-X, BPEL, and XML – The Future of SOA

While no other technology helped to shape Service Oriented Architecture (SOA) more than WS-BPEL, this session will challenge attendees to look over the horizon, to new, evolving standards, such as Service Component Architecture (SCA). With all those standards in place, the time for Business Process Management as a whole has arrived—manage, monitor, and refine your explicit processes based on your business goals and KPIs. The goal of this presentation is to help engineers as well as architects understand how they can benefit from today's standards, and design for the next generation. It will also look into the organizational concepts of SOA, why SOA is an enabler for change and agility of an organization, and what managers can do to turn employee fear and resistance into excitement.

Back to the Top

Clemens Utschig, Oracle Corporation
Fusion Middleware - Service Oriented Architecture (SOA) Suite
Introduction to Service Oriented Architecture

This session will give attendees an introduction into the world of Service Oriented Architecture (SOA) and teach them the basic foundations. Starting from a brief introduction about the concepts and ideas, towards the discovery and implementation of services, and the reuse of those within executable business processes (through the usage of Business Process Orchestration Language –  BPEL). SOA is the conceptual foundation for Oracle's next generation Application Suite (Oracle Fusion Applications) —hence this session will give the attendee a great chance to learnmthem. The presentation is demonstration driven and attendees will see the benefits explained in short demos to get a good understanding leave with the basic tools in their hands.

Back to the Top

Wilfred Van Der Deijl, Eurotransplant
Fusion Middleware - Building Custom Applications using Fusion Middleware
Integrating Oracle Forms with Other Web Technologies

The session will demonstrate how easy it is to fully integrate an existing Forms application into a JSF based Web application. With the right JSF component library, it's a matter of drag-and-drop. This allows you to build hybrid applications consisting of Oracle Forms and newly built Web pages. You can pass context from the Web application to Forms and the other way around. It's also possible to invoke actions in Forms from within the Web application or initiate Web application events from Forms PL/SQL. This is something a lot of Forms users have been craving for the last couple of years. Now it's here and you have to see it to believe it. It can be the key in a gradual migration from Oracle Forms to new technology, or if you're happy to continue using Oracle Forms, it allows you to integrate these forms with any Web application, whether it is a new JSF application, Oracle Portal, Oracle WebCenter, PHP, or any other Web technology.

Back to the Top

Sten Vesterli, Scott/Tiger A/S
Fusion Middleware - Building Custom Applications using Fusion Middleware
What’s Hot and What’s Not—An Overview of Oracle Development Tools

This presentation examines all of the important development tools and technologies available from Oracle today, discussing the strong and weak points of each:  Application Express (PL/SQL and wizard-based); Application Development Framework, ADF (middle tier components, built with JDeveloper); ADF Faces for Web applications (used by Oracle for Fusion applications); ADF Swing for desktop applications (allows rich Desktop applications like those built with Forms); Oracle Forms (today only Web deployment, a few new features in 11g); Oracle Reports (high-end reporting tool to meet the most sophisticated reporting needs); Oracle Portal (both application development framework and basic content management); and Oracle WebCenter (next generation portal product, current version does not contain full functionality). The presentation is concluded with a “hot or not” summary of which application development approaches you can expect to be using in the coming years.

Back to the Top

Sten Vesterli, Scott/Tiger A/S
Fusion Middleware - JDeveloper
Like Open Source Forms –ADF Swing Applications with JDeveloper 11g

To a Forms developer, JDeveloper and Java development can seem rather intimidating. Especially if you are trying to build a Forms-like application (called an ADF Swing application in JDev-speak). You receive little guidance from books or Web sites. This presentation shows you how you can use JDeveloper for declarative development just like Oracle Form —dragging items onto a canvas and adding trigger code to handle necessary processing. A few things differ, naturally, and these are explained in the presentation. Topics include how an ADF Swing application has separate business and user interface tiers, how the right choice of Layout Manager removes the complexity of Java screen layout, and how to choose whether to place your code in the business logic tier or the user interface tier. The presentation is wrapped up with a brief examination of the code that JDeveloper builds for you to inspect and change if necessary.

Back to the Top

Application Express

Carl Backstrom, Oracle Corporation
Oracle Tools - Application Express
Building the New Stuff: AJAX , JSON, and APEX 3.1

Oracle Application Express (APEX) provides a simple and integrated set of javascript, PL/SQL, and APEX Table Views that can be used to quickly and securely add dynamic AJAX-based functionality to any APEX application. In this session, you'll learn how to leverage some of the new built; in features of APEX 3.1 to build custom user interfaces and data exchange functionality. Future direction of APEX's javascript libraries and integration points with APEX will also be discussed. This session is geared toward the advanced APEX developer, so previous APEX and javascript experience is highly recommended.

Back to the Top

Chris Ostrowski , TUSC- A Rolta Company
Oracle Tools - Application Express
Advanced Oracle Application Express Tips and Techniques

Oracle Application Express (APEX) is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include pop-up windows, complex searches, document management, indexing and searching, tool tips and hints, e-mail links, page 0, help text, background jobs, add to my calendar feature, saving contacts (VCF), sending mass e-mails, and more.

Back to the Top

Karen Cannell, Integra Technology Consulting
Oracle Tools - Application Express
APEX Cheat Sheet 3

For beginner APEX users, and for those who have not yet memorized all the ins, outs, &’s and .’s, this “Cheat Sheet” session presents a collection of frequently used APEX features, expressions, how-to’s, and assorted “oh-yeah’s” to keep handy when building your first two or twenty-two APEX applications. We’ll cover the f?p syntax, report links, when to use &, : v(), select lists, sending e-mail, popups, adding your own logo, custom authentication, some essential JavaScript, and simple AJAX. You’ll leave this session with a “Cheat Sheet” of APEX how-to’s that will get you well into APEX development.

Back to the Top

Dimitri Gielis, Apex Evangelists
Oracle Tools - Application Express
Creating Advanced Charts in Oracle Application Express

More and more people want to see data in a graphical view. This presentation shows you how to create an advanced "graphical view" of your data in Oracle Application Express (APEX). This presentation will be seasoned with one big live demo! A risk, but I want to "show" it to you!

Back to the Top

Bill Holtzman, National Air Traffic Controllers Association
Oracle Tools - Application Express
APEX Development: Watch It Live

Application Express, like most development technologies, has its own sense and feel that developers must become familiar with to be productive. By watching someone experienced do it, others can pick up on methods, practices, and nuances that they might not otherwise absorb. An arsenal of approaches are needed by every developer to solve the innumerable and inevitable problems. The point of this demonstration will be to provide some of those approaches in a very illustrative way.

Back to the Top

Kathy Hunsicker, WaMu
Oracle Tools - Application Express
Creating Dynamite Applications with Application Express that Deliver

Oracle’s Application Express has enabled WaMu's Card Services group to rapidly deliver robust, low cost, secure, scalable, and successful Web-based applications. As a key component of their BI and MIS platform, APEX has empowered both technical and business teams to replace legacy processes based on paper, Excel, and MS Access with simple, yet powerful applications with improved controls and capabilities.

Back to the Top

Michiel Jonkers, AMIS Services
Oracle Tools - Application Express
Explore and Benefit the APEX Repository

The APEX engine generates forms, reports, and charts based on meta data that is stored in the APEX repository. As a developer it is very easy, but still not common practice, to use this repository with meta data for quality assurance and impact analysis. APEX also comes with an API on the APEX repository which can be used to perform automated bulk operations to enforce a consistent behavior or look and feel for APEX applications. In my presentation I will explain how the APEX repository is organized and how developers can benefit from the repository and its API. I also will demonstrate how to develop quality reports and how to use the API to perform time consuming changes in one or multiple applications in only a few seconds.

Back to the Top

Joel Kallman, Oracle USA, Inc.
Oracle Tools - Application Express
Go Global with Oracle Application Express!

The world is shrinking. And eventually, you will be given the task to develop an application which is used by people from a variety of languages and cultures. Oracle Application Express is a complete development environment used to quickly build sophisticated Web applications in an Oracle database. Unbeknownst to many developers are the sophisticated features inherent in Oracle Application Express which enable easy development of a perfectly translated and localized Web application. This session will demonstrate, from beginning to end, the development of a Web application using Oracle Application Express, and also the translation and localization of this application. Best practices will be reviewed in addition to practical examples of how to exploit the globalization features native to the Oracle database.

Back to the Top

Raj Mattamal, Niantic Systems, LLC
Oracle Tools - Application Express
Writing a Custom Authentication Scheme for Application Express: A Case Study
Although Application Express has excellent out-of-the-box options for authenticating users into applications, it is sometimes necessary to write custom authentication schemes to meet the specific needs of customer environments. Using an existing implementation as a case study, this session will explore many of the considerations required when assembling a custom authentication scheme including using some of the APEX custom authentication APIs provided by Oracle. In addition to discussion, this session will demonstrate the functionality discussed.

Back to the Top

Josh Millinger, Niantic Systems, LLC
Oracle Tools - Application Express
Migrating from Access to Oracle Application Express

As we all know, Microsoft Access is ubiquitous in our IT environments, even if it wasn't intended to be. Application Express is the obvious choice to look to when deciding how to move the now mission-critical applications into our Oracle environment. This session will take an example of starting with MS Access with an application and go through all the necessary steps to make it "live" in APEX. Steps include using the Oracle Migration Workbench to move the data and then Oracle APEX to help create/modify the application.

Back to the Top

Anton Nielsen, C2 Consulting, Inc.
Oracle Tools - Application Express
How to Hack an Oracle Application Express Application

Oracle's Application Express (APEX) allows developers to quickly build highly functional applications that interact with an Oracle database. APEX dynamically generates HTML applications (hence the former name, HTML DB). All HTML applications share some attributes that expose them to potential hacking. APEX has many features that will allow developers to lock down their applications – or to expose them to hacking. I will show (live!) a number of techniques that can be used to hack HTML applications—and how to close these holes within APEX and where APEX may expose these holes through its wizards. Naturally, I will show how to protect against any hack that I demonstrate. The session will be interactive with the audience participating in ways to hack and prevent hacks. This is truly a session that can benefit the novice to the highly advanced APEX developer.

Back to the Top

David Peake, Oracle Corporation
Oracle Tools - Application Express
Oracle Application Express (APEX) Version 3.1

Oracle Application Express (formerly Oracle HTML DB) enables anyone, even those with limited programming experience using just a Web browser, to quickly create secure, scalable, database-centric Web applications. In this session, you'll learn why Oracle Application Express is one of Oracle's most popular technologies, and you will learn about exciting new features in Application Express 3.1. Details relating to Version 4.0 will also be covered.

Back to the Top

Tanya Podchiyska, Stanford University School of Medicine
Oracle Tools - Application Express
Application Express in Support of Institutional Strategic Planning

Oracle Application Express is a rapid application development tool which offers developers a wide arrangement of customization options. Hence, it was chosen as the development platform for the Stanford Medical School’s strategic planning application. The application provides a central repository for the Institutional Planning Office to manage the plans of organizations throughout the school. It also allows users to develop their strategic plans, including determination of missions, goals, activities, and initiatives. This Web-based application facilitates communication throughout the school of goals, initiatives, and activities. It provides tools for organizations to define their success metrics and monitor their performance relative to their plans. The technical demonstration covers session-state handling, dynamic SQL utilization in defining the authorization scheme, building of custom theme with APEX HTML templates, JavaScript and CSS (including SVG stylesheet modifications), and AJAX for user role specification.

Back to the Top

John Scott, Apex Evangelists
Oracle Tools - Application Express
APEX Hints, Tips and Best Practices

Application Express makes it incredibly easy to develop applications, however there is always more than one way to achieve something and it can be very difficult to know whether there is a “better” way to do something (and “better” can be very subjective!). This presentation will show some hints and tips on features in Application Express which you might not be aware of, but you should definitely be using! We will also cover some “best practices” (which can also be very subjective!) which can ultimately lead to a more productive development cycle.

Back to the Top

Scott Spendolini, Sumner Technologies, LLC
Oracle Tools - Application Express
You Can't Do THAT in a Browser! Extending Oracle APEX with Third Party Components

While APEX offers a robust set of features, it does not address every possible scenario that you will run into when developing your applications. Fortunately, it is quite simple to use a number of third party tools to enhance and/or supplement APEX's functionality. This presentation will review a number of these components and demonstrate how to integrate them with APEX.

Back to the Top

Karen Van Hellemont and Jan Huyzentruyt, iAdvise
Oracle Tools - Application Express
Use the Power of APEX Dictionary Views to Increase the Quality of Your APEX Applications

Since Oracle Application Express 2.2, all metadata defining your applications are exposed by means of the (new) data dictionary views. This opens perspectives to set-up your own Quality Control System with checks against coding standards and good practices. —When starting the development of a new application, one of the first actions you always do is set up naming conventions, coding standards, and best practices. This presentation will show you how you can increase the overall quality of your application by controlling whether your development team follows those outlined guidelines. Those controls can be implemented by queries against the APEX repository views presented in a custom QA application—in APEX of course.

Back to the Top

Patrick Wolf, Sphinx IT Consulting
Oracle Tools - Application Express
Increase Your Oracle APEX Development Productivity with Open Source Tools

Oracle Application Express (APEX) development is already very productive, but with the right combination of tools it can be even more productive! This presentation will give you an overview and a demonstration of open source tools which can be used to increase the productivity of your Oracle APEX development environment. It will cover "must have" Firefox and Internet Explorer plugins, the Javascript framework jQuery, the ApexLib development framework and the Oracle APEX Builder Plugin.

Back to the Top

Marcie Young, Oracle Corporation
Oracle Tools – Application Express
Building Advanced Tabular Forms
Have you ever wanted to build a tabular form manually so that you could control the way the data appeared and was manipulated. In this session, you will learn how to build a custom tabular form using the APEX_ITEM and APEX_APPLICATION APIs. You will learn how to add extra rows for insert, add optimistic locking, and validations using collections. This advanced session will expand your understanding of the inner workings of tabular forms and how they can be used.

Back to the Top

Business Intelligence

Michael Armstrong-Smith, Armstrong-Smith Consulting
Business Intelligence/Hyperion/Siebel - Discoverer
Manipulating Dates for Use in Discoverer

Have you ever tried using Oracle's date hierarchies in Discoverer only to find out that they don't work very well or that your date indexes no longer work? Have you ever wanted to know how to manage your fiscal calendar, or even how to work out the number of business days between any two dates? If the answer to any of these questions is YES, then this is the presentation for you. Michael will show you how to manage a fiscal calendar for use with Discoverer. He will also give you many tips and tricks for managing and working with dates. Don't be drawn into thinking that this presentation is only for Discoverer because what you learn here can be applied to most SQL based applications.

Back to the Top

Vincent Chazhoor, Lafarge North America
Business Intelligence/Hyperion/Siebel
Oracle 11g Data Warehousing

This presentation will review the new and enhanced features in 11g for data warehousing. Topics include partitioning, partition advisor, referential, internal, and virtual column partitioning, composite partitioning enhancements, new sub-partition options, automatic partition creation, and incremental maintenance of NDV for partitioned tables.

Back to the Top

Cathye Pendley and Dan Vlamis, Vlamis Software Solutions
Business Intelligence/Hyperion/Seibel - 10g/11g OLAP
Building Cubes and Analyzing Data Using Oracle OLAP 11g

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.  It will help an application developer understand what options are possible and how to gain maximum value from a data warehouse.

Back to the Top

Jean-Pierre Dijcks, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Development's Bag of Tricks for Oracle Warehouse Builder

You are using Oracle Warehouse Builder and you see many things you could do or could do better. See how you can solve some common problems by using the functionality that OWB provides in 11g. We will be discussing a set of topics with hands-on examples which will include, for example, using analytical SQL in OWB (hierarchical queries, advanced aggregations), dealing with XML data sources and targets, matching and merging information from different systems, and extending the product using Experts. This session is intended to deepen your knowledge about Warehouse Builder and make you, as a developer, more productive.

Back to the Top

Jean-Pierre Dijcks, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Warehouse Builder Goes Heterogeneous: What That Means for You

With Warehouse Builder 11g Release 2 you will get the best of both the OWB and the ODI world in one tool. Yes, OWB is integrating the ODI heterogeneous concepts and templates within the familiar OWB functionality. So you now have full heterogeneous support for both sources and targets included with the data profiling, data quality, and regular Oracle PL/SQL mappings. On top of that you will see a unification of the metadata layer in the database and a unification of the client tool user interfaces (OWB goes JDev IDE!). In short, if you are interested in ETL and OWB, this session shows the newest of the newest in OWB land, straight out of development. See it all in action and ask questions about our direction in ETL land.

Back to the Top

Mike Donohue, Oracle Corporation
Business Intelligene/Hyperion/Seibel – BI Publisher (formerly XML Publisher)
Oracle BI Publisher Overview: New and Planned Features
Oracle Business Intelligence Publisher (BI Publisher, formerly XML Publisher) is Oracle's strategic  enterprise reporting solution to author, manage, and deliver all types of highly formatted documents eliminating the need for costly point solutions. Built on open standards, IT staff and developers can create data models against practically any data source and use BI Publisher Web Services or Java APIs to build custom applications leveraging existing data sources and infrastructure. End users can easily design report layouts using familiar desktop tools, dramatically reducing the time and cost needed to develop and maintain reports. In this session we will cover an overview of BI Publisher as well as what is new and coming in the next release.

Back to the Top

Eric Marcoux, Université Laval
Business Intelligence/Hyperion/Siebel - BI Publisher (formerly XML Publisher)
How BI Publisher Can Help Manage Reports of the Whole Enterprise

During this session, you will discover how we have deployed BI Publisher to manage the reports of Oracle applications (Siebel, eBusiness Suite, PeopleSoft), Oracle ADF Web-based applications, and third party applications like Sungard’s Banner. You will also learn the benefits of BI Publisher compared to Oracle Reports for your IT team and your end users. Plus, you will see how you can mix BI Publisher with Oracle Content DB and Stellent UCM to store your dynamically generated reports. Installation, configuration, and deployment tips will be shared throughout this presentation. This presentation is based on two distinct customer case studies.

Back to the Top

Shyam Nath, Deloitte Consulting LLP
Business Intelligence/Hyperion/Siebel - Other
A BI and Advanced Analytics Case Study

This presentation will look at the framework for developing a data-driven planning application using business intelligence and advanced analytics. Often the planning, budgeting, and forecasting involves quantitative details that make the job of the approving authorities harder. Here we take the domain of K-12 education and look at how advanced analytics can be used to predict the students who are "at-risk" of graduation versus those who are likely to succeed. This is a major U.S. national challenge and the government's "No-Child Left Behind" initiative addresses that. We look at how K-12 cross-subject education related data such as attendance, enrollment, achievement, discipline, etc. can be used to create an education datawarehouse and can be used for data mining. We will look at the use of Oracle Warehouse Builder, Oracle Data Mining, OBIEE, other BI tools, and the development environment in the process. The outcome of the data mining provides the "actionable" data to the education administrators and decision-makers via the education dashboards. These in turn help to initiate data-driven planning that can use the results of predictive analytics to plan for current and future school years. This presentation was developed using a real Department of Education BI project from 2007.

Back to the Top

Doris Phillips, City of Charlotte, North Carolina
Business Intelligence/Hyperion/Siebel - Other
Stepping up to Visual Analysis!

Visual analysis is a revolutionary new way to get information out of your Oracle data warehouse or data marts! Quickly visualize what you know and discover things that you did not know existed in your Oracle data. Learn about visual analysis along with some basic tips and techniques for getting data out of the database using Tableau/Oracle [Hyperion] Visual Explorer through a case study that analyzes the City of Charlotte's helpdesk data.

Back to the Top

Mark Rittman, Rittman Mead Consulting
Business Intelligence/Hyperion/Siebel - Oracle Business Intelligence Enterprise Edition (formerly Siebel Analytics)
A Next-Generation Oracle BI Architecture

With the recent acquisitions of Hyperion and Siebel, Oracle now has a world-class set of BI tools to add to their own Oracle Database, Oracle Discoverer and Oracle Warehouse Builder. For customers though, the question now is how to build an effective BI architecture out of these tools, built around the core of an Oracle database and using the features of Oracle OLAP, Oracle BI Server, OWB and ODI, Oracle Dashboards, Oracle Answers, and the performance management tools provided by Hyperion. This presentation answers the questions around Oracle's BI strategy, provides a BI development roadmap and sets out an architecture that leverages the best elements of these tools, explaining how best to use Oracle's BI and data warehousing for a variety of customer scenarios.

Back to the Top

David Roberts and Kendall Garey, Oracle Corporation
Business Intelligence/Hyperion/Seibel
What's New and What's Coming in Hyperion BI Tools

Attend this session to learn about the latest developments and planned enhancements to Hyperion's BI tools, including Web analysis, financial reporting, interactive reporting, and SQR production reporting.

Back to the Top

Paul Rodwick, Oracle Corporation
Business Intelligence/Hyperion/Siebel
Oracle Business Intelligence Road Map and Strategy

What lies ahead in Business Intelligence? In this session, learn about Oracle's plans to deliver a complete set of enterprise performance management (EPM) applications with a best-of-breed next-generation BI foundation, operational BI applications, and market-leading financial performance management applications from Oracle Hyperion.

Back to the Top

Antonio Romero, Oracle Corporation
Business Intelligence/Hyperion/Siebel - Oracle Warehouse Builder (OWB)
Oracle Warehouse Builder: Web Services and SOA Ready

Web services and SOA are the big buzzwords in today’s world of loosely-coupled applications. Oracle Warehouse Builder 10gR2 and 11gR1 are ready for today's application architectures. This presentation will focus on how to handle an XML document as a source or target (using experts) and how to expose an OWB mapping as a Web service, and call it from BPEL. Concrete examples will show you how incorporating OWB functionality in these cases improves developer productivity.

Back to the Top

Borkur Steingrimsson, Rittman Mead Consulting
Business Intelligence/Hyperion/Siebel - Oracle Business Intelligence Enterprise Edition (formerly Siebel Analytics)
Implementing Access Control for Oracle BI Enterprise Edition Suite

The Oracle Business Intelligence Enterprise Edition Suite offers a wide variety of authenticating users and permitting access to the services it provides. We will take a look at what different options we have with this respect and take a detailed look at how to set up a robust authentication and authorization model.

Back to the Top

Tim Vlamis and Dan Vlamis, Strategyscape, LLC and Vlamis Software Solutions
Business Intelligence/Hyperion/Seibel - Oracle Business Intelligence Enterprise Edition (formerly Seibel Analytics)
Lies, Damn Lies, and Visualizing Data with Oracle BI

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!

Back to the Top

Dan Vlamis, Vlamis Software Solutions
Business Intelligence/Hyperion/Siebel - 10g/11g OLAP
Oracle BI, Oracle OLAP, Essbase: The Benefits and Cost of Openness

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, 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.

Back to the Top

Hyperion

Gary Crisci, Morgan Stanley
Hyperion
ASO: Understanding MDX
While we are all familiar with traditional "Essbase calc formula syntax", Essbase Aggregate Storage databases use MDX (Multi-Dimensional Expression) in its formulas.  In this presentation, we'll start off with the basics of MDX and then move into tuples and a whole host of MDX functions/commands.  We'll cover how some of the traditional BSO functions translate into MDX functions.  We'll conclude with some real-world examples and workarounds that you can use when creating your own ASO applications.

Robert Donahue, Whittman Hart
Scalable Infrastructure: Clustering, Load Balancing, and Fail Over
Increasingly Essbase and Hyperion are being implemented to support functions which are critical to the daily operations of the business & enterprise as a whole.  This introduces the need to ensure that infrastructure architecture is stable and reduces the risk of performance issues or unplanned outages.  This session will focus on different options to implement a scalable & fault tolerant infrastructure.  In addition the session will discuss the considerations that drive the overall infrastructure design.

Subhash Gaur, Oracle Corporation
Kennedy: Essbase Studio

This presentation will demonstrate the capabilities of new cube building tool, Essbase Studio. It will include modeling of data sources, creation of hierarchies, design, and construction of the cube. It brings ease of use of EIS and performance of load rules. Dynamic association of Drill Through reports with cubes will also be demonstrated. New features such as XOLAP, slowly changing attributes, and derived text measure of Essbase are exposed through Studio.

Back to the Top

Eric Helmer, The Hackett Group
Architecting a System 9 Implementation

Successful implementations of Hyperion System 9 BI+ Foundation Suite require a level of architectural planning and understanding from the very beginning.
This session is specifically tailored for technical system architects and system administrators considering System 9. It will cover a general high-level introduction to the many components of System 9, process
interdependencies, and interactions. We will also touch on more advanced topics on installation strategy, sizing considerations, clustering, and high availability based on best practices and lessons learned in the field.

Back to the Top

Rob Hull, Oracle Corporation
Smart Space Gadgets with Visual Studio
Oracle EPM Smart Space provides a new and innovative way of delivering content to users, enabling user collaboration and exposing a combination of Oracle BI, BI Publisher and Oracle's Hyperion BI reporting content in an extensible gadget-based environment. This session will explore the integrated services exposed through Smart Space, and discuss the extensibility of the Smart Space product through custom gadgets and services. There will be a demonstration of gadget development in Visual Studio .NET using the Smart Space SDK's. A review of other technologies available to integrate external systems and products with the Oracle landscape using Smart Space will also be covered. The discussion will include information around the Smart Space OTN developer community and additional resources available to developers, partners and customers.

Back to the Top

Mike Killeen, Ranzal and Associates
Hyperion
Optimizing Essbase Retrievals
In the Essbase world, considerable time is spent on tuning and optimizing calculations – after all the predominant value proposition of the product is that by pre-aggregating and calculating as many values as possible, sub-second retrieval times should be a given. For top down retrievals and P&L reporting, this is nearly always the case;  however there has always been a class of retrievals that have proven problematic in Essbase with respect to response times – these include bottoms up queries with multiple row dimensions, bulk data extraction methods, queries with attribute dimensions, and dynamic range based functions (Ranks, Counts, etc).  
This session will focus on a variety of techniques for optimizing the above scenarios, including the following:

  • Bulk Data Extraction Methodologies – a comparison of Report Scripts, calculation, and Export methodologies, with optimization techniques for each
  • Techniques for optimizing Bottoms up Queries in a Block Storage Database
  • Aggregate Storage Databases as a Retrieval Optimizer for Range Based Functions and Attributes
  • Tools Tips and Tricks – techniques for optimizing Hyperion Planning, Hyperion Reports, Hyperion Web Analysis, and Excel Add-In Retrievals

Time will be allocated at the end of the session for a general Q&A.

Back to the Top

Steve Liebermensch, Oracle Corporation
Hyperion
ASO:Conversion Issues from BSO
In this session you will learn about converting an existing block storage(BSO) outline to aggregate storage(ASO). This will include discussion on the hierarchical differences and implications thereof, as well as, basic member formula syntax conversion and mapping of BSO functions to MDX.

Back to the Top

Steve Liebermensch, Oracle Corporation
Hyperion
Optimizing ASO
In this session we will discuss the various opportunities to tune an aggregate storage(ASO) database. Specific topics will include dimensional types and usage; materialization concepts and techniques; enhancements to data loading; as well as MDX formula optimization.

Back to the Top

Jeff McAhren, Health Markets
Optimizing Dataloads and Dimension Builds
We will discuss best practices for dimension building and data loading regarding performance and maintainability, including optimizing data sources, build types, types of database restructures, and things to avoid when building dimensions and loading data.

Back to the Top

Tracy McMullen, interRel Consulting
Hyperion
MaxL (and Converting Over from EssCMD)
When it comes to automating Essbase cubes, there are two primary batch methods: old-school EssCMD and cutting-edge MaxL.  This presentation will start with the basics: what is a MaxL script, how do you test it, and how do you launch it.  We'll then cover converting an EssCMD script to MaxL.  After addressing how to read the MaxL documentation (trust us: it's not easy), we'll show you how to write your own MaxL scripts to automate all those mundane aspects of corporate life.  Finally, we'll conclude with several real world examples of MaxL scripts that you can begin using today with a minimum of customization.

Back to the Top

Tracy McMullen, interRel Consulting
Hyperion
Optimizing Outlines
Some people want to optimize their Essbase cubes for calculation performance.  Others want to reduce the speed of data loading or improve the performance of retrievals.  The best place to start no matter what you're optimizing is the common factor across all of these: the Essbase outline.  This presentation will cover essential outline optimization topics like dimension order, density and sparsity, tuning compression to the outline order, dynamic calculations, proper attribute dimension usage, and more.  Using primarily these tips, your presenter has personally seen optimization improvements of more than 99.9%.  If you want to learn to optimize the foundation on which all other aspects of Essbase sit (we're talking about the outline here), then make sure you attend this presentation.

Back to the Top

Al Marciante, Oracle Corporation
Hyperion
Kennedy: Essbase Block Storage Changes

This session will highlight key enhancements to the Block Storage kernel for Essbase.  These include features such as textual measures, backup/recovery, new calc functions, and time intelligence updates. It will also include a general overview of key initiatives and features as part of the overall Kennedy release of Essbase.

Back to the Top

Al Marciante, Oracle Corporation
Hyperion
Kennedy: Essbase Aggregate Storage Changes

This session will highlight key enhancements to the Aggregate Storage kernel for Essbase. These include features such as text/date measures, XOLAP, partial data clearing, and partitioning features.  It will also include a general overview of key initiatives and features as part of the overall Kennedy release of Essbase.

Back to the Top

David Mellor, Oracle Corporation
Hyperion
First Look Beyond Kennedy: An Alpha Preview

The First Look Preview session will introduce new capabilities for Essbase to utilize the Application Development Framework via an extension for Oracle JDeveloper.  JDeveloper is a complete IDE for Service-Oriented Architecture (SOA) and Java.   An Essbase Developer is no longer constrained to use a specific browser front end to build Essbase Applications. The developer can now use the full power of JDeveloper to develop components such as member selectors, pivot tables as well as building predefined dashboards with a variety of visualizations. The session will provide an interactive demonstration by building a sample application in JDeveloper which highlights the Essbase integration. 

Back to the Top

Ron Moore, Marketing Technologies Group
Calc Scripts: Beyond the Basics
So you’ve mastered the basics.  Now what? Calc Scripts: Beyond the Basics will take it to the next level and explore solutions to some of the most common calculation problems such as rolling calculations, block creation issues and calculating across databases with different dimensions.  If the next level isn’t enough for you, we will also introduce a few functions from Essbase’s new generation such as DataExport that lets you push data to a relational database.  We wrap up with some discussion of calculations for the ever popular allocations.  Calc scripts at 8:00 AM?  Bring coffee!

Back to the Top

Jason Novikoff, interRel Consulting
Hyperion
Installing Essbase: The Basics
There are hundreds of pages of installation documentation in several different guides but yet in some cases they are missing critical pieces of information.  In this session, you will see the steps necessary to install and configure Essbase.  We will cover installation of the license server and discuss which versions no longer require it.  We will cover installation and configuration of Shared Services and Essbase Administration Services as well as Essbase itself.  There are several choices you can make for the third-party prerequisites; we will not cover all combinations but you will get exposure to some common steps and troubleshooting techniques.

Back to the Top

Edward Roske, interRel Consulting
Hyperion
Optimizing Calc Scripts
There are classes (and books) on how to write calc scripts but with the exception of the often misunderstood mantra "Fix on sparse, IF on dense," there is little information on writing a well tuned calc script.  When should I use CLEARDATA vs. CLEARBLOCK?  (The answer: 99% of the time you should be using CLEARBLOCK.)  When should I use CALC DIM vs. AGG?  (The answer: in most every case, you should be using AGG or not be aggregating the dimension at all.)  When should I use IF vs. FIX?  Explanations for all of these questions as well as tips on writing easily maintainable calc scripts and efficient use of functions will be explained in this… the most important presentation you ever attend (as far as calc scripts are concerned, that is).

Back to the Top

Edward Roske, interRel Consulting
Hyperion
VBA: Essbase and Smart View Add-Ins
Of the Fortune 500 companies that use Essbase, more than 92% of them access at least some of their data through Microsoft Excel.  Because of this, companies have created multitudes of spreadsheets ranging from single, unformatted tabs up to multi-megabyte spreadsheets.  If your company is like most, you'll find yourself wanting to automate certain things.  Maybe it's as simple as connecting every sheet in a workbook to Excel and then retrieving data from Essbase.  Maybe it's as complex as an Excel-based dashboard with dropdowns linked to Essbase and command buttons all over the place to retrieve, send, zoom in, and more.  The key to any of these applications is VBA and thankfully, Oracle has a rich "toolkit" of VBA functions for developers and users to draw on to access Essbase from within the Essbase Excel and Smart View Add-Ins.  In this class, you'll see real world examples of VBA code that you can use to automate and enhance your Microsoft Office experience.  You'll leave with at least a solid understanding of the principles behind writing your own VBA against Essbase.  Note that a basic understanding of Excel macros is assumed: we're just going to cover the Essbase side of things.

Back to the Top

Edward Roske, interRel Consulting
Hyperion
Custom-Defined Functions in Calc Scripts
Sometimes, you just can't live within the constraints of the standard Essbase calc script functions and commands.  For instance, a large retailer recently wanted to write a "Weeks of Supply" calculation to determine how long a product would remain stocked based on forecasted sales.  Writing this using a calc script took pages of code and the script took hours to run.  The solution was to move the function to Java where it could then be accessed via an Essbase CDF (Custom-Defined Function) that makes the Java-based function appear to be part of the Essbase calc script language.  The resulting CDF was only 7 lines long and took only minutes to run.  In this presentation, you will learn will learn the basics of custom-defined functions and how they can improve the speed and maintainability of your calc scripts.

Back to the Top

Edward Roske , interRel Consulting
Hyperion
Custom-Defined Functions in Calc Scripts
Sometimes, you just can't live within the constraints of the standard Essbase calc script functions and commands.  For instance, a large retailer recently wanted to write a "Weeks of Supply" calculation to determine how long a product would remain stocked based on forecasted sales.  Writing this using a calc script took pages of code and the script took hours to run.  The solution was to move the function to Java where it could then be accessed via an Essbase CDF (Custom-Defined Function) that makes the Java-based function appear to be part of the Essbase calc script language.  The resulting CDF was only 7 lines long and took only minutes to run.  In this presentation, you will learn will learn the basics of custom-defined functions and how they can improve the speed and maintainability of your calc scripts.

Back to the Top

Rick Sawa, Oracle Corporation
Hyperion
Optimizing Caches and CFG Settings
This session covers how to tune and configure memory caches of Block Storage Option (BSO) Essbase, and the talk will concentrate on the Essbase.cfg settings that impact cache performance. Administrators and developers will learn how BSO Essbase manages data movement in memory between the Essbase kernel and auxilliary storage. The presentation will focus on how data is managed by Essbase to support aggregations, procedural calculations and query requests. The main focus will be to explain how to tune and optimize Essbase caches in each scenario. Some attention will be also given to the negative impact of sub-optimal Essbase configurations. 

Back to the Top

Tim Tow, Applied OLAP
Hyperion
VB APIs

This session will cover the Essbase C and VB APIs with particular focus on the Essbase VB API.  The session will cover differences between the APIs, platforms available, practical examples and pitfalls to avoid when using the APIs.  Excel VBA integration and advanced debugging techniques will also be discussed.

Tim Tow, Applied OLAP
Hyperion
Java API

This session will cover the Essbase Java API.  Topics that will be discussed include architecture, scope of functionality available in the Java API, how to get started programming with the Java API.  It will also provide practical examples of Java API code and will cover advanced debugging techniques.

Back to the Top

Methodology

Jean-Pierre Dijcks, Oracle Corporation
Methodology - Other
Best Practices in Implementing Data Quality Process with Warehouse Builder

We all know it is there, we all know we need to do it, but how do we apply this data quality stuff in real projects? In this session we go through a set of examples showing how to implement data quality policies in an organization using OWB. Topics to expect include determining survivorship of your master records, householding, and linking of records. In addition, we will discuss and show how to create smart auditing and testing of data in a so-called data quality firewall. This firewall prevents bad data from even entering the systems being targeted. Last but not least, we will discuss how to implement a quality assessment and reporting structure on your existing systems.

Back to the Top

Paul Dorsey, Dulcian, Inc.
Methodology - Thick Databases
Thick Database Techniques for Fusion (and Other) Web Developers

This presentation discusses how the decision to use a  thick database approach  impacts database developers. Successful application logic in the database requires SQL and PL/SQL features such as object types, collections, INSTEAD OF triggers, function-based views, bulk operations, autonomous transactions, etc. This presentation will include real-world examples to help attendees build systems that perform better and are easier to maintain over time.

Back to the Top