"It’s a great place to learn real technical content, as opposed to some of the other conferences . . . this conference has met and exceeded my expectations. This has been the single greatest source of information at any conference I have been to yet." -Jason Jones, Kroger

Boost your technical know-how with these great presentations

Click here for the schedule at a glance!

Aino Andriessen, AMIS Services
Web Architecture and Development
ADF Development: More Tales from the Trenches
In this session we’d like to share our experiences on ADF development and provide you with best practices, tips and tricks, dos and don’ts, etc.

Back to Top

Keith Amann, Monsanto Company
Hyperion
Making Your Life Easier with Planning Utilities
Planning and Shared Services offer utilities to ease the security maintenance and migration process for administrators. Join us for this important session where we’ll review each of the utilities available for Hyperion Planning and learn how to import security, upload metadata and data from a single csv file, and more.

Back to Top

Rohit Amaranth, Full 360 Inc.
Essbase
Essbase in the Clouds
Cloud computing using Amazon Web Services is on-demand requisition for compute and storage resources. You pay only for when the servers are running, with no up-front expenses or capital outlays. This presentation describes how to leverage AWS for an on-demand business intelligence infrastructure for Essbase while reducing infrastructure and capital outlay expenses. It covers setting up Essbase in the cloud, case studies around leveraging the on-demand servers for peaks in usage and using the cloud for unlimited archival storage.

Back to Top

David Anstey, POCSOL
Professional Development
Shuffling Along with the Lost: Avoiding the pitfalls that drive technical projects to failure.
A lively presentation describing the things NOT to do if your intent is to successfully bring a technical project in on time. While many project management papers and presentations focus on how-to techniques and “best practices”, this presentation will address the behaviors, actions, and norms that drive projects into the ground.

Back to Top

Michael Armstrong-Smith, Armstrong-Smith Consulting

Michael Armstrong-Smith, Armstrong-Smith Consulting
BIDW
Maximize your investment in Discoverer
Are you a Discoverer user? Then you are among thousands of happy customers of this great tool. But, have you maximized your investment? This presentation will show you exactly how you can do this. Michael will begin by outlining three strategies that your company can adopt for using Discoverer in the future. Michael will close by examining the most common errors that companies make, preventing them from maximizing their investment and harnessing Discoverer’s full potential.

Back to Top

Guillaume Arnaud, Oracle Corporation
Hyperion
Mastering Calc Manager for Financial EPM Applications (Planning/HFM)
Learn how to build business rules for Oracle Hyperion Planning and Oracle Hyperion Financial management using the new Web-based and graphical product called Calculation Manager. As a business rule developer or administrator, learn how to reduce the time for designing and maintaining business rules, and how better to share the calculation logic with the business users. Also learn how to benefit from best practices provided by calculation manager for standard calculations such as allocations, aggregation, etc.

Back to Top

Back to Top

Joe Aultman, autotrader.com
Essbase
Customizing Planning with JavaScript and CSS
Sometimes you need Planning to do things that Planning can’t do. At these times, you need to open Planning’s back door with JavaScript. Custom form features are only a few lines of code away, but the path is dark and the documentation thin. At other times, you may simply need a jolt of excitement that Planning’s muted color scheme just can’t give you, or the CFO is certain the company logo would look smashing in the masthead of all your forms. Planning’s Custom Style Sheets are easy to find, but the tags are mysterious and the documentation is no better. This session is your guide to Planning’s murky backwaters. Learn the hooks Planning provides to hang your code on (and which of them work). Discover the CSS tags you can modify to give you the look you want. Take Planning one step beyond.

Back to Top

Dietmar Aust, Opal Consulting
Application Express
PDF Printing with APEX—A Cost-free Alternative
The dynamic generation of PDF documents is an absolute necessity in many applications. Unfortunately, the integration with Oracle BI-Publisher is quite cost-intensive. JasperReports is the most popular reporting engine in the Java community, it is stable and performant. Using the GUI based iReport Designer, you can create pixelperfect layouts for JasperReports easily. This session focuses on the secure Integration of JasperReports into Oracle APEX to produce reports in many different formats (PDF, RTF, Excel, XML).

Back to Top

Dietmar Aust, Opal Consulting
Application Express
Generating complex Excel reports with APEX and jXLS
This session focuses on the integration of the open source project jXLS into APEX. In more general terms this is a showcase on how to leverage the java stack in APEX applications to extend the APEX framework. jXLS is a small and easy-to-use Java library for generating Excel files using XLS templates. This way you can use your existing company templates (including logos, diagrams, complex calculations, etc.) directly. Just add some variables and logic to it.

Timothy Bell, Self Employed
Database Development
Writing Screamingly Fast PL/SQL Applications
This paper provides the methodologies necessary for writing extremely fast PL/SQL applications. In doing so, the paper covers using many of the advanced Oracle PL/SQL techniques (such as BULK COLLECTION, REF CURSORs, complex objects and the like) to facilitate the data interactions to achieve optimal processing speed.

Back to Top

Sean Bernhoit, Linium
Essbase
Advanced Financial Reporting
This presentation will focus on Integration with Workspace, Key Tips and Tricks with Reports, Integration with Web Analysis, and Integration with Smartview.

Back to Top

Charles Berger, Oracle Corporation
Business Intelligence and Data Warehousing
Powering Next-generation Predictive Applications using Oracle Data Mining
Oracle Data Mining embeds twelve algorithms in the Oracle Database. ODM eliminates data movement, identifies relationships, builds predictive models, and discovers new insights. Oracle Data Mining is a powerful mining engine that provides Oracle Business Intelligence Enterprise Edition and Oracle Applications new insights and predictions that help companies better compete using analytics. This presentation will present a detailed overview of capabilities, and includes several demos and applications that embed predictive analytics.

Back to Top

Bradley Brown, TUSC—A Rolta Company

Back to Top

Bradley Brown, TUSC—A Rolta Company

Back to Top

Stewart Bryson, Rittman-Mead Consulting
BIDW
Oracle Warehouse Builder may seem like a natural fit for Oracle developers making the leap from custom development to tool-driven ETL, but is often discounted by ETL developers comfortable with more mainstream development tools such as Informatica or DataStage. Whether you are considering replacing a custom ETL development process, or simply comparing other enterprise offerings, OWB 11g has definite strengths and weaknesses that should be considered before your choice is made.

I will demonstrate what loading a standard data mart, consisting of fact tables, dimension tables, and aggregates, looks like from an OWB perspective. This presentation will teach you some of the issues OWB addresses, as well as some of what it ignores, so you will be in a better position to make the right choice for your organization.

Back to Top

Chris Bucchere, bdg
Other
Top 10 Productivity Features for Java Developers on WebLogic Server 10.3
Oracle WebLogic Server 10.3 introduces an extensive set of new capabilities aimed directly at making the Java developer more productive when rapidly and iteratively developing rich internet applications. This session highlights the top 10 capabilities that will improve a Java developers working on WebLogic Server include features such as deep Spring framework integration and support, fast Java class swapping, deployment plans, HTTP pub-sub capabilities for Web 2.0 development, sophisticated debugging and end-to-end updates for Java EE 5.0 development. Learn what's new and see it in action in this demonstration centric session.


Chris Bucchere, bdg
Other
Introduction to Oracle WebLogic Server
Oracle WebLogic Server is the industry's leading application server for building enterprise-class, mission-critical Java applications and offers a rich set of functionality for both developers and administrators. This session provides an overview of Oracle WebLogic Server concepts, highlighting how its architecture and capabilities enable rapid, low-cost development, deployment, and management of scalable and reliable applications.

Back to Top

Doug Burke, BI Consulting Group
BI/DW
OBIEE Answers+ on Essbase: The Future of Ad-Hoc Analysis
Back in the old days before the Oracle acquisition of Hyperion, you probably used Hyperion Web Analysis as your default front-end on top of Essbase cubes. In the modern world of 2009, there's a better solution: OBIEE Answers+ sitting directly on Essbase. Answers is more robust, feature-rich, and frankly, more powerful than Web Analysis ever dreamed of being. In this session, you'll learn how to use Answers on Essbase, leaving Web Analysis behind as you stay on the forefront of cutting edge ad-hoc analysis.

Back to Top

Donald Burleson, Burleson Consulting
Database Development
Oracle 11g SQL Tuning Secrets
Oracle SQL tuning is now more complex than ever. This presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle10g SQL tuning features.

Back to Top

Back to Top

Back to Top

Flavio Casetta, yocoya.com
Application Express
Oracle Application Express Supporting Objects
 APEX supporting objects scripts make it easy for the developer to deploy an application in a new environment or ship a self-installing APEX application to end-users.
It is important to understand each supporting object component and see how it affects the installation or upgrade process. The modularity of installation scripts allows a developer to subdivide the tasks in several steps and take advantage of PL/SQL procedures for executing complex checks. The goal of this session is to identify the best spot for doing what, taking into consideration the current limitations of this tool.

Back to Top

Michael Casey, Oracle Corporation
Hyperion
Managing your EPM applications centrally via EPM Architect
The attendees will learn how EPM Architect (EPMA) facilitates centralized management of meta data and data across the different types of EPM applications - Planning, Financial Management, Profitability and Essbase. We will investigate best practices for the following:

1) Project structure and implementation.
2) Dimension definition and sharing.
3) EPM application lifecycle and deployment best practices.

The users will take away an understanding of the best practices to implement and manage applications in an EPMA environment.

Back to Top

Tony Catalano, TUSC—A Rolta Company
Database Development
Oracle Development Tips and Tricks You Must Know
Throughout my fifteen years working with Oracle, I have accumulated a list of tips and techniques that assist with the development of Oracle-based custom applications. These tips and tricks can be used to improve application performance, to streamline code, and to create higher quality applications. The speaker will describe each topic in detail, as well as provide real-world examples of how to use them.

Back to Top

Chris Churchill, Ranzal & Associates
Hyperion
Key Considerations for a Successful Hyperion Planning Implementation
This session is designed to walk business and IT professionals through the steps involved in carrying out a successful Hyperion Planning implementation. The session will begin with a review of the key phases involved in a planning project. Next, best practice design considerations will be covered, with real-world use cases as examples. The final topic will cover some unique use cases for Hyperion Planning outside of the everyday financial forecast and budget arena.

Back to Top

Patrick Cimolini, Cayman Islands Government
Application Express
Case Study: Developing a Rules and Guidelines Document for APEX
A concise Rules and Guidelines document is valuable to any software development team. It leads to consistent and efficient software development by allowing team members to concentrate on business rules instead of system plumbing. This case study shows how a team developed its APEX Rules and Guidelines document, its contents, how it evolves over time, and its cost/benefit ratio.

Back to Top

Dai Clegg, Oracle Corporation and David Hay
Web Architecture and Development
Business Data Modeling: It's Gotta be ERD
There's no way Unified Modeling Language (UML) can do it! Is there? Business data modeling has a long tradition in the Oracle community, and in the product set from SDD onward, and it has always been approached using the Barker/Ellis notation. This presentation, that grows out of recent collaboration with David C Hay of Capgemini Financial Strategies, examines whether UML class modeling is a capable alternative to ERD for business data modeling.
And if you didn't think "what the heck's SDD" you might not like the presenter's conclusion. By the way, it's not a conclusion entirely shared by Mr. Hay.

Dai Clegg, Oracle Corporation
Database Development
Unleashing Legacy Business Logic
This presentation will discuss the business advantages of publishing database logic as Web services, it will explore the strategies for publishing and will identify some of the critical choices and potential problems that will confront those who pursue this course.

Gary Crisci, Morgan Stanley

Back to Top

Gary Crisci, Morgan Stanley

and Edward Roske, InterRel Consulting

Back to Top

Gary Crisci, Morgan Stanley

Back to Top

Lewis Cunningham, TUSC—A Rolta Company

Back to Top

Lewis Cunningham, TUSC—A Rolta Company

Back to Top

Lewis Cunningham, TUSC—A Rolta Company

Back to Top

Chris Dennis, TopDown Consulting
Essbase
Advanced Interactive Reporting
How are people REALLY using Oracle Hyperion Interactive Reporting)? You'll learn some intermediate to advanced methods for creating and managing reports, detailed analysis, and dashboards against relational and multi-dimensional database sources. We’ll cover several advanced tips and tricks on optimizing your reports, making them look beautiful, and the best ways to incorporate new System 9 and 11 features and functionality like Essbase Cube Query. The presenter is a long-time user of Interactive Reporting dating all the way back to the earliest Brio days, so you'll see several real-world demonstrations of sophisticated information delivery via Interactive Reporting.

Back to Top

Marc De Oliveira, PYTHIA Information
Best Practices
What's the Point with the Zachman Framework?
This presentation is an introduction to the Zachman Framework with focus on building Oracle systems. I will describe all the elements of the framework matrix as well as discuss its value in system development. I will also suggest how to use the Zachman Framework with tools like SQL Developer and Oracle Designer.

Back to Top

Jean-Pierre Dijcks, Oracle Corporation
Business Intelligence and Data Warehousing
Best Practices for Deploying a Data Warehouse on Oracle Database 11g
This session will address Oracle's best practices for truly dealing with the needs and issues when designing a high-performance data warehouse on Oracle. We will go into details as to how to leverage the newest hardware/software for performance, discuss techniques such as partitioning and tooling, and cover query performance techniques for the data warehouse.

Back to Top

Back to Top

Roman Dobrik, Exilor
SOA and BPM
Implementation of Different BPEL Development Patterns
Using real life scenarios this presentation will explain different BPEL implementation patterns. A critical part of every SOA project is exception management; I will explain how to define and handle various business and system faults and make the solution unbreakeable. In the secont part I will explain how BPEL Process Manager and adapters can deal with sequencing problem (guaranteed message order).

Back to Top

Lonneke Dikmans, Approach Alliance
SOA/BPM
Top Ten Tips: Best Practices for Designing Services, Events, and Business Processes
Like PL/SQL and Java (JEE) there are do's and don'ts in service design and process design that can help you avoid mistakes and increase the success of your SOA implementation. In this presentation I will present a top ten of best practices that I gathered from different projects and different industries (utility, financial services and government). The examples range from service design, to events, to process design, and include both best practices and common mistakes.

Back to Top

Back to Top

Back to Top

Paul Dorsey, Dulcian, Inc.

Back to Top

Paul Dorsey, Dulcian, Inc.
Web Architecture and Development
Oracle Fusion Middleware—Tales from the Trenches
The Oracle Fusion Technology stack is large and complex, encompassing many components. Some parts are free or nearly so such as JDeveloper, whereas other portions carry large licensing fees (WebCenter). What portions of the Fusion Middleware stack are organizations really using? How have their projects fared so far? This presentation will discuss the results of a number of projects from organizations that are using one or more parts of the Fusion Middleware technology stack.

Back to Top

An Architectural Review of Application Express
Paul Dorsey, Dulcian, Inc.

The popularity of Application Express (APEX) is growing because it is easy to learn and use. But what is really happening behind the scenes? What is the internal structure of the APEX architecture and grammar? What are the implications for developers/organizations evaluating this product for use on their projects? This presentation will review the underlying architecture of APEX including the binding layer, layout model, and scripting language and evaluate its effectiveness for designing web applications.

Back to Top

Susan Duncan, Oracle Corporation
Web Architecture and Development
Tooling Up for ALM 2.0 with Oracle Team Productivity Center
Application Lifecycle Management (ALM) can be described as the management of lifecycle development practices (requirements, tasks, defect management, etc.) fused together through application of process, reporting, traceability, and collaboration. Many teams use best of breed ALM pieces, but do they work together? Can you relate tasks to requirements or tag bugs and source code? Can developers work collaboratively in their IDE? In a world where software development teams work across organizations, time zones, cultures, and business functions they need ALM pieces that are closely integrated and lead to better productivity. This presentation will demonstrate how Oracle Team Productivity Center in JDeveloper facilitates this productive team working and collaboration through the integration of your existing ALM assets plus additional centralized and customizable services.

Back to Top

Susan Duncan, Oracle Corporation
Web Architecture and Development
5,000 tables, 100 schemas, 2000 developers
The data modeler of choice for Fusion Applications Development JDeveloper 11g contains many features specifically developed to support Oracle Fusion Applications development, but these are features that can benefit any team concerned with enterprise application development - regardless of scale or complexity.
This demonstration-driven presentation will showcase some of the team-working features such as standards and version management, and reporting and impact analysis and the highly usable and scalable data modeling in JDeveloper.

Back to Top

Mike Durran, Oracle Corporation
Business Intelligence and Data Warehousing
Everything You Need to Know about Migrating a Discoverer System to Oracle BI Enterprise Edition
Everything you need to know about migrating Discoverer to Oracle BI EE including planning a migration business case and technical details of migrating metadata and worksheets.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Steven Feuerstein, Quest Software
Database Development
Coding Therapy for Software Developers
We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. Steven will in this session offer an intensive coding therapy session to help all attendees come to grips with their innate, unavoidable "issues", making it easier to write better code - and help others on their team write better code.

The following topics will be covered in this session:  Don't be afraid to ask for help (with a touch of dream therapy); How does this code make you feel?; Shock therapy (SQL is not your best friend.);  Battling the inner code sociopath (the eternal optimism of the code-full mind); Couples therapy (developer and database administrators, developer and manager).

Back to Top

Steven Feuerstein, Quest Software

Back to Top

Steven Feuerstein, Quest Software

Back to Top

Steven Feuerstein, Quest Software
Database Development
Automated testing options for Oracle PL/SQL
This session talks about the challenges of testing, takes a look at typical testing in the PL/SQL world, and reviews some of the tools, from open source to commercial, that offer varying levels of testing automation.

Back to Top

John Flack, Synectics for Management Decisions
Oracle Tools
Extending SQL Developer—It’s Easier than You Think
How to extend SQL Developer with user-defined reports, external tools, XML extensions, and Java extensions. Examples include reports and navigator extensions for the Oracle Designer repository.

Back to Top

Marty Gubar, Oracle Corporation
Application Express
Intelligent Data Exploration with APEX and OLAP
Want to turn APEX into an interactive, data exploration tool? By leveraging Oracle OLAP—a rich analytic engine embedded in Oracle Database 11g—APEX users can report on complex analytic calculations and drill to any level of detail across any dimension. An Oracle OLAP cube, one parameterized query, plus one APEX report is all it takes.

Back to Top

Sue Harper, Oracle Corporation
Oracle Tools
Everyday Tasks with SQL Developer
SQL Developer is a UI for database development tasks, such as browsing and editing database objects. Instead of a feature-by-feature review, the session is primarily a demonstration, walking through a series of tasks. Supported throughout by source code control, the demo includes code-editing support in the SQL Worksheet, how to create and edit database objects and run reports. We also review migrating objects from a non-Oracle source and inspect the structures using a data model.

Back to Top

Sue Harper, Oracle Corporation
Oracle Tools
PL/SQL Development with SQL Developer
Focusing on SQL Developer’s PL/SQL support, we initially look at editing PL/SQL, code templates and snippets, and follow with PL/SQL debugging, with particular reference to debugging remote applications. SQL Developer includes a variety of code formatting features that enhance working on the SQL Worksheet editor or the PL/SQL code editor. The session also reviews a variety of PL/SQL focused features, such as code refactoring and the PL/SQL hierarchical profiler. Finally we'll review PL/SQL-related reports.

Back to Top

Roel Hartman, Logica
Application Express
How to Integrate APEX and Oracle Forms?
Now Oracle Forms migration toolkit is part of Oracle Application Express. This toolkit is not a silver bullet, so for complex Forms, labor-intensive adjustments in APEX will be necessary. To preserve past investments in Oracle Forms and to prevent unnecessary investments in APEX, it seems useful if we could integrate existing Oracle Forms in an APEX application. In this session I will show how you can integrate existing Oracle Forms in APEX pages.

Back to Top

Eric Helmer, The Hackett Group
Hyperion
Upgrade Oracle Hyperion Planning from 9x to 11.1.1
Learn how to successfully upgrade Hyperion Planning to 11.1.1 version. This presentation will describe how to install and configure the 11.1.1 release, migrate the application meta data and data, as well as users and business rules. This presentation will also include best practices description, which can help our customer to successfully upgrade their planning environment. A brief 11.1.1 functional overview will also be provided.

Back to Top

Hans Heremans, iadvise
BIDW
The Next Generation of Enterprise-wide Data Integration: Making the right choice!
Presentation & Case Study Summary:
1) Introduction to BI:
What does BI mean to you?
Common Cases
Today’s Problems, Concerns, Issues
Evolution
2) Are yesterday's tools and infrastructure still today’s best or only choice?
3) Oracle’s Data Integration Tools: OWB, ODI, ODI Suite:
-) Product Overview
-) Practical Case Study
-) Main differentiators

Back to Top

Mike Hichwa , Oracle Corporation
Application Express
Oracle Application Express 4.0
Get a first hand look at all the latest and greatest features being added to Oracle Application Express 4.0. Learn about Websheets, a brand new tool designed specifically for business users. There are many new features such as improved tabular forms, dynamic actions, better error handling, etc., together with numerous enhancements specifically to make development easier.

Back to Top

Janette Hollar, Oracle Corporation
Hyperion
Managing Migrations with Lifecycle Management
Manage the migration of Oracle’s Enterprise Performance Management System release 11.1.1 between development, test, and production with the new Hyperion Shared Services Lifecycle Management functionality. Lifecycle Management migrates applications or artifacts in a consistent and repeatable manner across environments.

Back to Top

Micaela Hoskins, Cisco
Essbase
FDQM Beyond the Basics
Most companies use the FDQM tool for one of its first two uses, user data entry into Financial Management or data entry to Planning. Cisco was one of the first companies to extend this functionality to a data entry for warehouse detailed data. Extending the data capture functionality to the capture of warehouse data gave Cisco a deep look at the strengths and weaknesses of this tool. Find out what Cisco has learned and where Cisco is road mapping the tool for use in the future.

Back to Top

Bill Holtzman, National Air Traffic Controllers Association
Application Express
Invigorate Your APEX Report Regions
The National Air Traffic Controllers Association (NATCA) built its own enterprise solutions using Oracle Application Express. Tour NATCA’s grievance tracking system and explore the possibilities of SQL Report Regions, from codeless wizards to PLSQL-generated report regions. Make your users' experience effortless using session-state protected javascript links, granular-controlled composite column displays, custom sorting, multi-purpose checkboxes, and database-driven javascript. Examine other topics such as javascript validation, security through branching, optimistic locking, and app-level activity monitoring.

Back to Top

Ann Horton, Oracle Corporation
Other
Using Oracle Data Integrator (ODI) to Meet Today’s Pervasive Data Integration Requirements
Oracle Data Integrator is a high-performance, flexible data integration platform that addresses today’s pervasive data integration requirements. ODI provides the capability to quickly integrate data from disparate systems, and to meet the full spectrum of today’s data integration challenges. ODI is being teamed with SOA, Oracle Fusion Applications, Oracle BIEE, and Oracle Essbase/Hyperion products. This presentation presents the capabilities of ODI and the use of ODI to design and develop an ODI transformation scenario.

Back to Top

James Hudson, Wisconsin Department of Natural Resources
Web Architecture (XML, Performance, Reliability, Scalability, Security, Mashups)
Web Security for Oracle Developers
Are you confused about SQL Injection? Do you know how to block cross-site scripting? If someone gets access to the database through your application, can they see passwords or credit card numbers? You need to protect that database. This presentation will provide examples (in PL/SQL, Java, and scripting languages) of how the common exploits work, and how to block them.

Back to Top

Back to Top

Kathy Hunsicker, Data 4 Insight
Application Express
Five Effective Ways to use the Power of APEX for Data Warehouse and BI Success
If you have a data mart or data warehouse—or are planning to build one—APEX could be the economical solution your organization needs. APEX provides a exceptional toolset for rapidly building Web-based, data centric applications that are extremely robust, yet easy to learn and use. In this presentation, you'll see five specific examples of how APEX can be invaluable in a data warehouse environment—examples of solutions you can use yourself.

Back to Top

Back to Top

Back to Top

Back to Top

Lucas Jellema, AMIS Services

Back to Top

Lucas Jellema, AMIS Services

Back to Top

Back to Top

Jason Jones, The Kroger Company
Essbase
Optimizing Essbase  Loads and 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 Top

Andy Jorgenson, Pinnacle
Hyperion
Advanced Financial Management
Join us for this informative session where we’ll cover some of the advanced topics and tools for financial management. We’ll give you the tuning and optimization guidelines used by consultants when implementing Oracle’s Financial Management. Examples of topics include learning how EPM Architect can simplify your application maintenance and deployment, how custom dimensions can simplify metadata, rules, grids and reports, and how Financial Data Quality Management can provide improved integrations with your source systems.

Back to Top

Chris Judson, CedarCrestone
SOA/BPM
What is a Canonical Data Model and Why do I Need One?
When used properly a canonical data model can provide great benefits in an SOA world such as loose coupling of applications, ease of integration maintenance, and a common understanding of information, but when used improperly a canonical form can create a maintenance nightmare. This presentation covers what a canonical data model is, how to create one, and common pit falls.

Back to Top

Back to Top

Basheer Khan, Innowave Technology
Essbase
Tuning Application Servers
This session presents tips and techniques for optimizing the performance of application servers for Hyperion. These tips focus on tuning the different components of Hyperion that reside on the web application server tier. Learn tuning techniques and nuances unique to the different Hyperion components that can help improve performance. This session will also cover the support of web application servers for future releases as well as web application server clustering for increased scalability and performance.

Back to Top

John King, King Training Resources
Database Development
Can I Make XML Go Faster?
Oracle has been a leader in adding XML and XML processing to the database. In many cases XML performance is not what is desired. This session will discuss factors impacting Oracle XML performance and performance improvement. Topics include: choosing correct XMLType, SecureFile/BasicFile, XML indexing, XML document design, Insert/Update/Delete issues, SQLX functions, and PL/SQL functions.

Back to Top

Back to Top

Peter Koletzke, Quovera

Back to Top

Peter Koletzke, Quovera
Web Architecture and Development
ADF On Ramp: What You Need to Know to use the ADF Fusion Technology Stack
This presentation explains and shows the development methods you will use when working in JDeveloper’s Application Development Framework (ADF) to create applications using the Fusion Technology stack. It provides guidelines for how much you need to know about the various languages used with these technologies: Java, JavaScript, XML, HTML, Expression Language, and Groovy. In addition, the presentation offers advice on how to learn what you need to know before starting Java Web development in JDeveloper.

Back to Top

Peter Koletzke, Quovera and Duncan Mills, Oracle, and Avrom Roy-Faderman, Quovera
Web Architecture and Development
A Guide to Fusion Web Development with JDeveloper 11g (THREE PART SERIES)
This presentation series, presented by the co-authors of the Oracle Press book Oracle JDeveloper 10g for Forms & PL/SQL Developers, explains how to use JDeveloper and ADF with the Fusion Technology Stack 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.

Back to Top

Christina Kolotouros, Oracle Corporation and Peter Moskovits, Oracle Corporation
Web Architecture and Development
A Marriage Made in Heaven: Enterprise 2.0 and ADF
This session demonstrates how you can quickly and easily extend your ADF application by adding WebCenter Web 2.0 services, including Documents (UCM), Discussions (Jive), Tags, Links, and Search. You will also learn step-by-step how to add portlets and Oracle Composer to your ADF application to make it customizable at run time. If you have had enough of the theory and want to see how it's all done, this session is for you.

Back to Top

Toon Koppelaars, RuleGen BV
Database Development
Semantic Query Optimization
Cost based optimization is about applying statistics of the data that is being queried. Nowadays, the optimizer has various semantic query optimization (SQO) features. SQO is about applying knowledge of data integrity constraints of the data that is being queried. With the advent of Oracle11g, the optimizer is further breaking ground in the area of SQO. This presentation will explain the concept of SQO and demonstrate how the optimizer performs this type of optimization.

Back to Top

Toon Koppelaars, RuleGen BV
Database Development
Fat Databases: A Layered Approach
The demise of client/server architecture at the end of last century gave way to lots of new approaches to build mainly Web applications. A common factor of all new approaches has been to move logic out of the DBMS and put everything in middle tier servers. This of course is absolutely wrong. Adopting a database-centric development approach will, when done right, prevent the common performance issues that midtier-centric applications are known to suffer from. To prevent PL/SQL spaghetti, one must implement a layered architecture inside the DBMS. We will introduce you to such architecture (somewhat mimicking the MVC design pattern commonly deployed in mid-tier centric applications to prevent the same) and demonstrate its implementation.

Back to Top

Shravan Kumar, Apexor
Application Express
Leveraging Oracle 10gXE, APEX and SQLDeveloper to build an MDM solution
Oracle 10gXE, APEX, and SQLDeveloper are all FREE tools that can be used in small, mid-size and large organizations by IT teams in building rapid Oracle based solutions. This technology choice platform enables IT organizations to focus on core business deliverables, while establishing their core IT strategy on a robust database, Web development and Oracle Development platform of choice.

Back to Top

Tom Kyte, Oracle Corporation
Database Development
Database Worst Practices
A lot of time is spent by IT professionals studying best practices in the industry. This presentation turns that around and takes a look at some "worst practices," the top things you can do to ensure failure, delays, and poor performance in your database applications. Instead of focusing on things to do in your database applications, the presentation looks at things you should never do. The presentation uses actual customer experiences to investigate the top ten things done wrong over and over again, and how to avoid making the same mistakes yourself.

Back to Top

Tom Kyte, Oracle Corporation
Database Development
Efficient Schema Design
Based entirely on Chapter 7 of Tom's book Effective Oracle by Design, this session takes you through the fundamentals of physical schema design. It demonstrates the various structures (hash clusters, B*-tree clusters, index-organized tables, etc.) and tells when and where you want to use them. The session closes with indexing and compression techniques.

Back to Top

Tom Kyte, Oracle Corporation
Oracle Tools
Advanced Analytic Functions
Analytic functions are the coolest thing to happen to the SQL language since the introduction of the keyword SELECT. This session explores the use cases for analytic functions, demonstrates how and where you should use them, and explains the (nontrivial) syntax behind them.

Back to Top

Cameron Lackpour, interRel Consulting
Essbase
Using MaxL to Automate Essbase
Learn the advantages and basics of Essbase and Perl through the process of compilation and practical code samples that show calling, common Essbase scripting tasks, execution, error trapping, e-mailing, third party utilities, and take home source code.

Back to Top

Back to Top

Monty Latiolais, Linebarger Goggan Blair & Sampson
Database Development
Re-introducing the SQL Model Clause
The SQL Model clause gives the developer the ability to treat the result set as if it were a spreadsheet. Powerful inter-row calculations can be applied to individual cells or a series of cells. While the SQL Model clause has been available since 2003 with the release of 10gR1, many developers have been slow to adapt. This presentation will serve as a reminder of why it should remain a valuable part of your SQL toolbox.

Back to Top

Steve Liebermensch, Oracle Corporation
Essbase
Optimizing MDX Formulas in ASO Outlines
As customers build larger application in Essbase via Aggregate Storage, they are also increasing the complexity of formulas to be rendered at query time.  This often leads to performance implications that require tuning efforts to optimize.  This session will highlight the steps to optimize complex or dependent MDX formulas in ASO outlines to increase performance.


Steve Liebermensch, Oracle Corporation
Essbase
Optimizing MDX Formulas in ASO Outlines
As customers build larger application in Essbase via Aggregate Storage, they are also increasing the complexity of formulas to be rendered at query time. This often leads to performance implications that require tuning efforts to optimize. This session will highlight the steps to optimize complex or dependent MDX formulas in ASO outlines to increase performance.

Back to Top

Bryn Llewellyn, Oracle USA
Database Development
Doing SQL from PL/SQL: Best and Worst Practices
Database PL/SQL was invented to let you do SQL. You have many choices of approach and deciding which to use for the task at hand might seem daunting. Moreover, as new features have been introduced, older ones are sometimes no longer the optimal choice. This presentation gives you a taxonomy of use cases and a taxonomy of PL/SQL's constructs for doing SQL. Then it explains how choose the optimal approach for the task at hand.

Back to Top

Bryn Llewellyn, Oracle USA
Database Development
How to Write Injection-proof PL/SQL
Googling “SQL injection” gets about three million hits. The topic excites interest and superstitious fear. This demystifying presentation explains a straightforward approach to writing database PL/SQL programs that provably guarantee their immunity to SQL injection.

Back to Top

Scot Martin, Cash America
Essbase
Essbase Optimization at Cash America: Speeding Up Essbase Cubes by More Than 90%
You’ve been to a bunch of Essbase optimization sessions and have learned some helpful theories. You even may have read the incorrect optimization recommendations in the DBA guide. What works in the real world? In this session, Scott walks you through the optimization of the Cash America Essbase cube. He’ll review key tips for designing and optimizing Essbase databases, showing you what works and what doesn’t.

Back to Top

Raj Mattamal, Niantic Systems
Application Express
Managing Larger Development Efforts using Application Express
More and more companies are using Application Express for larger development efforts. This session aims to convey many of the best practices used to efficiently coordinate larger development efforts with multiple-member teams. Among the areas to be examined are the APEX-shared component publication/subscription model, developing in multiple workspaces, and maintaining consistency across applications. Using experience from multiple large-scale development efforts, the speaker will examine these techniques in light of their relative costs and benefits.

Back to Top

Back to Top

Tracy McMullen, interRel Consulting
Hyperion
Out of the Box: Creative Solutions for Hyperion Planning
Join us to learn how we've addressed some interesting Planning requirements like applying security across different plan types. We’ll review critical design decisions when implementing Planning and learn how to think out of the box with Planning.

Back to Top

Tracy McMullen, interRel Consulting and Shankar Viswanathan, Oracle Corporation
Hyperion
Top Ten Tips for Improving Hyperion Planning
Are your Hyperion Planning forms retrieving too slowly? Does it take forever to submit your data back to Planning? Do your business rules take forever to run? If you want to improve the performance of your existing system, join Oracle ACE Directors for Hyperion, Tracy McMullen and Edward Roske as they cover the Top Ten Tips for Hyperion Planning. In this session you'll learn loading, calculation, and retrieval tricks for increasing your performance more than ninety-five percent!

Back to Top

Tracy McMullen, interRel Consulting
Hyperion
Oracle EPM Goes Beyond Hyperion: Introduction to the Oracle Business Intelligence Enterprise Edition Product Suite
After Oracle’s purchase of Siebel Systems in 2006, Oracle soon came to realize that it had found a diamond in the rough hidden among Siebel’s many products now branded as Oracle Business Intelligence Suite Enterprise Edition (Oracle Business Intelligence Enterprise Edition ) and being positioned as Oracle’s flagship BI. Our introduction will expound on how you can leverage Oracle Business Intelligence Enterprise Edition as a complete solution.

Back to Top

Kuassi Mensah, Oracle Corporation
Web and Not Java (Scripting languages (PHP, PERL, RUBY, Groovy, etc.), Architecture and Design, ODBC )
Web Scale Applications with PHP, Ruby and Oracle
Dynamic languages power the Web. Learn how to build quick, secure, and scalable Web sites with Oracle Database and two of the most popular languages: PHP and Ruby. This technical session focuses on the languages' database APIs and gives best practices for architecting applications. Database features such as Oracle 11g Database Resident Connection Pooling (DRCP), RAC events (FAN), and client-side result cache are shown.

Back to Top

Back to Top

Matt Milella, Oracle Corporation
Essbase
Top Five Essbase CDF's
In this session we will demonstrate how to install and use a CDF (Custom Defined Function) in Essbase. We will also walk through some of the most popular CDF categories including an overview of J-Export. CDF categories include; exporting data (J-Export), importing data, accessing Web content (stock quotes, other Web services), outline changes with the Essbase JAPI, and general utility functions for tuning and debugging Essbase calculations.

Back to Top

Cary Millsap, Method R Corporation
Database Development
Making Friends with the Oracle Database
The difference between a high-performance application and one that breaks down under load often comes down to how well the application developer understands the database underneath the application. This session describes, from a developer's perspective, the most important code paths inside the Oracle kernel that a developer needs to understand.

Back to Top

Cary Millsap, Method R Corporation
Web Architecture
Optimizing for Oracle: When? How?
If premature performance optimization is a root of evil—and I believe it is—then developers face a difficult question: When and how are you supposed to optimize? If you optimize prematurely, you face the consequences of investing resources that are, after the fact, to have been wasted. If you optimize too late, you create serious jeopardy for your customers and yourself as your applications fail to scale up to the user loads they are required to support. In this session I offer a lifeline—a process and a set of guidelines that will allow you to reduce your risk of post-production performance crises, while not requiring you to over-invest into performance apprehensions that may never materialize.

Duncan Mills, Oracle Corporation
Web Architecture and Development
Oracle Application Development Framework Binding Internals: Understanding What You Are Building
Oracle ADF offers a radically simpler way to develop Java applications using a declarative and visual approach. But what actually happens when you drag and drop to create your application? This session guides you through Oracle ADF binding architecture and how it works. The knowledge you'll gain in this session will show you the path to resolving more complex application requirements with Oracle ADF. 

Duncan Mills, Oracle Corporation
Web Architecture
Fusion Design Fundamentals


In this session we'll look at some of the core design patterns that have emerged out of Oracle's own Fusion development project to create the next generation of business applications. Although the scale may be very different from the work you are undertaking, many of the principles are identical, and the core aim of maximizing developer productivity is key.

Back to Top

Damon Mittleider, Ranzal & Associates
Other
BI for the BlackBerry Crowd
BI for the BlackBerry Crowd will explore options available in pushing data to the growing number of smart phones through both the Oracle Oracle Business Intelligence Enterprise Edition and Oracle-Hyperion EPM platforms, and best practices on delivering data in ways that are friendly to the multitude of devices on the market.

Back to Top

Ron Moore, Marketing Technologies Group
Essbase
Advanced Calculations for Forecasting and Driver-based Budgeting
This session will demonstrate some modeling structures that can be used for revenue modeling and others for expense modeling. We will also look at Essbase’s predictive modeling functions. We will examine some new Version 11 modeling features and we compare BSO and ASO based approaches. Topics will include: driver based budgeting structures; modeling sales pipeline; modeling step functions; modeling penetration curves; using the @Correlation and @Trend functions.

Back to Top

Daniel Morgan, University of Washington
Database Development
What's New in Oracle Audit Vault
Oracle ACE Director Dan Morgan will present a live Oracle Audit Vault collecting consolidated data from Oracle, SQL Server, and DB2 databases.

Back to Top

Back to Top

Chris Muir, SAGE Computing Services
Database Development
Back to Basics: Simple Database Web Services without the Need for SOA
This session will explore basic Web service terminology like HTTP, SOAP, WSDL, RPC versus document styles. We’ll also take a look at options for consuming Web services from the Oracle Database, investigating utl_http and utl_dbws packages for consuming Web services, publishing native Web services from the Oracle 11g Database, and Web service software development considerations.

Back to Top

Mauricio Naranjo, Oracle ACE Director/Lucasian Labs/Oracle DATUM

Back to Top

Shyam Varan Nath, IBM
BI/DW
Master Data Management (MDM): An Integral Component of BI Application
Here we will de-mystify MDM and show its relation to the typical organization to manage the master data for customers/products/suppliers.

Attendees will understand the role of MDM and the applicability to their environments. Using Oracle Customer/Product data Hub, we look at the different components of MDM and their implementation details. Next, we will look at the impact of MDM to the existing ERP/application systems (data sources) and Operational and Strategic BI Reporting as targets.

Back to Top

Curtis Neumann, AT&T
Hyperion
How To Collect Budget Data Across 20-30
Collecting very granular Plan data with more than twenty dimensions in Hyperion Planning, which uses Essbase as its underlying data storage repository, is challenging due to the inherent issue with Essbase’s poor performance beyond fifteen dimensions. Hyperion Planning’s Smartlists in combination with a data link to an ASO cube creates the ability to collect very granular data and provide powerful analytics with great performance on both ends.

Back to Top

Anton Nielsen, C2 Consulting
Application Express
How to Hack an APEX Application
All HTML applications have characteristics that expose them to potential hacking. We will explore these characteristics as they pertain to Oracle Application Express, concentrating on where APEX exposes the application to hacking and where developers may open up hacking opportunities. We will show how to secure against all of the techniques we demonstrate.

Back to Top

Anton Nielsen, C2 Consulting
Web Architecture and Development
How to Hack an ADF Application
Because ADF applications run as HTML applications they have characteristics that expose them to potential hacking. We will explore these characteristics as they pertain to Oracle ADF, concentrating on where ADF exposes the application to hacking and where developers may open up hacking opportunities. We will show how to secure against all of the techniques we demonstrate.

Back to Top

Alex Nuijten, AMIS Services
Database Development
SQL Holmes—The Case of the Missing Performance
In this case study steps are taken to undercover the cause of a poorly performing SQL statement. Why did this query suddenly start behaving badly? Did the database just "have a bad day"? Or is the application developer to blame? Why is the DBA behaving so suspiciously? Use the tools of the trade to uncover the real cause.

Back to Top

Chris Ostrowski, TUSC—A Rolta Company
Web Architecture and Development
Developing Your First Web Service
Web services are the foundation of service-oriented architecture (SOA). Being able to create Web services from your existing applications can be a steep technical challenge, however. Web services make use of numerous technologies (such as Java, XML, SOAP, et al) that many Oracle developers are not familiar with. This presentation will explain what Web services are, how to create them easily using both Oracle and commercial tools and how to begin constructing your service-oriented architecture environment.

Back to Top

Bharat Pappu, VISTA TSI
Application Express
Integrating DHTMLX Components with APEX
Make your Oracle APEX Web application look rich and provide sizzle by integrating your Oracle APEX application with one of the best DHTML and JavaScript UI component libraries. This session will showcase real world examples on how to integrate Oracle APEX with dhtmlxTree, dhtmlxGrid, dhtmlxTreeGrid, and other dhtmlx products. I will provide live demonstrations with both small and large datasets and share some tips and tricks to overcome potential performance issues.

Back to Top

David Peake, Oracle Corporation
Application Express
Converting Oracle Forms to Oracle Application Express 3.2
This session will introduce Oracle Application Express and outline using it to convert Oracle Forms applications. Learn what is provided and what you need to convert manually. Any conversion needs to be treated as a project, however, with the ability to examine and annotate every Forms components within the APEX project, this tool greatly enhances your ability to track progress.

Back to Top

David Peake, Oracle Corporation
Application Express
Introduction to Oracle Application Express
So you keep hearing a lot about Oracle Application Express or APEX. This is your chance to learn all about it. This session is designed for those who know nothing about APEX but want to learn about one of the fastest growing development tools. The session will cover positioning, how to get started, and ways you can use APEX to get radical return on investment.

Back to Top

Nihar Parikh, Kerdock Consulting
Essbase
Using Oracle Data Integrator with Hyperion Essbase
Learn how to consolidate data load processes for separate applications in Hyperion Essbase and using the Oracle Data Integrator.

Back to Top

Darin Pope, Pride International
Hyperion
Workarounds for Everything That's Missing in Hyperion Planning
Hyperion Planning can do ninety-five percent of what we want it to, but how do we deal with the five percent that it can't handle? Have you ever wanted to do things like change the graphics and wording inside Planning, link two page drop-downs together, add validation run custom audit reports, or modify the outline on the fly? You'll want to join us as we demonstrate workarounds for all those things that bug you in Hyperion Planning.

Back to Top

Samrat Ray, Oracle Corporation and Anad Vikas, Oracle Corporation
SOA/BPM
SCA-based 11g SOA Suite—Enabling a Unified Platform for Building SOA Services
Service Component Architecture (SCA) is a set of specifications which describeS a declarative model for building and composing services using a service-oriented architecture (SOA). An SCA-based infrastructure decouples service implementation and service assembly from the details of individual product capabilities, technologies, and the access methods used to invoke services. This presentation describes how products within Oracle SOA Suite 11g leverage an underlying SCA-based infrastructure to provide a unified development, management, and runtime experience. Each SOA product is loaded by the underlying SCA system either as a service engine or a binding component while all metadata is packaged within a composite. This presentation also shows how a developer can build services that span multiple products within a single unified JDeveloper environment and deploy the same to a single SCA runtime.

Back to Top

Mark Rittman, Rittman Mead Consulting and Venkatakrishnan Janakiraman, Oracle
Business Intelligence and Data Warehousing
Creating Hybrid Essbase/Relational Oracle Business Intelligence Enterprise Edition Logical Models
This presentation looks at techniques to bring Essbase and other multidimensional data into your Oracle BI EE semantic model, both standalone and integrated into existing relational data sources, and examines how Essbase and other OLAP servers can extend the calculation capability of the Oracle BI Server.

Back to Top

An Oracle BI EE Optimization Methodology
Mark Rittman, Rittman Mead Consulting
This presentation proposes a methodology for optimizing the performance of Oracle BI EE systems, from the database query through to the BI Server and requests generated by the BI Presentation Server, including clustering, summary management and use of diagnostics.

Maiko Rocha, Oracle Corporation
Web Architecture
Extreme Faces Makeover - Inject ADF Faces Rich Client Components into your old wrinkled applications
The session will discuss some user interface development strategies and implementation techniques by exploring and reconstructing some well known Web sites with Faces.

Back to Top

Grant Ronald, Oracle Corporation
Web Architecture and Development
JDeveloper and Oracle ADF - How to Preserve Your Forms Skills in a Fusion World
You already know how to build applications fast with Oracle Forms—so how do you preserve your Oracle Forms development skills in the new Fusion World? This session shows you how Oracle ADF and Oracle JDeveloper provide you with a similar development approach to the Forms builder. Come and learn why JDeveloper and Oracle ADF are the logical next step for developers who are looking to update their skills. See how concepts that are familiar to you from the Oracle Forms development environment translate into Java equivalents—and also learn what becomes simpler with Oracle ADF.

Back to Top

Grant Ronald , Oracle Corporation
Oracle Tools
Oracle Forms, Web Services, and SOA: How to Make it all Work
We all understand the database interaction side of Oracle Forms, but how do you leverage your investment and integrate Oracle Forms in an SOA and Web services world? How can Forms hook into services? This technical presentation will demonstrate and explain how, when, and why you can integrate Forms with services (and also when you shouldn't). Using features of 10g and 11g Forms you will see how Forms can integrate with a wide variety of technologies including Web services, Javascript, BPEL Java Queues, and asynchronous service providers.

Back to Top

Grant Ronald, Oracle Corporation
Web Architecture and Development
Become Fusion Developer with no Java! (Two-Part Series)
Want to be a Fusion Developer but don't think you know enough (or anything) about Java? Oracle JDeveloper and Oracle Application Development Framework (ADF) is at the heart of Oracle's Fusion Development. But you've heard that Fusion Development means drowning in a sea of acronyms and complicated Java coding, Right? Wrong. This Masterclass takes you through the complete lifecycle of building a Fusion Application, from building your business services, adding validation logic, building templates, creating rich web pages, reusable UI components, templates, drag and drop, popup screens, shopping carts and pie charts; all without a single line of Java. Presented by ex-Forms and PL/SQL developers, the masterclass with explain how Oracle ADF and JDeveloper 11g provide runtime and design time productivity features to enable you to become a Fusion Developer.

Back to Top

Luis Rubio, Morgan Stanley
Hyperion
Advanced Web Analysis
This one hour presentation will show you how to enhance the end user reporting and analysis experience in Web Analysis using custom dashboards, guided paths and menus, drill-through reporting, linked reporting, and other advanced design features. Learn how to deliver more investigative navigation capabilities to your end users and tips on getting the best performance. Specific topics include advanced dashboards, advanced analytics, asymmetrical views, design features, and improving performance.

Back to Top

Hans Heremans
Business Intelligence and Data Warehousing
The Next Generation of Enterprise-wide Data Integration: Making the right choice!
A cohesive data integration strategy is needed to address today’s explosion of volume of data and to take cost-cutting measures. It’s a new paradigm that keeps the balance between application and data perspectives whilst tackling enterprise wide integration projects. An enterprise wide data model is needed to govern the business-value and to define a strong architecture around data movement, data quality, data synchronization, data management, and data re-use.
During the presentation a practical overview will be given of the Data Integration and Management requirements that are needed for data integration projects today. Having a look at the different aspects that aren’t addressed in current integration projects and how these can be leveraged using different data integration strategies. Using Oracle Warehouse Builder, ODI or ODI Suite, you're able to address enterprise-wide data integration projects.

Back to Top

Michael Rosenblum, Dulcian, Inc.
Database Development
PL/SQL Collections: Processing Datasets Your Way
The amount of data being processed by databases is steadily increasing and Oracle continues to provide more options and features to keep up. Different types of collections (associative arrays, V-arrays, nested tables) support the strategy of processing as much as possible in memory using fewer iterations. Using collections requires in-depth understanding from a performance tuning standpoint. This presentation describes problems that can be solved using different collection types and some useful tips.

Back to Top

Edward Roske, interRel Consulting
Hyperion
How to Save Barrels of Time and Money: Implementing HFM in Less Than Six Months
Most consulting companies won’t tell you but it shouldn't take twenty-four, twelve, or even six months to implement HFM. Some companies have implemented HFM in six months or less (we even know of one who did it less than ninety days). What are they doing right and how can you follow the same steps to getting HFM up and running with happy users? We’ll show you how to save money and chop your implementation time.

Back to Top

Avrom Roy-Faderman, Quovera
Web Architecture and Development
Extreme Reusability for Oracle JDeveloper and ADF
Extreme Reusability is an Oracle ADF Fusion development methodology intended to accomplish the following goals: Maximize reuse of code, Enable productive team collaboration, isolate the need for Java skills to a small section of the development team. This presentation will provide an explanation of Extreme Reusability, including its techniques and prescriptions for development.

Back to Top

Avrom Roy-Faderman, Quovera
Web Architecture and Development
Package-Based ADF
Oracle ADF does not, out of the box, support the creation of business components based on package APIs, making it difficult to integrate existing package APIs into an ADF application. This presentation shows how to implement just four Java classes that allow one hundred percent declarative creation of an arbitrary number of package API-based business components.

Back to Top

David Schleis, Wisconsin State Laboratory of Hygiene
Web Architecture and Development
Discovered at Last: The Holy Grail(s) of Java Web Application Development
Java Web development cannot be considered a trivial task, and depending on the complexity of the endeavor, can seem more like an epic quest than an IT project. This hero's journey begins with the selection of the appropriate technologies and frameworks from the myriad choices available. Once you have made these decisions the task of coding is itself a trial that can make the strongest doubt themselves. However, if you have chosen wisely, and proven yourself worthy by successfully completing the task, your glorious reward is more of the same. Fortunately, we do not need DaVinci's code to help us solve the mystery of simpler Java Web development; the solution is Grails. Grails is a Web 2.0-friendly framework for Java that promotes simplicity and convention over configuration by leveraging the Groovy language. Groovy is a dynamic language that provides the power of Java with a more expressive syntax and much less code. Grails also incorporates other best-of-breed projects to support a full-stack framework. Spring provides the Inversion of Control container and wrapper support, Hibernate is used for object-relational mapping, Quartz provides job-scheduling capabilities, and SiteMesh is used for layout-rendering. This presentation provides an introduction to Web development using Grails that will inspire and enable attendees to begin building Grails applications today.

Back to Top

Michael Schrader, Oracle Corporation
Hyperion
Oracle OLAP vs. Oracle Essbase: Which Product is Better?
Oracle traditionally has recommended building cubes using its Oracle OLAP database option. In 2007,Oracle bought Essbase, so now the big question is, which product is better for building cubes? In this session, we'll take the world's two foremost experts in Oracle OLAP and Essbase and have them put their products head-to-head. Will only one survive or will different products prove the right solution in different situations? Come to this presentation to see how our "Shootout at the OLAP Corral" turns out!

Back to Top

Glenn Schwartzberg, InterRel
Essbase
Little Used Features of Essbase (Like Data Mining and Triggers!)
Hold onto your hats as we take a ride into unknown territory for many. Get out your map as we navigate through the session learning about some of the lesser used features of Essbase. Have you wondered about Reference Cubes? You didn't even know they existed, did you? Have you ever used a trigger? Find out how! Travel down the road to data mining where you can find nuggets of gold. We will take a few detours along the path as we explore some side streets and overcome some bumpy hills. Relax, it will be a smooth trip through the forgotten and unexplored Essbase world.

Back to Top

John Scott, APEX Evangelists
Application Express
Increasing Scalability with Oracle Application Express
Oracle Application Express makes it incredibly easy to quickly develop applications, however what can you do if those applications need to scale to support large numbers of users? This session will focus on the many different areas (both inside and outside of the application itself) which you can leverage to increase the scalability of your application. This session is not just of interest to those people looking to build large applications, even the smallest of application can benefit from some of these techniques too!

Back to Top

John Scott, interRel Consulting
Hyperion
Advanced Financial Management
Join us for this informative session where we’ll cover some of the advanced topics and tools for financial management. We’ll give you the tuning and optimization guidelines used by consultants when implementing Financial Management. Examples of topics include learning how EPM Architect can simplify your application maintenance and deployment, how custom dimensions can simplify metadata, rules, grids and reports, and how Financial Data Quality Management can provide improved integrations with your source systems.

Back to Top

Michael Schrader, Oracle Corporation
Hyperion
Oracle OLAP vs. Oracle Essbase:Which Product is Better?
Oracle traditionally has recommended building cubes using its Oracle OLAP database option. In 2007, Oracle bought Essbase, so now the big question is, which product is better for building cubes? In this session, we'll take the world's two foremost experts in Oracle OLAP and Essbase and have them put their products head-to-head. Will only one survive or will different products prove the right solution in different situations? Come to this presentation to see how our "Shootout at the OLAP Corral" turns out!

Back to Top

Shay Shmeltzer, Oracle Corporation
Web Architecture and Development
Data Visualization for Web Applications - Graphs, Maps and more
This presentation will show you how to add Graphs, Gauges, Geographic Map, Gantt Chart, Pivot Table, and Hierarchy Viewer components into your Web user interface. We'll review the Amit Jasuja ADF Data Visualization components  a set of rich, interactive JSF components that provide significant graphical and tabular capabilities for visualizing and analyzing data. 

Back to Top

Marc Sewtz, Oracle Corporation
Application Express
Advanced Report Printing with Oracle Application Express and Oracle BI Publisher
This session will provide an overview of the PDF report printing capabilities built into Oracle Application Express (APEX), discuss some of the printing enhancements introduced in APEX 3.1, and include a live demonstration of how to create custom RTF report templates, include charts and images, and utilize the print API for scheduled generation and e-mailing of reports.

Back to Top

Mark Simpson, Griffiths Waite
SOA/BPM
Process, Process, Process—But Which Tool to Use?
Business Processes (analysis, execution, and management) are becoming a key part of any IT architect agenda, but it is often unclear how all the tools fit together. This session will clarify the boundaries between the three strategic Oracle Business Process Management technologies—BPA, BPEL, and BPM—and illustrate a case where all three have worked together to great effect for both business and IT.

Back to Top

Scott Spadafore, Oracle Corporation
Application Express
APEX Security Essentials
Oracle Application Express offers several built-in features which promote application security. We will explore how Oracle Application Express developers can build applications hardened against common security threats including cross-site scripting and SQL injection. In addition we will demonstrate the use of the Session State Protection feature which focuses on preventing adventurous or malicious users from tampering with URLs and manipulating other program inputs in ways that cause an application to behave in ways contrary to the developer's intention. Finally, we'll look at some new security features having to do with session expiration, encrypted session state, and password security.

Back to Top

Scott Spendolini, Sumner Technologies
Application Express
Many to One: Managing Multiple APEX Applications as One
This session will outline and demonstrate a number of different APEX features and techniques that when combined, can provide a robust, single point of user access management for a suite of APEX applications—all without the addition of any middle-tier or single sign-on software. The session will also include demonstrations of all topics discussed.

Back to Top

Scott Spendolini, Sumner Technologies
Application Express
Extreme Makeover: APEX Edition
This session will outline the steps and skills required to create a custom look and feel for your APEX applications. It will include a live demonstration of how to incorporate an existing look and feel into APEX templates.

Back to Top

Brian Spendolini, Oracle Corporation
Application Express
Oracle Application Express on the iPhone
Everyone has an iPhone—so why not use it? With the fully functional Web browser learn how to take your existing templates and modify them for the iPhone. Also learn how to write an APEX app and make it look like a native iPhone app.

Back to Top

Tim St. Hilaire, BAE SYSTEMS
Application Express
Utilizing jQuery and Yahoo UI components to Compliment APEX Development
 APEX developers can utilize the third party components of J-Query and the Yahoo YUI tool set to add rich user interface components to their  APEX applications. Common problems such as wait processing, dialog boxes, and auto-completions will be shown. Options, issues, and solutions found will be discussed. A review of implementing and managing the source files of each library will also be discussed and demonstrated.

Back to Top

Scott Stegemann, Opis Resources
Application Express
Integrating  APEX and PL/FLOW
PL/FLOW is an open source workflow engine written in PL/SQL. If the Oracle Workflow product is overkill, and hard coding submit, review, and approval events does not meet the dynamic business requirements of your next APEX application, PL/FLOW may be your answer. This session will show how to integrate PL/FLOW, which has its own set of metadata tables just like APEX, with a simple APEX workflow example. We will explore and implement changes to an existing workflow sequence without having to make any changes to our APEX application. An APEX administration application will be used to manipulate the PL/FLOW metadata and demonstrate how the different PL/FLOW "pieces" fit together to provide a data-driven workflow solution.

Back to Top

Jason Straub, Oracle Corporation
Application Express
Integrating Web Services with Application Express
Application Express has supported consuming Web services since version 1.5. Starting with version 3.0 the feature Manual Web References was introduced for maximum support of Web services. This session will cover interactions with Web services based on consuming a WSDL as well as manual Web references. The session will also cover cases where neither approach is appropriate. Finally, there will be a preview of new functionality planned in the next major release of Application Express.

Back to Top

Mark Thompson, Vlamis Software Solutions
Business Intelligence and Data Warehousing
Tales from the Front: Strategies for a Successful Oracle Business Intelligence Enterprise Edition Implementation
Just getting started with Oracle Business Intelligence Enterprise Edition ? Come join us for a fun, fast-paced exploration of the keys to a successful Oracle Business Intelligence Enterprise Edition implementation. Using examples taken from real projects, we'll investigate some of the do's and don’ts that will help make your Oracle Business Intelligence Enterprise Edition project a roaring success!

Back to Top

Margaret Tompkins, USMC
Oracle Tools
Data Modeling with Oracle SQL Developer
Attention all data modelers! Come check out all the awesome features in Oracle SQL Developer Data Modeling. It supports three impressive levels of data modeling: logical, relational, and physical. Wizards allow forward/reverse engineering and DDL generation. Import from and export to a variety of sources and targets with many formatting options. The early adopter release is rock solid but much more will come in future releases. You won’t need Designer anymore—it’s that good!

Back to Top

Tom Tortolani, Star Analytics
Essbase
How Essbase Thinks
Join Tom Tortolani for an informative session designed to give you a thorough understanding of what actually happens when you are creating BSO and ASO cubes. Go beyond “laboratory theory” and learn what Edward has gathered from more than ten years of experience with Essbase customers. Examples of topics include how data is compressed and how data is loaded internally into memory. For a true “insider’s view,” don’t miss this session!

Back to Top

Lester Trough, The Hackett Group
Hyperion
It’s Stable and I’m Convinced: Now How Do I Upgrade to Hyperion 11x?
Thinking of upgrading to Hyperion 11x from an earlier version? Then you definitely don’t want to miss this extremely informative and relevantly timely presentation on upgrading to 11x. We’ll tell you all you need to know in order to make the transition to 11x as smoothly and seamlessly as possible and, more importantly, how to do it right the first time!

Back to Top

Natascha Tuekoer, Sphinx IT Consulting
Application Express
Move on from Oracle Forms to Oracle APEX!
You are a knowledgeable Forms developer and you aim to move to APEX? Excellent decision! You already bring a good part of the most important qualifications with you, which are PL/SQL and SQL. The next things you need to know are the basics about APEX architecture and the major differences between Forms and APEX.

Back to Top

Clemens Utschig, Oracle Corporation
SOA/BPM
From Build Your Own (BYO) to Fusion Design—Working With Fusion Architecture and Tooling
This session introduces you to the major components and concepts of the upcoming Oracle Fusion Middleware 11g: the model, what you can do with it, business processes, business rules, the aspect of the human in SOA, Web 2.0 and collaborative features, and boosting productivity with end users.

Back to Top

Clemens Utschig, Oracle Corporation
SOA/BPM
Cracking the Tough SOA Nuts: UI Interaction and Transactions, the Service-Oriented Way
When it comes to SOA design most of the major challenges have been resolved over the last few years. However User Interface (UI) interaction, paired with asynchronous services and an articulated need for transactional behavior is required within many contemporary service-oriented solutions. This session will explore these challenges and present best practices and proven design patterns for overcoming them.

Back to Top

Wilfred Van Der Deijl, Eurotransplant
Oracle Tools
Oracle Forms 2.0
Many organizations see the potential of new technologies such as ADF, RIA, BPEL, Ajax, and SOA but also have a large investment in existing Forms applications. Not many realize these existing forms can be combined with these new technologies in a single hybrid application. This allows you to leverage your Forms investments until there is a business need to migrate or rewrite, not any sooner. We will talk about the benefits of this hybrid approach and the supporting tools.

Back to Top

Ronald van Luttikhuizen, Approach Alliance
SOA/BPM
Customer case: Implementing SOA in a database-centric environment
Customer case describing the realization of SOA in a database-centric environment for a Dutch car leasing company. The presentation will provide an overview of the architecture and conclude by providing several best practices and difficulties that were experienced during this project. Covered topics include how to transform from a more traditional database-centric environment into an SOA-environment and whether the database is suitable for delivering services.

Back to Top

Gauther Vasseur, Google
Essbase
Integrating Reporting and Analysis Products : Get more of your Enterprise Performance Management with BI
Business Intelligence solutions are the face of Performance Management. Extending their use beyond intermediate data processing or just final reporting can not only maximize return on investment but also increase overall process quality and efficiency while dramatically improving user experience. Learn new ways of positioning BI and analytics when overall process performance is your key driver.

Back to Top

Dan Vlamis, Vlamis Software Solutions
Having your Business Intelligence the Way You Want It!
Business Intelligence and Data Warehousing
Oracle Business Intelligence Suite provides a broad foundation for BI reporting that can be extended to allow even more flexibility. In addition to the existing reporting options implementors can also use the Apple iPhone to allow mobile access to reports and queries. Using the new features of JDeveloper 11g even custom applications can be built to access the same data repository.

Back to Top

Sten Vesterli, Scott/Tiger A/S
Oracle Tools
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 including: Application Express, Application Development Framework—ADF Faces for Web applications, Oracle Forms, Oracle Portal, and Oracle WebCenter. The presentation  concludes with a “hot or not” summary of which application development approaches you can expect to be using in the coming years.

Back to Top

Leonard Vitello, greenEPM
Essbase
Build Sustainability Dashboards with Oracle Interactive Dashboards and Answers Powered by Essbase
Join us for this exciting session on building a sustainability dashboard with Oracle Interactive Dashboards, and perform sustainability analysis with BI answers powered by Essbase. We will demonstrate how you can track, report, and analyze environmental performance indicators. We will focus on energy consumption, and greenhouse gas emissions from production, transportation, and travel. This session will be full of practical information to get you started on your sustainability initiative.

Leonard Vitello, greenEPM
Essbase
Ad-hoc Analysis: Using Smart View and the Essbase Excel Add-to analyze Environmental Performance Indicators powered by Essbase
There are lots of ways to analyze data in Essbase. Join us to learn the tips and tricks for Essbase analysis using Essbase, Smart View, and the Excel Add-in. We’ll review key features and functionality in each tool. The presentation will conclude with a comparison of when each product should be used.

As an added bonus, we will use “green” data in our demonstration to provide you a first look at the KPIs (EPIs) that are essential to tracking the performance of green initiatives. We’ll briefly discuss the unique challenges of collecting green data versus traditional financial data, and review the status of sustainability frameworks and standards like the Global Reporting Initiative and Greenhouse Gas Protocol.

Back to Top

John Weimar, Kerdock Consulting
Tips and Tricks:  HFM to Oracle Essbase using Extended Analytics
Essbase
Did you know there is a seamless way to combine Hyperion Financial Management information with operational data?  This session will get you there fast.  Come here how to interface between HFM and Essbase using Extended Analytics and AIS.

Back to Top

Angela Wilcox, Principal Financial Group
Essbase
It's About Time! Constructing a Cube for I.T. Analysis!
As we moved to System 9, our analysis cube was indispensible. Platform decisions were easier with comparative load and calc data. Analysis of usage let us know when the best time to roll the system over was (weekends are actually pretty busy!) Making decisions on who received a named user license was a snap. Analyzing system changes and how they affect Essbase is a breeze. This presentation will review outline, data gathering, and reports.

Back to Top

Angela Wilcox, Principal Financial Group
Essbase
Getting It All Automated With Perl Scripting
We all know – the more hands on a process the more likely we are to have errors.  Perl is an easy to learn language with a built in Essbase module (Essbase.pm) that can help you automate your entire process 100%.  Essbase.pm has been around for years.  Although a poorly documented feature, it offers the developer tremendous flexibility and power.  This session will build on the “Using MaxL to Automate Essbase Session”, and show all the basics; logging in, building dimensions, loading data, and calculating the database.  Copies of production scripts will be available to take home and get you started!

Back to Top

Patrick Wolf, Oracle Corporation
Application Express
The Quest for the Hidden Treasure of Oracle APEX
Oracle APEX offers so many functions which are not widely known but are really useful and can increase the development productivity quite a lot. You are already super productive? No problem; some of these functions are just awesome cool! Come with me on a quest to find all this hidden treasures so you can use them in your own applications.

Back to Top

Patrick Wolf, Oracle Corporation
Application Express
Paradise of an Oracle APEX Developer
An advantage of Oracle APEX is that it stores the application’s metadata in a repository in the database. There is a well-documented view layer for accessing this information. Examples in this session demonstrate the wide range of possibilities you get by reusing this information for QA checks, documentation, monitoring, and generic code. The second part of the session covers how you can safely directly manipulate the repository to do mass updates on your application’s metadata.

Back to Top

Rudy Zucca, 123OLAP
Essbase
ASO Fundamentals
Learn design tips and approaches to maximize the use of Aggregate Storage type databases. We explore some of the challenges typical in converting from Block Storage to ASO and some potential solutions.

Back to Top

Rudy Zucca, 123OLAP
Essbase
Designing Your Way Out of Block Storage and into ASO
We smell the end of the Block Storage. Although still some years away, simple strategies can be implored to build out cubes predominately in ASO. Even for Planning systems or calculation intensive applications, there are ways to design ASO cubes to address these requirements and in some cases work alongside of Block Storage applications. By going through the major sections of ASO we will cover advanced topics such as: where we are  in the cross-roads between BSO and ASO; modeling choices and structural architecture;  MDX capabilities through visual examples; aggregations and optimization; and integrating BSO and ASO.

Back to Top