Kscope12 Presentations

Check out the presentations listed below.



Power On! - How GE Lit Up Smartview and Brought Good Things to Life For Its Users
Gary Adashek, GE HEALTHCARE
Co-presenter(s):

Robb Salzmann, Accelatis

When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

During the rollout of Smartview 11.1.1.3 to over 5000 users, GEHC experienced a high number of support requests around the use and navigation in Smartview. This presentation will describe the tools GEHC's admins used to meet this challenge. Using the Smartview Toolkit and Excel, API GEHC has created enhancements to the Smartview user interface. This session will demonstrate a fully customized Excel ribbon designed to group commonly used Smartview menus and controls. This presentation will also detail the methods and tools used to make Smartview's use easier and more intuitive for GEHC's users. Easily created custom menus will be showcased along with the tools and techniques used to create them.

Back to Top
Extending ODI - Hyperion Automation and Error Trapping
Opal Alapat, TopDown Consulting
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Essbase - Subtopic: Data Management

This case study is a step-by-step look at how a global retailer implemented ODI to automate Hyperion tasks. The session will review how ODI can automate tool sets—i.e., EIS by command line, and show how ODI can be used to trap and respond to errors. This presentation will also walk through different ways ODI was used at the global retailer, showcasing how TopDown implemented some of the automated processes. And, it will include tips and tricks for implementing and using ODI. The case study will also explain how the Web interface for ODI makes it available to broader users so it is no longer an administrator tool.

Back to Top
Taming of the Shrew - Documenting an APEX Application
Dietmar Aust, Opal-Consulting
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

Writing documentation is one the most unbeloved activities in any software development project. It is boring, tedious, and already outdated once you are finished writing it. This session will present an approach to documenting an APEX application, covering the automated generation of documentation from the Oracle Data Dictionary as well as the APEX dictionary. A fair amount of time has been spent to figure out how to make documentation "work." How much detail is required in the documentation, how do we document change, how can we structure the environment so that we are actually inclined to write the documentation and keep it current?

Back to Top
Oracle Reports to JasperReports
Dietmar Aust, Opal-Consulting
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

Many customers are moving away from Oracle Forms to other alternatives. Oracle APEX is an especially interesting option because it leverages existing Oracle database skills (SQL and PL/SQL) nicely. But what about your existing Oracle Reports? This presentation will cover the open source solution, JasperReports, as a viable alternative. The session will cover the typical use cases and design patterns used when building reports in Oracle Reports and how to implement them using JasperReports. You will learn everything you need to get started with JasperReports including best practices, possible pitfalls, and integration with APEX.

Back to Top
Creating RESTful Services with Oracle SOA Suite
Deb Ayers, Oracle Corporation
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Fusion Middleware - Subtopic: SOA

This session will cover common REST scenarios using the Oracle Service Bus, a component of the Oracle SOA Suite. The session will demonstrate how to create these RESTful interfaces and then use them as a facade over other components in a Service Composite Application created in Oracle SOA Suite 11g.

Back to Top
Setting Up Ideal Development Environment for JDeveloper
Zeeshan Baig, Northwestern Memorial Hospital
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Fusion Middleware - Subtopic: ADF

So you decided to move to ADF with JDeveloper 11g as your tool of choice. But now you are confused how to setup a proper development environment in JDeveloper 11g so you can work better in a group of teams. This session will provide basic steps to setup a development environment using SVN source control, Hudson, and Team Productivity Center, as well as share the experience of experts.

Back to Top
Demystifying the Data Warehouse Administration Console (DAC)
Raja Bandhakavi, Accenture
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: BI Applications

The Data Warehouse Administration Console (DAC) plays a key role in creating and managing the Oracle BI Applications Warehouse. Understanding DAC will greatly help ETL administrators in understanding various aspects of Oracle BI Applications and will give pointers on where to troubleshoot and resolve issues. The features covered in the session will include intelligent task queue, parallelism, load balancing, index management for ETL/Query performance, and several other tips and tricks that will allow the users to build execution plans tailored to their specific needs.

Back to Top
What Would Happen if I Did... in HFM?
Christopher Barbieri, Edgewater Ranzal
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Hyperion Applications - Subtopic: HFM

On a dare, HFM expert and Oracle ACE Chris Barbieri takes a Mythbusters style approach to debunking a series of potentially damaging changes to HFM applications to find out exactly "What would happen if I did...?"

Back to Top
What's in the Box: An Intro to HFM System Utilities
Christopher Barbieri, Edgewater Ranzal
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Hyperion Applications - Subtopic: HFM

Ever wanted to add years to an HFM application without rebuilding it? How about extract the task or data audit information? Want to copy extended analytics templates from one user to another? Oracle ACE Chris Barbieri walks through more than half a dozen very useful utilities that actually ship with HFM that you may not be aware of.

Back to Top
Essbase Experts Panel
Christopher Barbieri, Edgewater Ranzal
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: Essbase
Should Invoker Rights Be Used?
Patrick Barel, AMIS Services
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Developers Toolbox - Subtopic: Coding

How can you ensure users use only their data and not someone else's? How can you do this with minimal effort? How can you get rid of multiple codebases. How can you (partially) protect yourself against SQL Injection? Explore these questions and more in this informative session.

Back to Top
Can Collections Speed Up Your PL/SQL?
Patrick Barel, AMIS Services
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Developers Toolbox - Subtopic: Coding

Collections (array-like structures in PL/SQL) are used in two of the most important performance features of PL/SQL: BULK COLLECT for data retrieval and FORALL for data modification. This session will cover these topics and more.

Back to Top
Real Cases of Indispensability of Analytic Functions
Kim Berg-Hansen, T. Hansen Gruppen A/S
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Developers Toolbox - Subtopic: Coding

Many developers have seen how smart analytic functions are, but some of them still ask "what is it really good for?"The speaker works for a major Danish retail company where more than 1000 analytic statements have been used in the source code in the course of development over the last decade. He will show several real use cases demonstrating examples of using analytic functions for solving tasks that would be difficult without analytics. At the end of the presentation, you are likely to be smitten by the analytic bug and know how to start doing this at home. As Tom Kyte says: "Analytics Rock, Analytics Roll."

Back to Top
Optimizing HFM through Configuration and Data Analysis
Jonathan Berry, Accelatis, LLC
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Hyperion Applications - Subtopic: HFM

There are many factors that can cause a Hyperion Financial Management implementation to perform sub-optimally. Problems may stem from incorrect server configurations. Other problems may be caused by your data. Zeros can creep into the data over time or SubCubes can become too dense. Several problems can be prevented or eliminated through manual inspection. This presentation will discuss the potential issues and how they can manifest to the end user. You will walk away with concrete steps to take to eliminate some of the most common problems found in HFM implementations.

Back to Top
Data-driven Rules in HFM
Keith Berry, US-Analytics
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Hyperion Applications - Subtopic: HFM

Data-driven rules are rules that generate focused transactions in response to specific data in HFM. Data-driven rules can be faster, safer, and easier to write than more standard approaches. As data volumes rise with the introduction of 64-bit HFM, the technique should be an essential part of every HFM developer's toolkit. The presentation will cover the benefits and pitfalls of data-driven rules and how to identify where they should be used. The majority of the session, however, will be spent learning the key functions of data-driven rules and working through practical examples.

Back to Top
HFM vs. Essbase BSO: A Comparative Anatomy
Keith Berry, US-Analytics
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Hyperion Applications - Subtopic: HFM

So, you're working on a joint HFM/Planning implementation and want them both to perform with lightening speed. What makes Essbase fast should work in HFM, right? Well, maybe! This presentation will compare in detail the inner workings of HFM and Essbase BSO and highlight the different strategies used by each system to process data. The session will discuss where familiar Essbase concepts such as dense/sparse, block size, dynamic calc, etc. apply to HFM and where they don't. The session will highlight the different design principles needed to optimize each system and touch on other issues (shared hierarchies, data integration) designers face on joint HFM/Planning/Essbase implementations.

Back to Top
HFM, Workspace, and FDM - Voiding Your Warranty
Charles Beyer, Prescient Solutions
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

This session will provide attendees with a selection of real world "hacks"that they can apply to their environments in order to expand functionality or improve performance. Attendees will first be presented with a low level technical discussion on how these products work and how they can leverage that knowledge. Fully working "hacks" will be provided as part of the materials, which can be downloaded from the ODTUG Kscope12 site and evaluated in their environments.

Back to Top
Troubleshooting Tools and Procedures for Diagnosing HFM, Workspace and FDM Issues
Charles Beyer, Prescient Solutions
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Hyperion Applications - Subtopic: HFM

This session will show attendees how to use a variety of third-party tools to assist troubleshooting efforts. Troubleshooting techniques will be discussed and demonstrated using real-world issues. Attendees will also have the opportunity to apply what they have learned to solve a troubleshooting mystery at the end of the session.

Back to Top
APIs - Getting Added Value from HFM, Workspace, FDM, Smartview and Shared Services
Charles Beyer, Prescient Solutions
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Hyperion Applications - Subtopic: HFM

This session will provide a high level overview of how each of the APIs work. Additionally, real-world examples for each API will be provided. Fully working code will be available for download from the ODTUG Kscope12 site which attendees can use in their own environments.

Back to Top
Planning for and Managing Your Hyperion Infrastructure
John Booth, Emerging Solutions
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

This session will cover the following topics: Infrastructure Skill Sets Sizing Tips Virtual vs. Physical Monitoring and Maintenance Troubleshooting.

Back to Top
Benchmarking Physical vs Virtual and Linux vs Windows
John Booth, Emerging Solutions
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

Ever wonder what the performance difference on the same hardware is for a Physical Server vs. Virtual or Linux vs. Windows? This presentation will break down benchmarks and lessons learned using a hardware test bed having six cores, 24 GB RAM, and RAID 10 directly attached disk in four configurations.

Back to Top
An ADF Special Report
Luc Bors, AMIS Services
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: ADF

Oracle ADF is a very powerful framework for building enterprise applications. The framework, however, has no built-in solutions for reporting. In this session, you will learn how to fill this gap by using open source reporting solutions and solutions provided by Oracle.

Back to Top
How to Bring Common UI Patterns to ADF
Luc Bors, AMIS Services
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Fusion Middleware - Subtopic: ADF

When working with enterprise applications, you want to have the same user experience that you know from for instance office applications and browsers. People know how to use the features that can be found in browsers such as bookmarking, favorites, and working with tabs. The search mechanism provided by Google, that uses suggestions based on the text typed by the user, is so common that people expect this in every application. And there are more of these UI patterns. In this session, you will learn how to implement some of the common UI patterns in your ADF application.

Back to Top
Approaching Oracle Business Intelligence Applications: A Methodology for Success
Stephen Bowden, Peloton
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Business Intelligence - Subtopic: BI Applications

Oracle Business Intelligence Applications provide significant uplift for organizations seeking to shorten time-to-value of BI investments. Maximizing the benefit of these modules requires a different approach than traditional reporting and analysis initiatives. This session will take a deep dive into the process of implementing BI applications from a business perspective, examining sample project templates to set expectations and milestones.

Back to Top
OBIEE 11g + iPads = Happy Executives: Mobile BI at General Dynamics
Stephen Bowden, Peloton
Co-presenter(s):

Stephen Bowden, Peloton

When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: OBIEE

One of the great challenges to adoption of executive dashboards is to get the target audience to use them. With OBIEE 11g, Oracle has expanded information delivery capabilities via the BI Mobile app. How do you get executive sponsorship for mobile BI?; What are the steps involved with going mobile?; What are the pitfalls related to devices, accounts, and connectivity? This session will explore General Dynamics' journey into mobile BI, examining commonly asked questions and sharing experiences encountered along the way.

Back to Top
The Functional Difference – Hyperion Services from Sirius Solutions
Michelle Bradshaw, Sirius Solutions
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Peony
Topic: Vendor Presentation - Subtopic: Vendor Presentation

This presentation is designed to inform attendees of what Sirius Solutions can offer, why it is vital to have a function lead with working experience and what can go wrong if this experience does not exist on your implementation team. Sirius Solutions’ consultants are professionals who have strong financial reporting backgrounds built on years of performing variance analysis, financial analysis, budget management, SEC reporting and other non-technical duties.

Back to Top
How to Protect Against Spaghetti Architecture in Oracle Fusion
Jordan Braunstein, Visual Integrator
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Fusion Middleware - Subtopic: SOA

Are you tired of spaghetti architecture? Do you need to mitigate risks and increase adoption of Oracle Fusion? This session will walk through turning your Oracle Fusion pasta into a fully agile enterprise. Topics include: Bullet Proof Implementation Approaches to Oracle Fusion, Potential Oracle Fusion Pitfalls and Anti-Patterns, Introduction to Oracle Fusion Patterns, Agile Methodologies for Oracle Fusion Projects, and Cookbook for Increasing Adoption of Oracle Fusion.

Back to Top
APEX - Why Not Google It
Paul Broughton, APEX Evangelists
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

This presentation shows how Google services can be integrated with APEX. The majority of Google services use the OAuth authorization process, so by including this process in an APEX application, developers will have access to a range of Google services. The presentation will demonstrate how the Gmail API can be used to access, create, and modify Gmail messages from within APEX itself. Accessing the Google Calendar is also a really useful feature that will be discussed to show how entries are created and edited from within APEX.

Back to Top
Reporting Against Transactional Schemas with OBIEE 11g
Stewart Bryson, Rittman Mead Consulting
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Business Intelligence - Subtopic: OBIEE

This presentation will examine common techniques for modeling transactional schemas as logical facts and logical dimensions in the OBIEE Business Model and Mapping Layer. Some of the common techniques that will be introduced include: presenting a physical table as both a logical fact and a logical dimension, controlling the BI Server's behavior using table aliases and logical table sources, and integrating multiple source systems' entities into the same logical table.

Back to Top
Aggregation: The BI Server Versus the Oracle Optimizer
Stewart Bryson, Rittman Mead Consulting
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: OBIEE

Aggregate navigation describes the functionality that BI systems have to use summary level data instead of detail level data for faster data access and report performance. When using Oracle Business Intelligence 11g and Oracle Database 11g, we can choose which “engine” we want to handle summary management and the navigation between different levels of granularity: the BI Server, or the Oracle Optimizer. Both methods support full summary management functionality, and either one is robust enough for an enterprise data warehouse. So which one should we choose? This presentation will walk the participants through both options, and investigate the different design paradigms that may favor one implementation over the other.

Back to Top
Tools & Processes for Efficient Development of High Quality PL/SQL in the Large
Martin Buechi, Avaloq
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

Developers need effective processes and tools to efficiently write quality PL/SQL code. Our 170 PL/SQL developers maintain and extend 12 M lines of PL/SQL code with the help of a database provisioning system that performs automated builds, executes tests, reports results, tests each code change upon check in, and gives developers their own database instance with self-service cloning and flash back from the IDE. Additionally, our installer spots a debugger with breakpoints and the option to flash back, modify, and resume installations. Code changes are branched to the right streams based on customer upgrade plans and delivered with all preconditions.

Back to Top
How I Load Data? Let Me Count the Ways...
Karen Cannell, TH Technology
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Loading data is a common APEX task. There are many ways to do it, most of which involve user cut/paste and/or custom coding. This presentation reviews APEX data load options: the common, the not-so-common, the Data Load wizard, Websheets, and the APEX Listener XLS upload. What are the APEX data load options? What are the costs involved in each? What's the best way to load data via APEX for your users, for your environment, for your budget? This presentation will demonstrate each data load option and compare the pros and cons of each. You will leave with enough information to make intelligent choices for your data load needs.

Back to Top
Higher Education Performance Management - A Custom Approach
Chris Chase, The Bean Consulting Group
Co-presenter(s):

Chris Bauman, Pepperdine University

When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Hyperion Applications - Subtopic: Planning

Pepperdine University has undertaken an initiative to improve their performance management systems and processes by upgrading to Version 11.1.2.1 of Oracle's Hyperion Planning. The implementation utilized Enterprise Performance Management Architect as a platform for development, and delivered a custom solution that has improved budgeting capabilities related to position planning, revenue planning, capital project planning, and management reporting. This presentation will explore the application and process designs, integration with the University's PeopleSoft General Ledger system, lessons learned related to upgrading to Version 11.1.2.1, the application customizations that were delivered, and a comparative analysis with the Public Sector Budgeting module.

Back to Top
Customer Panel (Aramark, Experian and General Dynamics): Better Together - Oracle EPM and ERP Solutions
Neela Chaudhari, Product Development
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: EPM Business Content - Subtopic: Case Studies/Panels

With significant investments in your Oracle ERP system--be it Oracle E-Business Suite or Oracle's PeopleSoft or JD Edwards applications--you want to maximize the return. Attend this session to get an overview of Oracle's Hyperion Performance Management applications, the industry's leading suite of analytic applications that drive management excellence. Learn how these products can integrate with transactional systems to leverage your investments and help your company deliver predictable results, improve transparency, and increase business alignment. Listen and learn directly from our customers – Aarmark, Experian and General Dynamics!

Back to Top
Oracle SQL Developer and Data Modeler New Features
Ashley Chen, Oracle Corporation
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

Whether you are new or a veteran user of Oracle SQL Developer and SQL Developer Data Modeler, you will want to learn about all the latest new features. SQL Developer introduces PDF support for reporting and more DBA-related functionality like Oracle Data Pump and RMAN support. SQL Developer Data Modeler is now tightly integrated with source code control, Subversion. This session will demonstrate the support for collaborative development through this Subversion integration. These and other interesting features will be demonstrated.

Back to Top
Disclosure Management
Karin Cheung, Oracle Corporation
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: EPM Business Content - Subtopic: EPM Business Content

Learn how to take XBRL reporting in-house with Oracle Hyperion Disclosure Management. With Disclosure Management, companies can take full control of external reporting timelines and decision-making while minimizing cost and overhead. As a component of the unified Hyperion Enterprise Performance Management stack, Disclosure Management allows filers to produce 100 percent valid XBRL filings that are directly connected to EPM data sources.

Back to Top
Customer Implementation Story on Disclosure Management
Karin Cheung, Oracle Corporation
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Hyperion Applications - Subtopic: HFM

Oracle Hyperion Disclosure Management (DM) is growing fast with implementations around the world, with the SEC in the US, HMRC in the UK, and other international regulatory XBRL mandates. Oracle product manager Karin Cheung takes you through real customer scenarios, discussing DM best practices and implementation guidelines. The session will deep dive into Oracle Corporation's own DM implementation to demonstrate how Oracle submits its own XBRL filings to the SEC via Disclosure Management.

Back to Top
Product Cost and Profitability Analysis for Process Manufacturing Industry
Srinivasa Chinnam, Deloitte
Co-presenter(s):

Ervin Peter, Deloitte

When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: EPM Business Content - Subtopic: EPM Business Content

The purpose of this session is to demonstrate a Costing and Profitability solution developed using Oracle EPM/Hyperion tools for a global process manufacturing company. Essbase BSO cubes are used to calculate actual cost of millions of lots or batches produced at every process step based on real ingredients and overhead costs. Essbase ASO cubes are used to report and analyze cost and profit by order, by customer, by product, and by market segment. Hyperion Planning Application is used for doing what-if cost modeling for future scenarios.

Back to Top
Best Practices for Agile APEX Development
Patrick Cimolini, Patrick International APEX Consulting
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Are you an Oracle Application Express (APEX) developer who has a nagging feeling that you and your team could be more productive? This set of best practices will help you hit your APEX quality, cost, and schedule targets efficiently by demonstrating practical ways that APEX can be configured to explicitly support the values, principles, and techniques of Agile software development (Agile). Developing APEX applications with an Agile mind-set enables you to reap the significant benefits that are built into this seriously practical and complementary marriage between APEX and Agile.

Back to Top
SQL Tuning in a Data Warehouse Environment
Maria Colgan, Oracle Corporation
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Database - Subtopic: Operations

Traditionally SQL tuning techniques involve gazing at a statspack or AWR report, identifying important wait events, and parameters that need attention. In a data warehouse environment, the techniques required are drastically different. Statements are rarely repeatable and the ones that are have complex execution plans involving Optimizer transformations and parallel execution. This session will discuss a straight-forward approach to tackling SQL tuning in a warehouse environment, and use real-world examples to demonstrate how you should navigate the complex execution plans found in a data warehouse environment and determine what steps are necessary to improve the performance.

Back to Top
Best Practices for Understanding and Managing Optimizer Statistics
Maria Colgan, Oracle Corporation
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Database - Subtopic: Maintenance

During the optimization of a SQL statement, the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent execution plan from becoming suboptimal. This presentation provides a detailed description of the Optimizer statistics and the features introduced in 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments.

Back to Top
Advanced Automation Techniques for Essbase Administration
Dave Collins, Ernst & Young
Co-presenter(s):

David Collins, Ernst&Young

When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Essbase - Subtopic: Essbase

One of the biggest gaps in existing EPM platforms is the inability for the packaged workflow capabilities to dovetail easily into the existing business processes of an organization. What business wants is technology to enable them to perform their jobs easier and to allow them to control the process. What IT often wants is the technology to provide access to a broad array of capabilities without requiring expansive security access rights. This session shows how to leverage the capabilities of the Oracle Hyperion Workspace to bridge this gap. Attendees will learn how to enable focused, custom workflows EPM deployments.

Back to Top
Don't Do This! Effective Strategies to Avoid Building Ineffective ASO Cubes.
Dave Collins, Ernst & Young
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Essbase - Subtopic: Essbase

This session will cover: ASO Primer (BSO vs. ASO); Dimensions and hierarchies; Stored vs. dynamic; Solve order; Outline verification; Some obvious (and not so obvious) mistakes and their solutions; Dynamic hierarchies; Calc on stored hierarchy; Brain benders; Nested dynamic calculations; Conclusions; How to avoid getting into these situations; How to get out; and Final thoughts and Q&A.

Back to Top
ASO Query Optimisation
Dave Collins, Ernst & Young
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Essbase

This session will cover: ASO Primer (BSO vs. ASO), outline optimization stored vs. dynamic hierarchies, formula optimization aggregations and views, overview developing aggregate view queries, pre-calculation conclusions, and Q&A.

Back to Top
Intro to Analysis
Kevin Cox, Lennox
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Essbase - Subtopic: Essbase

You've learned about all the tools that enable Hyperion tools and Essbase to work, and how to build some beginning databases in the technology. Now it is time to learn the true power of the Hyperion technology--ad-hoc data analysis. Assuming that the database has been built properly, ad-hoc analysis can offer tremendous insights into the business within minutes of a data request.

Back to Top
Intro to MDX + ASO
Gary Crisci, Morgan Stanley
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Essbase - Subtopic: Essbase

The paradigm has switched and the Essbase Aggregate Storage Option has become the first choice when building Essbase analytic applications. In this introductory session the Aggregate Storage Option (ASO) will be introduced and explained with highlights on features and functionality that differ from the classic Block Storage Option. Additionally, the MDX language will be introduced and discussed as a tool to build complex calculation functionality into ASO applications along with the ability to query data from Essbase applications (ASO + BSO).

Back to Top
Politics of Essbase
Gary Crisci, Morgan Stanley
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: EPM Business Content - Subtopic: EPM Business Content

This session will discuss ways Essbase can be integrated into large IT organizations where other BI tools are well entrenched. Essbase historically has been run by finance IT shops, but as the product has matured and the architecture has become more complicated, it is necessary to have IT fully committed to supporting the environment. This often brings up a lot of pressure and tension between finance and IT. Often IT has a BI tool like Business Objects already in place, and not understanding what Essbase can do they often lobby to replace it. This session will look at what Essbase does better than the competition, when it makes sense to use Essbase, and how to partner with IT to have successful implementations. Additional topics to cover would include roles and responsibilities in a distributed environment.

Back to Top
Performance Practices of the Successful Developer: Making Friends with Your DBA
Ron Crisco, Method R Corporation
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Developers Toolbox - Subtopic: Coding

User experience is the focus of most developers today, and rightly so, but production software must not only meet the needs of the end users, but also meet the needs of the operations team responsible for maintaining it. This presentation will describe the successful developer's relationship with the operations team, and the steps that should be taken during the software development process to ensure optimal performance and scalability long term.

Back to Top
Data Design for Developers: An Agile Approach
Ron Crisco, Method R Corporation
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Database - Subtopic: Design/Data Modeling

In the debates between traditional SDLC ("waterfall") proponents and their Agile counterparts, probably the biggest hinge point is the question of database design. Agile practitioners value "working software over comprehensive documentation" and "responding to change over following a plan." Is Agile, then, the enemy of proper design? What does honoring these values mean to the data design process? This session answers these and related questions.

Back to Top
Field of Reporting Dreams: Build it and Users Will Come? (How Data Visualization Can Give You an Extra Edge in Bringing and Maintaining Happy Users)
Iain Curtain, Edgewater Ranzal
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: EPM Business Content - Subtopic: Product Demos

Learn simple tricks to enhance reporting to make it easier to understand, and provide the actionable insight so users can spend time managing rather than reporting. Gain insight into how people interpret visual data, what memory limits are, how we make sense of objects, and how this new understanding should be used to deliver actionable insight to your dashboard and reporting users. Discover the limits of human perception and how to encode data for better perception, and learn how to use these to your advantage in creating reports and dashboards that speak clearly to users.

Back to Top
Building a Better Team
Martin D'Souza, ClariFit
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

As your team grows and evolves, so do some of your development problems. Most development teams struggle as they grow and try to implement top-down processes that don't always work well with developers. This presentation will guide you through proven steps and techniques to bring an unstructured development environment into a cohesive unit. The processes discussed will help you and your team develop better code, reduce development costs, and build better applications. The techniques discussed in this presentation have been successfully implemented at various organizations and have helped both APEX and PL/SQL teams.

Back to Top
APEX 4 + HTML 5 = Awesome II
Martin D'Souza, ClariFit
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

This presentation is a continuation of last year's award winning talk on some of the new HTML 5 features and how to integrate them in APEX. HTML 5 is the next major version for HTML. It consists of many new features which will make developer's jobs a lot easier and improve end-user experience. This presentation will highlight some of these new features and demonstrate how to leverage them within an APEX application. New features include (but not limited to) Drag & Drop, Media, and Graphics.

Back to Top
Why Agile Development is Bad: Issues of Complex Application Development
Marc de Oliveira, Simplify Systems
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Database - Subtopic: Design/Data Modeling

Agile or Structured Development? The War is On! Kscope has become interesting in that it is now a meeting point for the traditional database developers with focus on the stability of data models and the emerging agile, lean, x-treme developers, from the Java scene, with focus on short schedules and immediate success. This session will explain why true agility in business requires a structured approach to application development while the agile methodology will make it harder and harder to maintain applications by building up sand in the gears of applications and, therefore, eventually bring businesses to a grinding halt.

Back to Top
Scaling and Footing for External Reports in Hyperion Financial Management
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: HFM

The scaling and footing of external reports is a constant concern for finance departments when generating quarterly and annual reports. When scaling line items and totals on a per-line basis, external reporting groups must either plug differences manually or note rounding errors in financial statements. This presentation will review a rules-based solution that pushes scaling calculations, checks, and adjustments to the HFM application level. With minimal metadata modifications, users can rely on this iterative process to ensure their reporting hierarchies are rounded and footed correctly.

Back to Top
Managing an EPM Project Successfully - A Client's Perspective
Natalie Delemar, Ernst & Young
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: EPM Business Content - Subtopic: Case Studies/Panels

The goal of this session is to provide attendees with key considerations in managing an EPM project successfully from the client's perspective. The session will cover best practices, selecting and managing a consulting partner, pitfalls to avoid, and other key tasks in an EPM project.

Back to Top
Implementing MapReduce Algorithms in SQL and PL/SQL
Dominic Delmolino, Agilex Technologies
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

Many new large-scale data analysis tasks are being described using MapReduce as an implementation language. These descriptions imply that you need Hadoop and HDFS in order to fully exploit the power of MapReduce. However, since MapReduce simply describes implementation primitives, it is actually possible to implement those concepts using SQL and PL/SQL. Doing so will help database engineers more fully understand the underlying data processing activities behind typical large-scale data analysis tasks. In this presentation, database developers will learn about how to use parallel pipelined PL/SQL table functions to build MapReduce-like capabilities in the Oracle database.

Back to Top
From Administration to Collaboration, Transforming DBAs Through the Concept of DevOps
Dominic Delmolino, Agilex Technologies
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Database - Subtopic: Operations

Many DBAs have been pigeonholed into strict operational roles in which they have little ability to participate in discussions about how applications access, process, and manage data. This artificial division has led to well-known battles and acrimony between DBAs and developers. Fortunately, new movements in software development and operations are emphasizing collaboration and people over processes. When done with a focus on these principles, Agile development and DevOps operations bring benefits to developers and DBAs alike. In this presentation, you will hear about beginning this transformation within a traditional DBA organization, from steps you can take to free up maintenance time to ways to provide demonstrable value to development teams.

Back to Top
Calculating ROI for Business Intelligence Projects
Dwight deVera, arcplan, Inc.
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: EPM Business Content - Subtopic: EPM Business Content

Companies have always struggled to calculate the ROI of their BI investments. In most cases, BI adopters are realizing "soft" ROI (faster and more accurate reporting, improvements in the decision-making process, increased productivity, etc.), but concrete ROI (cost reductions, higher revenues) remains difficult to quantify. This presentation is a blueprint for calculating the ROI for your business intelligence project with simple-to-use Excel-based templates. Participants will be taken step-by-step through the tough questions to ask during the analysis. Case studies from several organizations will be presented, and common BI ROI justifications like "better reporting" will be dissected from a true business value perspective.

Back to Top
Big Data Architecture Deep Dive
Jean-Pierre Dijcks, Oracle Corporation
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Database - Subtopic: Design/Data Modeling

This session will share: An overall architecture for a big data ecosystem, consisting of solutions like the RDBMS, Hadoop, and BI tools; integration points between these tools and systems and a brief look at their strengths and weaknesses and how to use the best of all worlds in your architecture; and how to effectively leverage analytical sandboxes for data discovery and agile development of data-driven solutions.

Back to Top
Big Data: Is Predicting the Future in Your Future?
Jean-Pierre Dijcks, Oracle Corporation
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Database - Subtopic: Database

This session will define Big Data and its impact on your company. They will cut through the buzz words and define the technologies you should be paying attention to and that you should start leveraging in your company. Lastly the session will discuss some interesting new technologies for Big Data introduced at the recent Oracle OpenWorld.

Back to Top
The Art of Correctly Sizing an Oracle EPM Installation
Greg Dill, FlameBridge Consulting
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Grand Oaks F
Topic: Vendor Presentation - Subtopic: Infrastructure/Management/Security

IT infrastructure is the foundation of any successful enterprise software implementation. With a reliable foundation the implementation team can focus on delivering client requirements. If the foundation is unreliable, then many hours, if not days, of your implementation lifecycle will be burned due to mysterious errors and outages. Correctly sizing an Oracle EPM install is part science and part art. But why is there so little information available on sizing an Oracle EPM install and distributing the Hyperion services across the required servers? This presentation will unveil the best practices around sizing an Oracle EPM install and distributing the Hyperion services across the required servers.

Back to Top
11.1.2.2 Infrastructure Changes and Information
Rob Donahue, Rolta
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Infrastructure/Management/Security

EPM 11.1.2.2 represents the next evolution of the Oracle EPM Suite. This release contains a lot of new exciting functional features, but also some changes to how the application works under the covers. This presentation will highlight those changes and emphasize how they relate to previous releases. In addition information will be given on the installation, administration, and diagnostic changes.

Back to Top
Upgrading EPM Panel
Rob Donahue, Rolta
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: EPM Business Content - Subtopic: EPM Business Content

This panel of functional and infrastructure experts will answers your questions about whether you should take the plunge and upgrade your EPM system.

Back to Top
Oracle Business Intelligence Publisher: Anatomy of an RTF Template
Mike Donohue, Oracle Corporation
Co-presenter(s):

Nikos Psomas, Oracle Corporation

When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Business Intelligence - Subtopic: Reporting Solutions

Take a deep dive into the details of an RTF template and see how to put data fields into the header, calculate page totals, embed barcodes, put terms and conditions on the back of pages, get data on the last page only, and other tricks to design your highly formatted documents. Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products.

Back to Top
Do-It-Yourself Cloud Computing
Paul Dorsey, Dulcian
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Developers Toolbox - Subtopic: Coding

The IT industry currently has its head "in the clouds." There are a plethora of vendors touting "cloud solutions," many of which are very expensive to use. This presentation will cover the following topics: 1) Cloud concepts 2) Technical alternatives 3) How we created a complete development environment on a cloud 4) Why we didn't use an existing cloud product

Back to Top
End-to-End SOA Development Using the Business Rules Approach
Paul Dorsey, Dulcian
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Grand Oaks B
Topic: Vendor Presentation - Subtopic: Vendor Presentation

At Dulcian, we have been evolving the business rules approach for the last fifteen years. On our latest U.S. Department of Defense project, we achieved greater than 95 percent generation on a system that contains over five million lines of code. Dulcian’s Business Rules Information Manager (BRIM®) is a set of five tools that span the entire systems development process. This presentation will describe the theoretical rules architecture of BRIM® followed by a brief overview of each part of the tool suite. The tools support the following system development areas: 1. Database design 2. Manual and automated process flows 3. ETL (including Web Service generation) 4. Data validation 5. Web-based screen development If you miss the days of Oracle Designer–based 100 percent code generation, come to this presentation and see what the next generation of these tools provides, namely a complete SOA-based modular architecture that builds systems with a minimal hardware and network footprint.

Back to Top
Where Do We Go Post Forms? Panel
Paul Dorsey, Dulcian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

There are several alternatives for how to build systems in the "post-Forms" world. Many are using APEX or trying ADF. Others are going to .net or open source JavaEE. Some of us are wondering if a worthy replacement to Forms even exists. This presentation will be a panel of experts that have picked a technical direction and are successfully building systems. They will share their experiences and discuss their platform of choice. All of the major platforms will be represented. If you are still wondering which way to go, or are having trouble making the transition to a new platform, come to this open panel discussion to ask your questions.

Back to Top
Deep Dive into Logical and Physical Modeling with JDeveloper
Susan Duncan, Oracle Corporation
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Developers Toolbox - Subtopic: Tools

The latest release of JDeveloper offers new functionality to you if you are using UML class models to model your logical database model. The DatabaseProfile allows you to dive deep into every aspect of your model and ensure you get the physical model you want. From datatypes to database types, from primitive types to primary keys: if you need a solid reusable logical model that can be transformed into multiple physical databases JDeveloper's DatabaseProfile has the answer. Come to this demo-based session to explore just how flexible it is with the Product Manager responsible for its development.

Back to Top
Continuous Integration: Put It at the Heart of Your Development
Susan Duncan, Oracle Corporation
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Developers Toolbox - Subtopic: Tools

There's more to good development than code. Good application lifecycle management (ALM) is paramount to producing good applications. Join this session to see how Hudson CI can help you to excel! Whether it's SCM, task management, build, deploy, testing, coding standards or more Hudson's got it covered. In this session you will see how using Hudson improves code, bug handling, feedback and much more whether you are developing in the database, ADF or SOA components in fact, any type of development!

Back to Top
Get back your Labor Day Weekend with Effective Hyperion Automation
Quinlan Eddy, Star Analytics
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Verbena/Periwinkle
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Wondering how to easily sequence tasks between applications like HFM, FDM, Planning, Essbase and relational technology? Trying to create an automated daily Planning or HFM maintenance routine that keeps users out of the system? Not sure how to effectively automate processes between various operating environments (Unix / Windows)? Not sure if the required Hyperion services are running or need consistent way to start Hyperion services? ODI or Windows Scheduler not cutting it? Tired of spending time baby sitting processes instead of enjoying a cookout on a Sunday afternoon? If these questions strike a chord then this presentation takes a case study approach on how Star Command Center addresses the above challenges that face everyday deployments of Hyperion. Star Command Center is an effective and flexible alternative that reduces implementation and ongoing maintenance costs while bringing greater reliability, visibility, and timeliness to your Hyperion environment.

Back to Top
Profitability Bake Off - Hyperion Profitability and Cost Management vs. Essbase
Paul English, SC&H Consulting
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

Understanding profitability is a key goal for Enterprise Performance Management. Traditionally, we have built Essbase applications to determine product and customer level profitability. Now, Oracle has a dedicated application for this purpose, Hyperion Profitability and Cost Management. So, which is better? This session will compare the same use case built in both tools and discuss the time to build, complexity of the build, and the user experience with both options.

Back to Top
Best Practices in Public Sector Compensation Planning
Jonathan Etkin, Performance Architects
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Hyperion Applications - Subtopic: Planning

Higher education, healthcare, and government organizations are unique in the way they plan and forecast compensation. This session will provide a discussion tailored to these organizations' needs including an overview of Hyperion budgeting and forecasting tools and best practices that are in this arena today; a discussion of a Hyperion Planning product module, Public Sector Planning, and Budgeting; and case studies and examples of different ways you can use these planning processes and solutions in your organization.

Back to Top
Clean Up Your APEX PL/SQL Code
Steven Feuerstein, Quest Software
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

We like designing Web pages and user interfaces. It's a lot of fun to point and click and - like magic! - things happen. But we will have to write PL/SQL code for our APEX applications - and then all too often, we write this code in a way that makes it hard to debug, enhance, and reuse business logic. In this session, Steven will go through examples of problematic code in APEX and show how to change it so that (a) there is lots LESS code in your APEX app and (b) you can manage your PL/SQL code more easily.

Back to Top
Writing Maintainable PL/SQL Code
Steven Feuerstein, Quest Software
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Developers Toolbox - Subtopic: Coding

Software managers are very good at putting pressure on developers to "get the job done" as quickly as possible, so as to meet usually unrealistic deadlines. The end result? Applications that require lots of resources simply to fix those bugs and maintain the code. If we are going to build and deploy successful applications, we have to think not only about getting that application in production today, but also the cost of keeping it in production for years to come. This session offers a range of tips and techniques to improve the readability of your code and make it easier to maintain/evolve that code over time.

Back to Top
Error Management Features of Oracle PL/SQL
Steven Feuerstein, Quest Software
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Developers Toolbox - Subtopic: Coding

Consistent, robust error management is a critical feature of any successful application. Oracle offers a number of very helpful features, ranging from built-in functions like DBMS_SQL.FORMAT_ERROR_BACKTRACE to DML clauses, that will make it easier to identify the sources of problems and fix them more rapidly, as well as meet different business requirements.

Back to Top
High Performance PL/SQL
Steven Feuerstein, Quest Software
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Developers Toolbox - Subtopic: Coding

Users hate to wait - for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable, they must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

Back to Top
Reporting from ADF Applications - What are the Options?
John Flack, Synectics for Management Decisions
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Fusion Middleware - Subtopic: ADF

Learn how to add reports to your ADF 11gR2 application with JSF component libraries for BIRT and JasperReports and other methods. Get a look at the report design tools for these reporting libraries.

Back to Top
Develop Mobile Apps for Smart Devices: Converging Web and Native Applications
David Folk, Oracle Corporation
Co-presenter(s):

Joe Huang, Oracle Corporation

When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Fusion Middleware - Subtopic: Enterprise Architecture and Development

With the rapid advancement of mobile operating systems, developers can now use a variety of Web-based or device-native techniques to create compelling mobile applications to meet the demands of enterprise mobile users. However, to create mobile enterprise applications that support the mobile devices commonly found in enterprises today, developers basically have to develop the same application several times, using multiple tools, languages, and platforms. This session discusses how Oracle Application Development Framework and Oracle JDeveloper bring together Web and device-native technologies into a common and consistent development environment and deliver consistent and powerful composite mobile applications to end users.

Back to Top
Simplify Report Development Utilizing Best-practice Methodologies with Hyperion Financial Reporting.
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

This session will walk attendees through development ideas such as the utilization of row and column templates and reporting objects, both of which drive a development and maintenance-friendly solution. The concept of report standardization will be discussed leaving attendees understanding their importance. Reporting preferences that result in a better end-user experience and solutions to tricky report requests will also be covered. Attendees will leave with concepts that are easily implemented into their new or existing reporting environments. They will also understand some technical hurdles that they will encounter, and how to overcome them.

Back to Top
The Exadata Story
Tim Fox, Enkitec
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Database - Subtopic: Database

In this session, we will discuss why the Exadata platform is so important for the Oracle Development Community. Exadata, like any system that runs Oracle, provides value by running SQL / PL*SQL. The Exadata, however, has a Secret Sauce that enables it to process data faster than any traditional system. The catch is that the developer who writes the SQL needs to understand how to fully exploit the Exadata’s features. We will expose the Secret Sauce and discuss how to best take advantage of Exadata’s performance optimizations from a developer’s perspective. We will show the processes and tools we use on a daily basis to ensure that Exadata customers get the most from their investments.

Back to Top
ODI 11g for OWB Developers
Holger Friedrich, sumIT AG
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Business Intelligence - Subtopic: Business Intelligence

In this presentation, attendees familiar with OWB will be able to apply that knowledge to understanding ODI. This session will walk through the ODI architecture, drawing comparisons to comparable OWB components, and also pointing out where the two products are quite different. The session will discuss common OWB features and functionality, and demonstrate how those same tasks would be achieved with ODI, including: Mappings, Expressions, Transformations, and Process Flows.

Back to Top
Configuring OBIEE forBest Performance with an Oracle 11.2 Database Back-end
Holger Friedrich, sumIT AG
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Business Intelligence - Subtopic: OBIEE

This presentation discusses how to configure BI Server, in order to make best use of an Oracle 11gR2 database's resources. The presentation will discuss different aspects to consider, options that BI Server gives us, and how the database can be utilized for best query performance as well as workload management. With real-world example queries and workloads, learn how configuring the BI Server on system, object, and query level delivers best individual and overall performance. Advice will be given about what to discuss with DBAs in order to have them prepare their environment such that BI solutions get superior performance.

Back to Top
Oracle Forms Modernization - Prepare for a successful ADF Migration with Source Code Analytics
Andreas Gaede, PITSS
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Grand Oaks C/D
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Innovation in future versions of Oracle Forms will focus on integration into modern service-oriented architecture (SOA) and middleware technologies to enable a phased Migration and hence allow Oracle Forms applications to take part in hybrid application deployments. Gartner states the least risky (and often the least costly) migration path forward from Oracle Forms is Oracle's JDeveloper IDE and ADF. The most important factor of any successful modernization and migration effort is to embrace the differences and re-architecturing by building to the "sweet spots" of the target technology. Learn how the unique Forms Upgrade and Migration software "PITSS.CON" not only enables a guided Forms re-engineering process to prepare for the new target architecture, but also allows Quality and Project Success monitoring for even the most complex Oracle Forms and Reports applications.

Back to Top
Error Handling
Doug Gault, Sumneva
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

This presentation will take an in-depth look at the new error handling features of APEX 4.1, provide some practical examples of how and when to use the new API's , logging the errors for later analysis and various methods of capturing and logging APEX session state during error processing. Attendees will leave with a working knowledge of the new functionality and a solid foundation for building their own error handling mechanisms.

Back to Top
Capturing Performance Data For Interesting APEX Processes
Doug Gault, Sumneva
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

One of the features of Oracle Application Express 4 is the much improved debug information now stored in the dictionary views. This data can be used to track, monitor, and identify performance trends across your APEX application. The trick is capturing instances of this information for interesting APEX processes programmatically. This session will introduce the idea of using APEX debug data for performance trending, the techniques and information necessary for you to mine the Oracle Application Express 4 debug data, and methods for programmatically capturing runs deemed as "interesting."

Back to Top
Advanced Design Considerations for BSO Databases
Tim German, Qubix
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Essbase - Subtopic: Essbase

Most Essbase developers learn some useful 'rules of thumb' to throw a working BSO database together. This session will start with a detailed discussion of the technical considerations underlying those rules, before moving on to tackle some perennial BSO problems: handling dimensions that change over time, making the best use of advanced features such as partitioning and varying attributes, selecting the appropriate 'Time' configuration, and ensuring that your databases take full advantage of Essbase's parallel processing capabilities.

Back to Top
Getting Data in and Out of Essbase
Tim German, Qubix
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Essbase

Even the most elegantly designed cubes are of limited use without some data - and a mechanism for getting it back out again. Essbase provides a broad range of more and less widely-used techniques for data loading and extraction; making the best selection for your projects requires an understanding of the options. This session will provide a review, including real-world usage, technical / performance considerations, ASO- or BSO-specific issues, and sample code to facilitate further exploration.

Back to Top
Overview of Hyperion Public Sector Budgeting & Planning
Matt Geyer, Linium
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Hyperion Applications - Subtopic: Planning

Public Sector Budgeting & Planning - not just for public sector organizations! Come to this session to see details on the components included in Oracle's Hyperion Public Sector Budgeting & Planning solution. This session will include a live demonstration of the solution and details on how it may apply to your organization.

Back to Top
APEX Application Performance
Dimitri Gielis, APEX Evangelists
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

Dimitri wanted to know his less performing APEX application and pages instance wide. From there he wanted to find out why certain pages where not performing well and wanted to know the nitty gritty details about it. For example, sometimes queries run fast in sqlplus, but not in APEX, but how do you know what to look for? Dimitri will share his experiences in using the APEX dictionary, debugging, and tracing APEX applications. He'll go deep into tracing APEX pages and will explain how to read and understand those trace files.

Back to Top
Moving to the APEX Listener
Dimitri Gielis, APEX Evangelists
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

There are currently three Web listeners available for Oracle Application Express: the Embedded PL/SQL Gateway (EPG), the Oracle HTTP Server with mod_plsql, and the Oracle Application Express Listener. This presentation will go over the advantages and disadvantages of all three options. The EPG is rarely considered for production environments while Apache with mod_plsql is used quite extensively. But is the APEX Listener ready to take over? If you are in this presentation you will know the answer :-).This presentation will also demo how to test the performance of the APEX Listener and which extra features you get with the APEX Listener.

Back to Top
Protecting Your EPM Investment By Building a Winning Hyperion Support Team
Jim Glazar, FlameBridge Consulting
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

Don't gamble away your investment in Oracle EPM technology by failing to put the right Hyperion support team in place. Developing a support roadmap and identifying the proper structure and skillsets of your team is key in managing a successful enterprise environment, especially in these times of limited technology budgets and personnel. This presentation will discuss typical obstacles and challenges our clients have encountered while supporting an Oracle EPM Suite 11.X environment. In this session, several key considerations for developing a winning support team will be discussed. You don't want to miss this presentation if you are in finance or IT management and are responsible for EPM at your company!

Back to Top
Create Unlimited Custom Spreads for Driver Based Planning
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Hyperion Applications - Subtopic: Planning

Driver-based planning has never been more important. Learn how to create account level spreads to create a detailed level driver-based planning application.

Back to Top
Developing Plugins for Oracle EM 12c Cloud Control
Alex Gorbachev, Pythian
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Developers Toolbox - Subtopic: Tools

In this session you will learn how to develop plugins for Oracle EM 12c Cloud Control to monitor targets that Oracle EM doesn't support natively like third-party software products, hardware components, and even your own applications. 12c Cloud Control has introduced a lot of enhancements in the area of Extensibility—now a plugin developer can create fully functional extensions and not just simple monitoring plugins. On the example of MySQL plugin, you will learn how to define your own targets, collect metric and reports, define new job types, gather configuration information, and create compliance standards. We will also introduce more advanced area such as customizing user interface and targets auto-discovery. We will learn different collection techniques including SQL, HTTP, Web Services, and others.

Back to Top
Introducing Oracle RAC to Developers
Alex Gorbachev, Pythian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

This presentation provides an architectural overview of Oracle Real Application Clusters explaining fundamentals of Oracle RAC and various components of Oracle RAC deployments. Rather than focusing on development best practices for Oracle RAC, understanding the key concepts will allow developers to leverage Oracle RAC to the full extent making it a breeze to deploy applications in scalable and highly available fashion. In addition, the attendees will take home several practical guidelines on developing applications that work efficiently with Oracle RAC.

Back to Top
Introducing Oracle RAC to Developers
Alex Gorbachev, Pythian
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Tools

This presentation provides an architectural overview of Oracle Real Application Clusters explaining fundamentals of Oracle RAC and various components of Oracle RAC deployments. Rather than focusing on development best practices for Oracle RAC, understanding the key concepts will allow developers to leverage Oracle RAC to the full extent making it a breeze to deploy applications in scalable and highly available fashion. In addition, the attendees will take home several practical guidelines on developing applications that work efficiently with Oracle RAC.

Back to Top
RDBMS Forensics: Troubleshooting Errors using Active Session History
Tim Gorman, Evergreen Database Technologies
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Database - Subtopic: Maintenance

Arthur C. Clarke wrote that "any sufficiently advanced technology is indistinguishable from magic." That is true, and it sometimes makes troubleshooting seem like art. But it is not art; it is process and this presentation uses a case study, such as resolving the ORA-03136 "connection lost" error, to demonstrate that process and to show how components such as ASH, typically thought of as performance tuning tools for DBAs, are also useful diagnostic tools for everyone, particularly developers. Attendees will learn a forensic, empirical approach to troubleshooting and see a demonstration of a complex troubleshooting task resulting in a non-intuitive, but empirically sound, resolution. This presentation should make you think of Active Session History as something like queryable trace information captured and stored within the database. Three things attendees will learn: 1. How the Active Session History views are populated, and what that means for how you use them; 2. What information is captured and stored within the Active Session History views; and 3. How Active Session History information is the next best thing to SQL trace information, and how it can be used for troubleshooting.

Back to Top
Reverse Engineering (and Re-engineer) an Existing Database Using Oracle SQL Developer Data Modeler
Kent Graziano, Data Warrior
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Developers Toolbox - Subtopic: Tools

SQL Developer Data Modeler (SDDM) is a full-function data modeling tool provided for FREE by Oracle. It has many features built in that can be leveraged to capture the design of an existing database, retrofit it to a logical model, re-engineer it to multiple models (including multi-dimensional), and even apply standards, then generate revised DDL to implement your newly standardized design. The presentation will provide step-by-step instructions on how to do all this so you can go back to the office and quickly create diagrams of all your existing databases (Oracle and non-Oracle!).

Back to Top
Introduction to Data Vault Modeling for an Oracle BI Environment
Kent Graziano, Data Warrior
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Business Intelligence - Subtopic: BI Applications

The purpose of this presentation is to provide attendees with a detailed introduction to the technical components of the Data Vault Data Model, what they are, how to build them, and why it is a perfect fit for your OBIEE environment. The examples will give attendees the basics for how to build, and design data structures when using the Data Vault modeling technique. The target audience is anyone wishing to explore implementing a Data Vault style data model as a means of developing a flexible and extensible Foundation Layer for their data warehouse architecture.

Back to Top
RESTful Web Services, APEX and VPDs
Rick Greenwald, Oracle Corporation
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

This session will cover RESTful Web Services and the ways you can use this data access technology with security across a variety of dimensions.

Back to Top
Creating ISV applications for the Oracle Database Cloud
Rick Greenwald, Oracle Corporation
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: Application Express

This session will review considerations for partners looking to create applications for the Oracle Database Cloud. The session will review limitations of the environment when compared to standard Oracle Application Express, options for licensing and reselling applications, and potential certification processes. The session will be an open discussion - your input is welcome and will help to shape the eventual shape of our Oracle Cloud partner program.

Back to Top
Let Hyperion Planning Talk to HFM
Amit Gupta, Deloitte
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Hyperion Applications - Subtopic: Planning

Do you need Hyperion Planning to talk to HFM? Do your users want to consolidate Hyperion Planning data quickly without dependence on daily refresh cycles? Have you unsuccessfully tried to build consolidation and elimination logic for complex structure in Hyperion Planning and found a workaround to get through? We may be able to help you provide insight into how to start on your journey towards integrating Oracle Hyperion Planning and Oracle HFM and make best use of each product's unique strengths to complement and solve your business planning needs.

Back to Top
Upgrading Oracle EPM from V11.1.1 to V11.1.2 - A Real Life Experience
Erica Harris, Waikato Regional Council
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

V11.1.2 introduces some significant changes to the Oracle EPM environment, not the least is the use of WebLogic as the default application server. This session is designed for those lucky souls who get to install, configure, backup, and maintain Oracle EPM V11.1.2! This session will discuss the steps it took to upgrade Hyperion Planning 11.1.1.2.0 rather than reimplement in a distributed Windows environment, provide you with tips to make your upgrade successful, and highlight traps to avoid. The session will also highlight some key functional improvements.

Back to Top
Best Practices for Using Data Relationship Management with EPMA
Brian Healey, Edgewater Ranzal
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Data Management

With the continued adoption of EPMA (Enterprise Performance Management Architect) and DRM (Data Relationship Management) in the current releases of System 11, the area of master data management has become a business and technological battleground. This has manifested itself in the form of misconceptions about both EPMA and DRM. The presenter has worked with customers and introduced a set of best practices that simplify hierarchy and application management beyond what each tool can do by itself. The solution architecture can be extended to add dedicated management layers for each new application or completely separate instances of EPMA with minimal development effort.

Back to Top
Financial Data Quality On-demand - Seamlessly Integrate Hyperion FDM and Oracle Data Integrator
Matthias Heilos, MindStream Analytics
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Essbase - Subtopic: Data Management

Two key parts to the solid foundation of an agile EPM system are data integration and data quality. Based on the nature of those two, IT and business always have to work things out together. Oracle presents two solutions: Financial Data Quality Management (FDM) is branded for Business and Oracle Data Integrator (ODI) is in the IT domain. Both are great tools. Learn when to use which one, or when to use both and how to integrate them seamlessly to create an on-demand process endorsed by IT and driven by the business.

Back to Top
Oracle Data Integrator - Best Practices That You Should Be Aware Of
Matthias Heilos, MindStream Analytics
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Essbase - Subtopic: Data Management

Oracle Data Integrator (ODI) is a powerful data integration suite which allows you to build integration processes with enormous productivity gains over conventional tools of the same breed. In this session, you will gain insights in how ODI works and what you should consider to build master-class integrations. Learn about tricks and tips on architecture, Knowledge Module optimization, migration, flexible load processes, and many other areas that your organization should be aware of when working with ODI.

Back to Top
The New Production Migration Tool - Demystifying Life Cycle Management in Hyperion EPM 11.1.2
Eric Helmer, Linium
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

One of the great recently added features of the Oracle EPM Suite is Life Cycle Management (LCM). LCM is the first real offering from Oracle that allows one common interface to migrate (promote) objects between separate environments, such as development and production. In this session, Oracle ACE Director Eric Helmer introduces you to LCM in an in-depth under the covers look at what LCM is, how it works, and what it can do for your organization.

Back to Top
Rolling, Rolling, Rolling – Rolling Forecasting with Your Planning Application
Michael Heukels, Ernst & Young
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Hyperion Applications - Subtopic: Planning

Tedious, painful, and pretty much useless for decision making. That's how many companies characterize the annual budgeting process. Rolling forecasting is an alternative approach providing decision makers more up-to-the-moment information. This session will discuss how to leverage Oracle Hyperion Planning to enable rolling forecasting. In addition to the technical aspects, this session will cover some of the challenges an organization may face moving to rolling forecasts as well as strategies to address them. A Hyperion Planning application to support rolling forecast will be used to illustrate this session.

Back to Top
Is Your Enterprise Intelligent?.....Really?
Michael Heukels, Ernst & Young
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Cibolo Canyon 10/11
Topic: Vendor Presentation - Subtopic: Vendor Presentation

BI, EPM, BPM, DW, MDM, DRM, HFM, OBIEE, EIEIO? Can this alphabet soup of acronyms really help your organization transform data into information, information into insight, and insight into intelligence? Learn how EY is raising Avon's EI IQ and can facilitate you raising yours.

Back to Top
Advanced Calc Manager for Planning
Michael Heukels, Ernst & Young
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Planning

Are you are solid with the basics but are ready to go deeper with calc manager? Then this is the session for you.

Back to Top
Quick Start to Hyperion Financial Management & Financial Data Quality Management
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Hyperion Applications - Subtopic: HFM

Hyperion Financial Management is the market's leading product in the financial management, consolidation, and reporting space. Why are so many companies turning away from the consolidation products being pushed by their GL/ERP vendors? Come learn how HFM, along with FDM, can reduce your financial close cycle time with an easy to use, Web-based front-end. If you are still using Hyperion Enterprise, you'll hear the straight scoop on why going to HFM might or might not be better for you.

Back to Top
Install SOA Suite and Connect to E-Business Suite in 2 Hours
Jerry Ireland, Rightsizing
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Fusion Middleware - Subtopic: SOA

All excuses for putting off connecting SOA Suite to E-Business Suite have been removed. It can be done in two hours, including download time, with no worries about possible conflicting technologies. Learn how to set up a complete SOA Suite environment connected to E-Business Suite. Learn how to build a simple SOA process to load information into E-Business Suite.

Back to Top
Financial Analytics vs. OBIEE with Essbase vs. Oracle OLAP
Vivek Jain, IBM
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Business Intelligence - Subtopic: OBIEE

This session covers a case study of Financial Analytics for creating Financial KPI dashboards. During implementation, clients realized how easy it was to get KPIs from their existing Essbase cubes. But the need to look at the data at greater levels of detail intrigued client's interest to investigate use of Oracle OLAP cubes. The presentation will demonstrate the application through slides and will give a live demonstration of the process involved in building OBIEE rpd and reports for Essbase and OLAP cubes. The session will also cover a high level overview of configuration steps required for implementing an out-of-the-box Financial Analytics application.

Back to Top
Implementing ODI and OGG 11g to Maximise Performance and Scalability in a BI Enterprise
John Jeffries, Spirotek Limited
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Business Intelligence - Subtopic: Business Intelligence

Leverage the performance and scalability of your BI environment by adopting Oracle GoldenGate and Oracle Data Integrator to feed your Data Warehouse. This session explores the various components that enable fast, scalable data replication and integration. This includes the following discussion points: What is Oracle GoldenGate and what can it do?; ETL vs. ELT processes, the pros and the cons; avoiding batch windows and enabling real-time reporting; Oracle Data Integrator configuration options for GoldenGate CDC; and overcoming performance and scalability issues.

Back to Top
Why Use Oracle GoldenGate 11g for Data Replication, Synchronisation and Real-time Reporting?
John Jeffries, Spirotek Limited
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Business Intelligence - Subtopic: BI Applications

By exploring the configuration options of Oracle GoldenGate, we learn the various techniques that enable fast, scalable data replication and synchronization. This includes the following discussion points: What is Oracle GoldenGate and what can it do?; Topologies; Active-Active vs. Active-Passive; Getting the design right; Enabling parallel replication streams; Reducing data volumes and CPU utilization; Performance enhancements in OGG 11gR2; and Enabling security features.

Back to Top
Hyperion 101: An Introduction to the Oracle EPM/BI Suite
Andrew Jorgensen, Reportinq
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Essbase Beginner - Subtopic: Introductory content for new users

Learn more about Oracle's Performance Management and Business Intelligence Suite in this overview of the products and how they are used. This session will show examples of what's new in those modules and where your company should start.

Back to Top
SQL Analysis and Tuning for the Application Express Developer & DBA
Joel Kallman, Oracle Corporation
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

All performance problems with APEX applications are deemed Application Express problems until proven otherwise. But the vast majority of these are due to improper SQL tuning. DBAs usually have a poor understanding of Application Express. Application Express developers often have a poor understanding of the information the DBAs are presenting to them. This session will review how to analyze a poor performing application from a DBA's perspective, using the tools most DBAs are familiar with such as Active Session History, Active Workload Repository, TKPROF, and more.

Back to Top
Getting Started with Oracle and .NET
Alex Keh, Oracle Corporation
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Developers Toolbox - Subtopic: Coding

This beginner-level session will introduce Oracle's offerings for .NET programmers, including Oracle Data Provider for .NET (ODP.NET), Oracle Developer Tools for Visual Studio, Oracle Providers for ASP.NET, and .NET stored procedures. Step-by-step demos will be used to illustrate how to get started developing Oracle Database .NET applications using each of these free products. New and upcoming features will also be described briefly in this session, including Entity Framework, LINQ, WCF Data Services, 100 percent managed Thin ODP.NET, and support for TimesTen.

Back to Top
Managing & Monitoring the Cloud
Basheer Khan, Innowave Technology
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: AppsTech

Join Oracle ACE Director, Basheer Khan, as he explains the methods and tools you can use to proactively monitor your end-to-end Oracle environment in the Cloud.

Back to Top
Building SOA-based Bolt-on Apps with Application Express
Hilal Khan , Waikato Regional Council
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

Oracle Application Express and Oracle SOA Suite offer a fast and powerful way to add new user interfaces and functionality to your existing packaged applications. This results in a non-obtrusive method of adding features to a packaged application so the support and upgrade paths are not affected. The presentation will cover the use of SOA to interact with packaged applications as well as the considerations for security and user management.

Back to Top
Application Extension and Customization Abstraction with FMW
Hilal Khan , Waikato Regional Council
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Fusion Middleware - Subtopic: AppsTech

Are you nervous the E-Business Suite extensions you are building today may need to be re-built when you upgrade or move to Fusion Apps in the future? Are you nervous your extensions may prevent you from upgrading altogether? This session will cover the use of Fusion Middleware to develop extensions and custom components to work with current and future packaged applications. Oracle ADF, Oracle WebCenter, and Oracle BPM/SOA are all valuable tools that should be used to create new extensions so that they will continue to work after ERP upgrades and even if you migrate to Fusion Applications.

Back to Top
Oracle JDeveloper and ADF: Coming Together for Forms and 4GL Developers
John King, King Training Resources
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Fusion Middleware - Subtopic: ADF

Oracle is creating Fusion Applications with ADF and JDeveloper. JDeveloper has become a robust development tool. ADF likewise has become a useful development tool reminiscent of 4GL tools like Oracle Forms. ADF's graphic and declarative features create data-based Java objects that can be mapped automatically to ADF's Oracle Faces GUI objects quickly and easily. Most "grunt work"code is generated by the tools. This session illustrates the ease of building applications with JDeveloper and ADF.

Back to Top
What's Old is New Again: Oracle Forms 11gR2 New Features
John King, King Training Resources
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Developers Toolbox - Subtopic: Coding

Oracle Forms 11gR2 is the latest incarnation of this venerable tool. Released in September 2011, there are several interesting features to modernize existing forms applications or to manage the forms environment. Features to be discussed include: easier installation, smaller install footprint, Oracle Access Manager support, performance and network statistics, support for 64-bit Windows, use of Oracle Fusion Middleware Real User Experience Interaction for non-intrusive monitoring, Forms Window object maximization, use of dynamic URLs for iconic buttons or READ_IMAGE_FILE, ability to turn off the Forms Menu Bar and window decorations, and other miscellaneous features.

Back to Top
Oracle 11g for Developers: What You Need to Know
John King, King Training Resources
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Developers Toolbox - Subtopic: Coding

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers.

Back to Top
Engineering at BI Solution: How Clark Construction Delivered Immediate Value by Integrating JDE & Hyperion Planning through OBIEE/Financial Analytics
Amy Knowles, Clark Construction
Co-presenter(s):

Greg Vlahos, Analytic Vision

When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Business Intelligence - Subtopic: Reporting Solutions

Learn how Clark Construction jump-started their analytical capabilities by leveraging the pre-built Oracle BI Financial App over JDEdwards, Hyperion Planning/Essbase, and custom data sources (sales acquisition system, safety statistics database). This session will cover how Clark chose OBIEE/Hyperion solution based on the business requirements, a deep dive into the technical solution, and a mapping of technical solutions to benefits gained. "How to" tips include: integrating Hyperion Planning into the OBI solution, steps to implement drilldown from planning to journal detail, and the unique seamless integration of transactional data with Hyperion Planning metrics in the same OBIEE subject area.

Back to Top
The Tie That Binds: An Introduction to ADF Bindings
Peter Koletzke, Quovera
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Fusion Middleware - Subtopic: ADF

This presentation briefly reviews where ADF Model (ADFm) fits and how one of its components, ADF Bindings, allows you to quickly connect components from any user interface library such as ADF Faces and JSF Reference Implementation to business services such as ADF Business Components. The presentation provides details and shows examples of how ADF bindings work; how to automatically bind data elements to visual elements; what types of bindings are available; and where binding code appears. It also explains the basics of the expression language used to bind Model layer components to View layer components.

Back to Top
WebLogic Server Application Security - Implementing the Superstition in JDeveloper
Peter Koletzke, Quovera
Co-presenter(s):

Duncan Mills, Oracle Corporation

When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: ADF

This session explains Web application security concerns and techniques and discusses and demonstrates how to set up security support for ADF Web applications that tap into the Oracle Platform Security Services (OPSS) layer of WebLogic Server. It also discusses how to store user credentials, tap into existing Lightweight Directory Access Protocol (LDAP) providers, and declare access for resources such as pages, task flows, and business components. It also describes how to set up declarative properties to hide or disable items based for specific user roles.

Back to Top
Applications Your Way: Easy Application Extensibility
Christina Kolotouros, Oracle Corporation
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: AppsTech

This session is focused on agile, get-what-you-want extension and customization of packaged applications by putting design time @ run time capabilities into the hands of business analysts, using Oracle Fusion Middleware Composers.

Back to Top
Different Strokes for Different Folks: Build a Composite Application Once to Serve Many
Christina Kolotouros, Oracle Corporation
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Fusion Middleware - Subtopic: Enterprise Architecture and Development

Very often companies building a composite application or a Web site need a page to serve up different content depending on who logged in. Learn how to use personalization, role-based content, and content presenter to build a page in a composite application once that will serve multiple people and roles.

Back to Top
Build a Compelling, Relevant, Optimized, and Content Rich Online Experience with Oracle WebCenter Sites
Christina Kolotouros, Oracle Corporation
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Fusion Middleware - Subtopic: Enterprise Architecture and Development

Oracle WebCenter Sites enables marketers to rapidly create multiple online experiences that strengthen customer engagement. As unauthenticated users browse, WebCenter Sites' powerful rules engine continually segments them and optimizes their experience. With a highly scalable Web content management platform, user generated content, customizable gadgets, and mobile delivery, WebCenter Sites is an exciting new addition to the WebCenter family.

Back to Top
Customizing Planning interfaces via ADF
Prasad Kulkarni, Oracle Corporation
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Hyperion Applications - Subtopic: Planning

Planning with the release of 11.1.2.2 has completely changed its UI. In this session you will learn how the new UI looks like. You will also learn how to customize this new UI. The session describes various aspects of customization with examples. Some of the customization covered in this session are Labels, Messages, Workflows, UI Skinning, Reports etc.

Back to Top
Exalytics and Planning
Prasad Kulkarni, Oracle Corporation
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Hyperion Applications - Subtopic: Planning

This session covers information on how a customer could use Exalytics for their Planning implementations. The session discusses 3 main use cases where customers will get the most benefits by using Exalytics in their environment. You will also find technical details about the Exalytics hardware, performance benchmarks conducted internally within Oracle.

Back to Top
Extend Oracle WebCenter to Infinity and Beyond
Jake Kuramoto, Oracle Corporation
Co-presenter(s):

Chris Bales, Oracle Corporation
Noel Portugal, Oracle Corporation

When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Fusion Middleware - Subtopic: Enterprise Architecture and Development

Unleash your collaborative and social data using the open interfaces of Oracle WebCenter products. Build a mobile app in your SDK of choice or whip up a browser extension and plug in your WebCenter data. If you've ever wanted to extend your WebCenter data beyond the browser, this is the session for you.

Back to Top
Five Things You Probably Didn't Know About SQL
Tom Kyte, Oracle Corporation
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Developers Toolbox - Subtopic: Coding

SQL is an extremely powerful language these days. It offers set-based processing, iteration, and recursion. In short, it has many of the qualities of a procedural language and a declarative language. This session explores five things you probably didn't know about SQL.

Back to Top
A Lot About Binding
Tom Kyte, Oracle Corporation
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Database - Subtopic: Operations

This session will overview why binding is extremely important with regards to performance, scalability, and even security, but quickly move into topics such as: Do I always want to bind? (Surprisingly, the answer is no.) What is bind variable peeking? Is it good or evil in disguise or both? So the developers don't bind, is cursor_sharing=force/similar appropriate system wide? (Emphasis will be on the reasons why setting cursor sharing at the instance level is not such a good idea). What is the real difference between cursor_sharing=force/similar and which should we use under what circumstances? The presentation will be practical, with examples and hard numbers you can use in your daily work.

Back to Top
All About Oracle Database Security
Tom Kyte, Oracle Corporation
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Database - Subtopic: Operations

Oracle Database 11g provides the industry's most powerful security solutions for protecting application data where threats are an everyday occurrence. This session takes a look at the implementation of an important subset of these capabilities, including Oracle Database Firewall, Oracle Database Vault, Oracle Audit Vault, and Oracle Advanced Security as well as features such as Oracle Virtual Private Database. It focuses on the performance impacts and capabilities of these offerings.

Back to Top
Five Things You Probably Didn't Know About PL/SQL
Tom Kyte, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

PL/SQL turns twenty-three years old this year--it was first introduced in 1988 with Oracle6 Database. This session looks at five technical things about PL/SQL you probably did not know: under-the-covers features that make PL/SQL quite simply the most efficient language with which to process data in the database.

Back to Top
Slay the Evil of Bad Data in Essbase with ODI
Cameron Lackpour, CL Solve
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Essbase - Subtopic: Data Management

Everyone knows that bad data kills Essbase applications. But did you know that bad data can also kill careers, consulting engagements, and company-wide labor agreements? No one purposely builds a bad system, yet dodgy Essbase applications happen frequently. Why is the rule of high-quality data in Essbase honored more in the breach than the observance? This session explains the consequences of bad data, categories of data quality, and tools and strategies for ensuring that your Essbase database has the right data. A complete solution in ODI will show one path to salvation in the never-ending quest for quality data.

Back to Top
Script or Die!
Cameron Lackpour, CL Solve
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Essbase - Subtopic: Essbase

Danger awaits the Essbase geek who does not script. Danger in the form of errors. Danger in the form of boredom. Danger in the form of complacency. Scripting is the cure for those dangers. Good scripting practices and techniques convert Essbase administration tasks from potential career-killers to robust exercises of your geeky Essbase awesomeness. This session illustrates the techniques to master Essbase, get danger out of your job description, and free you up to do the really cool stuff.

Back to Top
Planning All Stars Panel
Cameron Lackpour, CL Solve
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Hyperion Applications - Subtopic: Infrastructure/Management/Security

Planning and HFM experts answer your tool related questions.

Back to Top
OBIEE vs Financial Reports: Oracle's Future in EPM Reporting
Alexander Ladd, MindStream Analytics
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

The objectives of this session include: what is Oracle's BI Foundation Suite; features and functions for reporting, ad-hoc analysis, and dashboards; and making sense of the alphabet soup of Oracle's reporting tools.

Back to Top
How to Leverage the New Smart View for Essbase
Alexander Ladd, MindStream Analytics
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

The objectives of this session include: Essbase add-in users will learn about the expanded functionality of Smart View; Details on the top ten new features of Smart View 11.1.2.102; and Learn how to easily migrate to the new Smart View add-in.

Back to Top
How VISA Pushes Training to Effectively Handle Change Management
Seth Landau, MindStream Analytics
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: EPM Business Content - Subtopic: EPM Business Content

Objectives of this session include: Share best practice process for training end users in a global Hyperion Planning deployment; Explore the role that Oracle User Productivity Kit (UPK) has on training strategy; and Lessons learned from the Global training implementation.

Back to Top
How Atco Energy Optimized Their HFM Environment
Seth Landau, MindStream Analytics
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

The purpose of this presentation is to detail a client case study on the use of Accelatis to: Review Performance degradation of the client's HFM applications; track user activity to isolate process bottlenecks; review server and infrastructure activity; facilitate the application review; and assist functional and infrastructure consultants to make technical, functional, and process recommendations.

Back to Top
Dimension and Data Loading
Alice Lawrence, LSG Sky Chefs
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Essbase Beginner - Subtopic: Introductory content for new users

Come explore the world of Essbase load rules. Learn how to use load rules for both dimensions and data. Explore the various load rule methods and how to optimize your data for loading. Common problems and how to solve them will also be discussed.

Back to Top
BSO Calculation Basics
Alice Lawrence, LSG Sky Chefs
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Essbase Beginner - Subtopic: Introductory content for new users

Go beyond the default calculations and learn how to use commands and functions in formulas and calculation scripts to enhance your cube and give you better performance. Topics to be discussed are how calculations work, the effect of dense and sparse settings, limiting data to be calculated (Fixes and Ifs), and a whole lot more.

Back to Top
Essbase/Planning Metadata Management with ODI Across Environments
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Data Management

As an Oracle Essbase/Oracle Hyperion Planning administrator, do you need to compare outlines between development, test, and production to quantify the differences? Do you need a method to know all members with a certain UDA, Attribute, etc? This hands-on session will demonstrate how to utilize Oracle Data Integrator (ODI) to extract the Essbase outline to a relational database table which can be queried. The session will then demonstrate a similar technique for Planning. ODI will then be utilized to determine differences in outlines between environments based on the context selected in ODI.

Back to Top
Hyperion Strategic Finance and Essbase - Leveraging the Benefits of Integration
Scott Leshinski, Blue Stone International
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps
Single Table Access Paths
Jonathan Lewis, JL Computer Consultancy
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Database - Subtopic: Maintenance

Before you can write the SQL for multi-table joins, it is a good idea to be aware of the many access paths the optimizer can choose to access a single table. Given a simple heap table with two B-tree indexes, the presenter can think of twenty-three different possible execution plans that the optimizer might be able to produce, depending on the index definitions and the available statistics. The presenter can come up with a further sixty-six by applying a single strategy for rewriting the SQL. This presentation will look at a few of the less well known options, and then show how to extend the range of possibilities.

Back to Top
Beating the Oracle Optimizer
Jonathan Lewis, JL Computer Consultancy
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Database - Subtopic: Maintenance

There are many different table access paths available to the Oracle optimizer, and many different transformations it can use to rewrite your query to allow for a more efficient join strategy. Nevertheless there are things that the optimizer simply cannot do that human ingenuity can produce through careful engineering of SQL. If you are allowed to change the SQL, but are under pressure to leave the indexing untouched, there are various ways in which you can maximize the benefit you can get from the indexes. This presentation will demonstrate how to do a star transformation on Standard Edition - in the complete absence of bitmap indexes.

Back to Top
Optimizing a Two-table Join
Jonathan Lewis, JL Computer Consultancy
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Database - Subtopic: Maintenance

The optimizer is very good at transforming your query into something that you didn't write; sometimes, though, Oracle's transformation is a bad idea. Sometimes you can transform a query manually in ways that the optimizer cannot. This presentation examines a single, fairly simple query to see how many different things you can do to make it more efficient using strategies which the optimizer, at present, may not consider.

Back to Top
A Day in the Life of a Hyperion Planning Administrator - Told by Laureate Education
Erin Lineberry, Laureate Education
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Planning

How can I make my life easier as a Planning administrator? How can I enhance the end user budgeting and planning experience (simplifying, reducing complexity, and making the overall painful process a bit easier)? This session will show how to work more efficiently with your Planning implementation and administration, allowing you to spend more time on the fun projects while impressing both users and your management. You will learn how to get the most out of your Planning functionality, and learn how to optimize you current application, including application design, data loads, use of Business Rules, user provisioning, and smart lists, and much more.

Back to Top
Automation Nation
RJ Linehan, Innovus Partners
Co-presenter(s):

Pete Cammisa, Innovus Partners

When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: Infrastructure/Foundation Services

The 11.1.2.1 version of Oracle Enterprise Performance Management offers several new features and utilities that will breathe new life into an organization's existing process automation. This presentation will dive into these features and provide the attendee with the knowledge necessary to integrate them into their existing process automation with minimal effort. Leveraging these new ideas, an organization can realize new efficiencies leading to a more stable environment and reduction in support overhead.

Back to Top
Oracle E-business Suite's Use of Edition-based Redefinition for Online Patching
Bryn Llewellyn, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Database - Subtopic: Design/Data Modeling

Oracle E-Business Suite Release 12.2 intends to bring near zero downtime patching by using edition-based redefinition. This presentation teaches the basics of EBR and illustrates the ideas by referring to how the E-Business Suite developers adopted it.

Back to Top
Implement Extensible In-database Analytics by Programming MapReduce in SQL and PL/SQL
Bryn Llewellyn, Oracle Corporation
Co-presenter(s):

Maria Colgan, Oracle Corporation

When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Database - Subtopic: Design/Data Modeling

This presentation shows how to implement one of the canonical data transformations used to illustrate MapReduce (sessionization) with only ordinary SQL and PL/SQL—and Oracle Database's built-in parallel execution system. It explains why it is quite proper to call the approach an example of the MapReduce programming model.

Back to Top
Evolution or Revolution?: Lessons Learned in Implementing Hyperion Planning at UC Berkeley
Catherine Lloyd, University of California, Berkeley
Co-presenter(s):

Todd Weinstein, Huron Consulting Group

When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: EPM Business Content - Subtopic: Case Studies/Panels

This session discusses lessons learned implementing Hyperion Planning at a large, public institution in a time of transformational change to the financial people, process, and infrastructure.

Back to Top
APEX: A CEO's Perspective
Cameron Mahbubian, ClariFit
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Cameron Mahbubian, a Harvard educated executive who is the current president & CEO at ClariFit Inc., gives you an insight into Oracle APEX that you have yet to experience at ODUTG. See APEX from a completely different angle: from behind the dev-room-curtains and straight into the private executive board rooms of America. How did he convince Fortune 500 companies to adopt Oracle APEX in their companies where they hadn't before? What type of demo packs enough punch and delivers enough wow-factor to convince the most skeptical non-technical executive to become excited about APEX vs. what the techie cares about seeing?

Back to Top
EPMA U. Sophomore Class: Data Synchronization and EPMA Batch Client
Josie Manzano-Stettler, ADI Strategies
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Planning

So, here you are with your cutting edge EPMA-enabled applications. You are clearly comfortable with administering your EPM applications from the application library from Workspace. You are a pro with managing your shared library and your metadata maintenance activities. The neophyte administrator is now ready to enter the "sophomore class"in EPMA U! For the next hour, you will indulge in those intimidating EPMA features: Data Synchronization and the EPMA Batch Client. First, in the Data Synchronization section, you will be able to map dimensions with ease and take on the different flavors offered for Data Sync: (1) between two EPM applications, (2) from flat files as sources, and (3) from interface tables as sources. Next, the session will demystify the EPMA Batch Client, which will add the sleek you seek for your Oracle Hyperion EPM environment by enabling "lights out"automation capabilities for your EPMA application and metadata maintenance activities. The session will cover using both modes: command line and script mode. Also, it will break down the steps in configuring the command line files that will be used for the input file in the batch client. You will also walk away with quick start code examples, so you can use these right away in your maintenance automation processes. Get ahead of the class and add these gold stars to your EPM arsenal!

Back to Top
Oracle EPM/BI Development Panel
Al Marciante, Oracle Corporation
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Essbase

This session will be a panel discussion with Oracle leaders in EPM/BI development, product management, and strategy. Attendees will be able to ask questions of the panel across a wide range of topics.

Back to Top
Opening Pandora's Box: The Planning Repository
Brian Marshall, US-Analytics
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Planning

Hyperion Planning provides an excellent platform for deploying enterprise-scale budgeting and forecasting solutions. However, the Hyperion administrator's options for reporting on the underlying metadata repositories are limited. This task is further complicated by the de-normalized nature of the tables. This presentation will expose many of the secrets of the Planning Repositories and provide a set of pre-built queries ready to deploy. Attendees will receive printed and digital copies of all queries along with explanations of specific functionality and a live demo of the content.

Back to Top
Large-scale ASO, Making Essbase Silky Smooth with Terabytes of Data
Brian Marshall, US-Analytics
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Essbase - Subtopic: Essbase

So you have a giant cube with giant dimensions and giant data sets. No problema! ASO can do that. Drawing from experience with real clients, learn some simple tricks and some advanced techniques to maximize your ASO database performance. Do you have millions of members? Do you have billions of rows of source data? Do you have a huge server with lots of resources and vast Essbase potential? If so, this presentation is for you. From changing configuration settings to changing outline settings, if you want to get the most out of your large-scale ASO database, this is a must-see session.

Back to Top
ASO Outline Design Basics
Scot Martin, Cash America
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Essbase - Subtopic: Essbase

Don't miss this important session that will share some of the best practices for designing and optimizing Essbase aggregate storage databases. The session will discuss ways to optimize dimension and hierarchy design, explain when to use stored and when to use dynamic hierarchies, provide creative ways to use the accounts dimension, compression, query tracking, aggregation hints, and more. Most of what you know of outline ordering and design is based on BSO databases, but this hour will specifically address how to build optimal ASO outlines.

Back to Top
Hand Free HFM Automation
Alex Mathew, Oil and Gas
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: HFM

Learn how to extract metadata and data from the source system using either SQL scripts or ODI. Automate the process on a daily basis either by ODI automation, script automation, batch file automation, or chron job automation. Automate FDM process will check every two minutes for new files to process. Once the script finds new files, the FDM process starts (IMPORT, VERIFY, LOAD & CHECK) and an e-mail notification will send user(s) a list of unmapped accounts .

Back to Top
Super Fast Sorting and Pagination in APEX Report Regions ala jQuery
Raj Mattamal, Niantic Systems
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

APEX offers many options to sort and paginate data using server-side processing. These techniques can be slow at times, while many client-side and Ajax-based solutions are available to help in such cases. This session will walk through the considerations of client- versus server-side pagination and sorting with APEX applications. With this understanding, the session will show attendees how to implement client-side pagination and sorting in their APEX applications using commonly available jQuery plug-ins. Time allowing, Ajax-based solutions will be demonstrated as well.

Back to Top
Architecting an Enterprise Business Intelligence Solution using OBIEE+ at an Ivy League University
John McGale, Performance Architects
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: OBIEE

This session will discuss best practices and lessons learned in relation to how an Ivy League client's team partnered with performance architects to select OBIEE+, define requirements, and initiate designing the solution.

Back to Top
Zen and the Art of Mobile Development
Dan McGhan, SkillBuilders
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

Focus on the essential. Eliminate the superfluous. Less is more. Is this a Zen class or a session on mobile User Interface (UI) design? Actually, the two have more in common than you would think. The high demand for mobile Web applications is forcing Web developers to rethink UI design. After years of working with an abundance of pixels, this can be a difficult process and the actual implementation even more so. But it can also be very Zen like. In this session, attendees will learn about the most common patterns in mobile UI design as well as how such designs can be constructed in Oracle Application Express.

Back to Top
Taking Control: Integrating PL/SQL APIs with APEX
Dan McGhan, SkillBuilders
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

The automatic row fetch and DML processes in Application Express are very powerful, allowing developers to create applications quickly and easily. However, their inflexibility often forces developers to implement sub-optimal workarounds to satisfy complex UI or data processing requirements. But when armed with knowledge of PL/SQL, APEX developers can take back control with packaged based APIs. In this session, attendees will learn how to integrate PL/SQL APIs in APEX through a series of example problems and solutions.

Back to Top
Dynamic Action Deep Dive
Dan McGhan, SkillBuilders
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

The Dynamic Action framework, a feature introduced with APEX 4.0, allows developers to interact with end users on the client-side in a highly declarative fashion. However, many developers have not yet started leveraging this amazing feature. Some developers have little or no experience with client-side coding and may not know where to start. Other developers are very experienced with JavaScript and may believe that Dynamic Actions don't have anything to offer. This Dynamic Action Deep Dive was designed to teach developers at any experience level how to use dynamic actions for basic to complex interactions. This is a hands-on workshop, so don’t forget to bring your own laptop.

Back to Top
Oracle BI & Mobility - Where Are We Now?
Kevin McGinley, Accenture
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Business Intelligence - Subtopic: OBIEE

It's been just over a year since Oracle released their new mobile application for Oracle Business Intelligence 11g on iOS, so where does mobile access stand? This presentation will serve as a sequel to last year's Oracle BI & Mobility session and examine how and if mobile solutions from Oracle and other vendors have improved over the course of a year and whether mobile access still matters.

Back to Top
Oracle Exalytics: What Does "Speed of Thought" Mean to an End-User?
Kevin McGinley, Accenture
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Business Intelligence - Subtopic: Business Intelligence

The new Oracle Exalytics hardware/software offering from Oracle combines traditional OBIEE, a TimesTen in-memory database, and a lot of hardware firepower to drive "Speed of Thought" analytics. In this session, we will look at the effect Exalytics has on the user experience for OBIEE, what "Speed of Thought" means to an end-user, and how "Speed of Thought" may introduce new dashboard design paradigms.

Back to Top
Leveraging Smart List, UDAs, Attributes and Text Measures in Hyperion Planning
Tracy McMullen, interRel Consulting
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Hyperion Applications - Subtopic: Planning

During this session, Hyperion Planning experts will discuss the use, benefits, and limitations of Smart Lists, UDAs, Attributes, and Text Measures. Cases and real-world examples will be used to help determine when best to use each.

Back to Top
Best Practices in Budgeting & Planning
Tracy McMullen, interRel Consulting
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: EPM Business Content - Subtopic: EPM Business Content

So you've bought this great new technology called Hyperion Planning and Essbase, but before you begin, what about the budgeting and forecasting process you're about to implement? This presentation will step away from the technology and discuss best practices in developing your budgeting and forecasting process. The session will begin with a brief history of budgeting, but will quickly progress to current trends like driver-based budgeting and rolling forecasts. The session will even cover best practices in emerging planning processes like range-based budgeting and "beyond budgeting." Whatever your process is, you'll come out of this session knowing more about what your process should be.

Back to Top
Secrets of the Hyperion Planning Gurus: Mastering Data Forms in 11.1.2
Tracy McMullen, interRel Consulting
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Hyperion Applications - Subtopic: Planning

The rumors are true! The interface and method for building Data Forms changed considerably in Hyperion Planning 11.1.2. Exciting new features such as Row and Column formulas and validations are now available. This session covers all of the new data form features in 11.1.2.

Back to Top
"Right Tool...for the Right Job!" How to Maximize the ROI of Oracle's Enterprise Planning Suite
Ryan Meester, Edgewater Ranzal
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: EPM Business Content - Subtopic: Product Demos

This presentation will be guiding the audience through the enterprising planning suite of products while addressing these types of questions through real company examples and best practices. By highlighting the true power of Oracle’s Hyperion Strategic Finance, Hyperion Planning, and the reporting suite (including Financial Reports, Smartview and OBIEE) the audience will see how each application can be leverage to maximize the ROI. This LIVE, INTEGRATED demonstration, will show examples of how organizations can seamlessly seed operational budgets with strategic targets, regularly update long-range plans with the latest forecasts, and consume ALL information at ALL times using one integrated reporting platform. Attendees will walk away with a better understanding of Oracle’s full enterprise planning offering and a perspective on how to best leverage the power of each solution by truly using the “right tool…for the right job!”

Back to Top
Advanced Administration and Management of Oracle SOA Suite 11g
Ramkumar Menon, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: SOA

This session will help you master Oracle SOA Suite 11g administration by understanding the internal architecture of the platform. Learn best practices related to configuration management, performance tuning, fault handling, and general monitoring of Oracle SOA Suite 11g from the Product Management Team. Understand how various management tools such as Oracle Enterprise Manager, Oracle SOA Management Pack Enterprise Edition, and Java Virtual Machine consoles can be successfully leveraged in this context.

Back to Top
Handling Binary Content and Large Documents in Oracle SOA Suite 11g and OSB
Ramkumar Menon, Oracle Corporation
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Fusion Middleware - Subtopic: SOA

A technical deep dive into best practices, tips, and techniques around exchanging binary content and large-sized documents between your Applications and end systems via SOA Suite or OSB. Understand and compare features and approaches available for large document/binary content handling in different SOA Suite components (BPEL, Mediator, B2B) and the Service Bus well enough to make informed decisions in your Projects. This session also examines the impact on Performance and Capacity Planning.

Back to Top
Designing Eye-catching and Effective Dashboards
Jordan Meyer, Rittman Mead Consulting
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Business Intelligence - Subtopic: OBIEE

Two schools of thought have emerged in data visualization. In one camp, pragmatic, business-oriented dashboard designers rely on a small range of visualizations considered effective. In the other, "data journalists" and academic researchers are creating new and exciting visual representations. There is a well- established set of techniques used to clearly and effectively present information with graphics. But those techniques do not rule out innovative and attractive dashboards. This presentation will attempt to strike a balance between the clean and simple, and the wow factor.

Back to Top
Multilingual Applications with Oracle Application Express
Francis Mignault, Insum Solutions
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

This technical presentation is about building and maintaining multilingual applications with Oracle APEX 4.1. You will learn how to run the builder in different languages; the translation process when you create or modify an application; how to export and import the translations without loosing the mapping; and how to allow the end-users to switch from one language to another in your applications.

Back to Top
Deeper Dive into Smartview's New Features
Matt Milella, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Hyperion Applications - Subtopic: Planning

This session will focus on new features for Planning that allows end users to complete the entire planning cycle in Excel. We will explore key new features related to the latest version of the Smart View client. Features like new additions and enhancements to ad-hoc analysis including Essbase parity, improved formatting options, enhanced connection management, the Smart View panel, and more.

Back to Top
I am From the Gov't and I am Here to Show You What to Do in APEX
Tony Miller, Agile Consulting
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

APEX is a RAD development product that allows you to build FAST, efficient Web-based database applications. In a number of the government agencies the presenter has worked in, they have polices and mindsets that do NOT allow you to use APEX to its fullest capabilities. This session will demonstrate these and show how to deal with these issues.

Back to Top
Living on Easy Street. Why Building Manual Tabular Forms is a Thing of the Past
Josh Millinger, Niantic Systems
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Tabular Forms have been a great way to show and edit multiple rows of data on one screen since APEX was born. However, they haven't always been the easiest to work with depending on business requirements. Many of these issues have been addressed in APEX 4.X to make a developer's life easier. This session will demonstrate how to take advantage of these latest features so the biggest gain for the least amount of work can be achieved. The presentation will show a comparison of the level of effort that was previously required versus how easily tasks can be accomplished now. Features such as the enhanced Tabular Form Validations and filtered Row Processing options will be discussed. In addition, examples of how to use JavaScript/jQuery will also be shown so developers can see how easy it is to extend their own custom needs into a tabular form.

Back to Top
Real-World Performance Tuning for Oracle ADF
Duncan Mills, Oracle Corporation
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: ADF

This technical session will outline some of the key knobs and switches to understand and exploit in order to build performant Fusion-style applications with ADF.

Back to Top
Debugging ADF Applications - A Workshop
Duncan Mills, Oracle Corporation
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Fusion Middleware - Subtopic: ADF

Learn core debugging techniques for ADF-based Frameworks.

Back to Top
Instrumentation: Why You Should Care
Cary Millsap, Method R Corporation
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

In this session, you'll learn why it's important to regard performance as a feature in its own right (instead of merely an attribute of other features). You'll learn how to add instrumentation to your Java or PL/SQL code that will make your applications easy to optimize in development and easy to diagnose in production.

Back to Top
Achieving Value with a Center of Excellence at General Dynamics
John Monczewski, General Dynamics
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: EPM Business Content - Subtopic: Case Studies/Panels

General Dynamics is a $32B decentralized business unit operating with a high degree of autonomy. General Dynamics understood that collaboration around Business Intelligence and Performance Management is critical to success. In the beginning of 2009, the company started on a journey working across fourteen business units to focus on the extraordinary benefits of creating a collaborative environment. The objective was to drive down the total cost and the time to value, while simultaneously driving up the quality of the solutions. The creation of a Business Intelligence Collaborative has exceeded expectations and now includes multiple business units across General Dynamics.

Back to Top
A Running Start: Using Business Intelligence Applications to Accelerate BI & EPM at General Dynamics
John Monczewski, General Dynamics
Co-presenter(s):

Stephen Bowden, Peloton

When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Business Intelligence - Subtopic: BI Applications

How do you make the most effective use of your BI investment dollars? With Oracle Business Intelligence Applications (OBIA), organizations are empowered to focus on high-value analytical capabilities and leave the data "plumbing" to Oracle. With out-of-the-box solutions, there are always at least a few surprises. This session will explore the implementation of Financial Analytics and Project Analytics as part of a long-term roadmap towards expanded reporting and planning capabilities at General Dynamics.

Back to Top
The Ultimate Sales Pitch for ADF - On Strategic Importance and Practical Value
Chris Muir, Oracle Corporation
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Fusion Middleware - Subtopic: ADF

Imagine you're Oracle - why should you be interested in ADF - what do you need it for? How will it make you successful, with your Fusion Application and Middleware ambitions? This session will tell you in clear terms. Now back to you. You're not Oracle. You're you. Why should you be interested in ADF? What will it mean to you. Oracle ACE Director Chris Muir will present a one hour commercial on ADF - its strategic position at Oracle, the relevance for organizations around the world, and the concrete value it is providing in many sites.

Back to Top
In a Nutshell: The ADF UI Shell
Chris Muir, Oracle Corporation
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Fusion Middleware - Subtopic: ADF

Beyond the basic training on Oracle's JDeveloper 11g ADF, developers are left with an overwhelming list of options for presenting a rich application to users. Buttons, sliders, graphs, and more. Yet individually, these don't make an application, these don't make a user experience; how will your application pull this into a consistent look and feel, how will the application flow, how will they navigate in your application? This session will look at Oracle's ADF UI Shell, a working combination of page templates, menus, and application structure bringing the many parts of 11g ADF applications together into a living application experience.

Back to Top
ADF Data Visualization Tips & Techniques
Chris Muir, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: ADF

An old saying is "A Picture Is Worth a Thousand Words!" This has never been more true than in the information overload we experience today. In this session, you will learn how to turn data into information by presenting it visually to your users through the use of Oracle ADF Data Visualization Components. A detailed discussion of ADF Data Visualizations will kick-off this topic followed by supporting demonstrations that will be the foundation for you to begin building your Web 2.0 Data Dashboards with these components. As a wrap-up, a glimpse at the future of ADF Data Visualizations will be presented.

Back to Top
A Case Study of Redeveloping a Forms Application in ADF
Lynn Munsinger, Oracle Corporation
Co-presenter(s):

Grant Ronald, Oracle Corporation

When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Fusion Middleware - Subtopic: ADF

This session shows Forms and PL/SQL developers how to map familiar concepts from Forms to ADF, and shows, with several demos, how to create applications in ADF. An explanation of each component of ADF is provided (data model, business logic/validation, task flows, ADF Faces, and charting components), followed by a comprehensive demo of each. Attendees will understand Oracle's roadmap for Forms, and at the same time, give them confidence and skills to take on their next project with ADF.

Back to Top
Mobile App Development for Multiple Mobile Platforms: Develop Once and for All
Lynn Munsinger, Oracle Corporation
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Fusion Middleware - Subtopic: ADF

This session shows how to develop mobile applications for different types of devices using Oracle ADF. A comprehensive demonstration will show developers how they can mobilize their own applications, or, since Fusion Applications is built on the same framework, mobile-enable Fusion Applications.

Back to Top
JDeveloper and Oracle ADF, Faster and More Declarative than .Net or APEX?
Lynn Munsinger, Oracle Corporation
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Fusion Middleware - Subtopic: ADF

Java is complicated. It takes ten times as long to develop in Java as it does Forms. APEX is the king of RAD development. Statements you've maybe heard, or made yourself. Are those statements still true? How RAD is Java development? Do you need a deep understanding of Java to develop Oracle ADF applications? This presentation looks at how far Java productivity has come with Oracle ADF, and with a focus on live demos, not PowerPoint, gives you the information you need to answer the question: Is development with JDeveloper and Oracle ADF faster than your current tool of choice?

Back to Top
Oracle ADF's Hidden Gem - Using Groovy in ADF Applications
Lynn Munsinger, Oracle Corporation
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Fusion Middleware - Subtopic: ADF

One of the core benefits of Oracle ADF is how much it does for the developer without having to drop into fully-blown Java coding. But what if you could find a way of having the flexibility and power of Java, but still within the declarative features of ADF? This session shows how the Groovy scripting language can be used to give incredible flexibility to ADF's declarative framework features including validation, attribute value calculation, and customized message handling.

Back to Top
Why Do Disasters Strike On Friday Afternoons?
Michael Myers, Ernst & Young
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Essbase - Subtopic: Infrastructure/Management/Security

This presentation will offer an overview of Disaster Recovery principles as they relate to Hyperion, both past and present. A comparative analysis will be presented showing examples of Disaster Recovery solutions for both pre-11.1.2 releases and the latest 11.1.2.x release.

Back to Top
Go. Cloud. Now!
Jan Navratil, CampusIT
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Considering transforming your existing on-premises solution to the SaaS model? Then you must attend this session! This presentation will share the journey they took with their ten-year-old student interaction management solution (800 Oracle forms, 2000 tables) used in sixty universities to manage 500,000 students to make its viable cloud offering. Where to start? What options do I have to address multi-tenancy? How to re-architect large system without breaking it? What to consider when choosing a hosting platform like Amazon EC2 or Oracle Cloud Database service? Should I worry about commercial aspects of the solution as an engineer?

Back to Top
Go. Build. Automate!
Jan Navratil, CampusIT
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: Team Development, Testing, Debugging, Load Testing

Sound source version control and automated build process give us confidence to make changes to the code base and eliminate associated risks. However, database adds extra challenges: What to consider when organizing source code in the version control system? How to manage dependencies between database objects? How to automate creation of the build script and execution? How Subversion and Hudson/Jenkins can help me? How to monitor patches applied by my customers/colleagues? This session will help you find answers to these questions by sharing the journey they took with their student interaction management solution consisting of 1000+ APEX pages, 100s of APIs, and 2000 tables developed by ten developers.

Back to Top
FDM Integrations with Essbase and Planning
Deborah Newborn, Finit Solutions
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Essbase - Subtopic: Data Management

FDM is a web-based data transformation and loading tool. It offers a centralized platform for collecting data from all areas of the organization and a standardized approach to data validation and loading. FDM has an interface that is geared towards finance and accounting groups. It allows end users to control how source data is mapped into target systems. It also provides a reporting portal and drill down capabilities to ease the data reconciliation process and features an audit trail that logs all system activity and stores all data files. FDM uses an adapter specifically designed to integrate Essbase and Planning with its data processing functionality. FDM is highly flexible and should be designed to ensure the integration with Essbase and Planning is in keeping with the desired workflow and other business requirements. Certain considerations should be reviewed including the user community, the frequency of data loads, data mapping requirements, calc script usage and methods, and, if applicable, whether an existing FDM workflow needs to be updated to accommodate an integration with Essbase and Planning. Additionally, there are technical requirements within the adapter and your servers that need to be met in order to ensure a successful integration.

Back to Top
APEXadata and RACApex
Anton Nielsen, C2 Consulting, Inc.
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

APEX applications are used throughout the enterprise for small and large applications, for mission critical systems on multi-node RAC databases and on laptops with a single user, and even on Exadata servers (think Oracle Cloud). The same application that runs on an XE database on a laptop can run on Enterprise Edition on Exadata and vice versa (well, sometimes). The beauty of Oracle RAC databases is that you don't need to do anything to make your application work--if it runs on a single node, it can run on RAC. The truth, though, is that many applications can be improved to get the most out of RAC or Exadata databases. This presentation will cover APEX infrastructure configurations (middle tier and database), APEX engine configurations, and design considerations of your application as it relates to APEX applications on multi-node databases, enabling you to get the most out of your RAC and Exadata investments.

Back to Top
Forms Can Do That, Why Can't You Make APEX Do That?
Matt Nolan, APEX Freelancer
Co-presenter(s):

Peter Raganitsch, click-click IT Solutions

When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Break free of any pre-conceived APEX limitations and learn how the latest APEX 4.x features will allow you to create rich forms-like APEX applications using the most advanced JavaScript UI Web development frameworks. Learn new design techniques for managing large numbers of plugins, handling inter plugin communication, and how to turbo charge your productivity.

Back to Top
Oracle Exadata Technical Features Overview
Dan Norris, Oracle Corporation
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Database - Subtopic: Infrastructure/Management/Security

After this session, you will understand what has been done to enhance and extend the database architecture and functionality of Oracle Exadata and how to take maximum advantage of the new capabilities. The presentation examines in detail SQL offload processing, I/O resource management, Oracle Exadata flash cache, storage virtualization, integration with Oracle Database, and the hardware and software architectures of Oracle Exadata.

Back to Top
Database Experts Panel Q&A
Dan Norris, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Database - Subtopic: Infrastructure/Management/Security

This session provides an open Q&A for attendees to pose questions about Oracle Database and Oracle Exadata to a panel of OakTable database experts: Cary Millsap, Maria Colgan, Jonathan Lewis, Dominic Delmolino, Tim Gorman,and Dan Norris. Maximum time will be devoted to answering questions from the audience, so be sure to bring your questions and prepare for some great discussions!

Back to Top
Got Analytic Governance? Evolving DRM, Workflow and Hyperion Automation into one Governance Solution
Joe Northern, MDM Strategies
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Magnolia
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Are you managing reporting updates using spreadsheets, e-mail boxes, and batch files? Would you like to automate data governance policy, request processes, and analytical hierarchy/meta data changes so that they can be updated at anytime across Hyperion and analytical applications? Many organizations form data governance practices to create consistent business information policy, improve consistency, and reduce time to close. Learn how to implement data governance automation that will reduce cost of monthly maintenance, and provide self-services change management using Oracle DRM, web portals, workflow, and application automation. Joe Northern, one of the founders of the Oracle DRM application (previously with Razza Solutions), will share with you case studies and best practices of evolving DRM into an analytic governance solution. You will learn about building a business case for data governance; the difference between analytical versus transaction ERP master data management; and how to use Oracle DRM and workflow to create a self-service governance process to manage changes across analytical & ERP platforms. We will also demonstrate our new MDM-Analytic Governance software applications advantages in managing the business analytical life cycle.

Back to Top
Apex as Your Integration Platform - Is It Possible?
Chris Ostrowski, Fujitsu America, Inc.
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

Integration is a hot buzzword in the Oracle community today. If you start looking at some of the integration offerings from Oracle and others, however, it can seem pretty overwhelming very quickly. Many organizations are looking for simpler integration solutions and Oracle Application Express can be used for those types of integrations. This presentation will explore how organizations can use Oracle Application Express to integrate systems.

Back to Top
New to 11.1.2 - Advanced Calculations in ASO Essbase Applications
Philip Parker, Perficient
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Essbase - Subtopic: Essbase

Essbase ASO applications are great for pure reporting applications. Come see how you can take your existing reporting applications and run allocation calculations using the new calculation feature in Essbase 11.1.2.

Back to Top
Introduction to Oracle Application Express
David Peake, Oracle Corporation
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is based on APEX 4.1 and all of the brilliant new features that make development even easier and more productive.

Back to Top
Application Express 4.2
David Peake, Oracle Corporation
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Get an in-depth insight into Application Express 4.2 features directly from the Application Express Development Team.

Back to Top
Simplifying the Management of Enterprise Dimensions
Robin Peel, Ernst & Young, LLP
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Data Management

Learn how to leverage Oracle Hyperion Data Relationship Management (DRM) in your EPM and BI projects. This session will review how to introduce a leading-practice approach to enterprise dimension management that will resonate with both business experts and IT staff, and which will simplify the deployment of your EPM and BI tools. This session will also show you how to plan your DRM project fully to leverage its benefits across the enterprise.

Back to Top
Getting Started with Oracle Hyperion SmartView for Microsoft Office and Smart Slices
Chuck Persky, Performance Architects
Co-presenter(s):

 Jonathan Etkin, Performance Architects

When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Certification Class
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

Learn how to get started with Oracle Hyperion SmartView for Office v11.1.2.1 tool. We will be providing an interactive demo session on how you can leverage the latest version of SmartView, whether you are a new user or an avid Excel Add-In user. We will be demonstrating a variety of features including basic Excel ad-hoc reports and drill throughs, PowerPoint presentation integration, leveraging your Hyperion Planning data forms, and even some Smart Slices. Come armed with questions and join us at Kscope!

Back to Top
The WHEN, WHY and HOW of Hyperion Workforce Planning
Chuck Persky, Performance Architects
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Hyperion Applications - Subtopic: Planning

Hyperion Workforce Planning: There is sometimes confusion in the market space as to "when," "why," and "how" to utilize Workforce Planning. Both customers and developers are faced with the decision of how best to utilize the purpose built model to accomplish staff level planning. The session will help attendees understand the capabilities of the Workforce Planning module, and then show the sequential steps required to implement and/or customize the module to specific needs.

Back to Top
Leveraging EPM showing BI on Mobile Devices
Richard Philipson, James & Monroe
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

This presentation focuses on enabling strategic growth within existing EPM solutions, and maximizing your investment by further enabling users to connect to your information using OBIEE. As a beginner/intermediate presentation, the focus is on introducing capability by showcasing IPAD support; this is reinforced by allowing hands-on activity by audience members. The presentation also looks to address the BI fundamentals of quality over quantity and information as opposed to data.

Back to Top
A Research Data Platform that Works!
Adrian Png, UBC James Hogg Research Centre
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

It is all about the A’s: Agility, Adaptability, Accessibility, and Assuring. Creating applications that ensure data integrity, manageability, and protection can be challenging for biomedical research centers today. Project requirements are often vague and extremely dynamic. In this session, learn how a leading center for heart and lung research achieves its data management goals by creating a Rapid Application Development environment with the Oracle Database and Oracle Application Express that coexists with existing IT infrastructure and frameworks.

Back to Top
Rolling Forecasts: Beyond Budgeting Approach to Financial Planning Using Hyperion Planning
Lisa Poché, Ingersoll Rand
Co-presenter(s):

Shankar Viswanathan, Oracle Corporation

When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: EPM Business Content - Subtopic: EPM Business Content

Beyond Budgeting Approach to Financial Planning using Hyperion Planning Preparation and planning within an organization are critical to a successful transition from traditional annual operating plan based budgeting and planning process to a rolling forecast based planning process. The capabilities within Hyperion Planning make deployment of rolling forecast based planning process easier. This session will review key questions to ask, decisions and criteria to consider, best practices for process review and change, and key ideas to making rolling forecasts work. We also will look at details like simplicity through drivers, rolling forecast reports, and lastly, how rolling forecast process ties to long-range planning.

Back to Top
Beginning Calculation Manager for Essbase and Hyperion Planning
Scott Pold, Edgewater Ranzal
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Essbase Beginner - Subtopic: Introductory content for new users

This presentation will introduce the attendee to Calculation Manager. Calculation Manager is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase. By attending the presentation, the attendee will learn about differences between Calculation Manager and Hyperion Business Rules, as well as see a live demo of the tool to develop and deploy business rules to a Hyperion Planning application.

Back to Top
Case Study - Group 1 Automotive Drives Profitability with Oracle Hyperion Applications and TopDown Consulting
Juan Porter, TopDown Consulting
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: EPM Business Content - Subtopic: Case Studies/Panels

Learn how Fortune 500 company, Group 1 Automotive, leveraged the Oracle Hyperion suite of products--Hyperion Financial Management, Planning, and Disclosure Management--for a uniform, consolidated way to look at dealership performance, and a more efficient, automated way to conduct reporting processes without relying on manual labor to generate reports. This session will review the design and implementation of a dynamic reporting system that distributes data in a consistent, timely fashion, making the budgeting and forecasting process less people-dependent while providing system controls and maintenance efficiencies within the process. Session details will also include best practices for implementing reporting systems.

Back to Top
Making Enterprise Manager 12c Work for You!
Kellyn Pot'Vin, Enkitec
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Database - Subtopic: Operations

OEM is the standard for most DBAs to monitor and interact with their database environments. This session will go over how to get the most out of Oracle Enterprise Manager by utilizing scripts and code outside of the OMS repository to allow more functionality, better reporting, and enhanced management features. Trouble-shooting issues when they arise will be reviewed during this session as well.

Back to Top
Financial Reporting: I Didn't Know it Could Do THAT
Dan Pressman, nTuple, LLC
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

Would you like to have one report that allows the user to see Actual, Plan, and PriorYear - for any level of your organization, AND the variable number of children of that level? How about run-time options to show/hide the Plan/PriorYr values? Or a choice of Value or percentage variances, or both? Techniques of developing just such reports, partially by editing the report XML, will be shown along with examples of how the reduced code base decreased development and maintenance. These techniques allow one to seven columns for each parent and each of N children to be displayed in one report. Custom pagination prevents FR from splitting columns groups between pages.

Back to Top
Learn How ASO Really Works and How to Harness That Power for Good
Dan Pressman, nTuple, LLC
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Essbase

12+1 Rules to guide your ASO Designs. Previously unpublished information based on the statistics page; documentation; and gleaned from related patent filings; all distilled into 12+1 Rules to guide your ASO Designs. These Rules will ensure that your cubes perform maximally, require less Aggregation and have a minimal memory footprint. The 12+1 Rules emphasize the use “Stored Hierarchies” and include real world examples showing how to design around common requirements without using MDX and in conformance to the rules to truly let ASO be ASO. Compression and the impacts of using Attribute dimensions is also discussed. This info is found nowhere else except the new book Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals. In short, this presentation moves from the most theoretical information about How ASO Works to the most practical Rules to allow you to Design for Performance.

Back to Top
Getting the Best Performance from Your Business Intelligence Publisher Reports and Implementation
Nikos Psomas, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Business Intelligence - Subtopic: Reporting Solutions

This session covers several case studies applying best practices to improve performance including: system configuration settings, optimizing data model design, tips and tricks of building layouts, and bursting. Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products. Learn how you can optimize your investment to create a high performance reporting environment.

Back to Top
ASO & MDX: Dynamic Aggregation of Filtered Data Subsets
David Rae, Iconomics
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Essbase

Have you ever been challenged by your users to give them the ability, using Essbase, to: filter a subset of data at a lower level in a cube (i.e., "all SKUs with sales > $100,000 for customers in Europe"); aggregate that data; and present a ranking report for the top five product groups by market within Europe. Conventional wisdom is that this sort of dynamic dataset is possible in SQL, but not in MDX. This presentation provides a straight-forward framework for building a single MDX statement that can easily solve this style of reporting problem.

Back to Top
APEX Developer Pro Secrets
Peter Raganitsch, click-click IT Solutions
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Creating Applications with Oracle APEX is fast and easy, but do you think you know all the tricks to be really efficient? Avoid unnecessary clicks and navigation; jump directly to the function you need. Use keyboard navigation and the powerful search box. Learn about undocumented features and powerful add-ons; you will be amazed! This presentation has valuable tips and tricks for APEX developers of all experience levels.

Back to Top
Mobile Dashboards with Oracle APEX
Peter Raganitsch, click-click IT Solutions
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

Creating mobile applications with Oracle APEX is easy, but what to do if you want to have charts and dashboards on your phone or tablet? Because some of the phones and tablets don't support Flash, we can't use the built-in APEX Anychart Flash Charts. The good thing is that modern smartphones already support HTML5 which gives us a broad range of new tools and possibilities. With a set of plugins and built-in components like lists and reports, we can build a good looking and informative dashboard.

Back to Top
Using Application Express to Build Highly Accessible Products
Anthony Rayner, Oracle Corporation
Co-presenter(s):

 Paul Holliman, UK Government

When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Web accessibility is a difficult subject to address. For a start it's subjective. Subject to users with different types of disability, with different impairments, using different Assistive Technologies. It is therefore very difficult, if not impossible to build a completely accessible web application to all users. What we can do is identify and define appropriate standards that help us try and meet our users needs and use a tool that helps us easily build to those standards, without compromise. In the Application Express team, we are serious about accessibility and strive to build a product that not only meets the standards we define at Oracle, but also allows you to do the same in your own applications. In this session, Anthony will show you how to go about tackling this subject to build highly accessible products, with Application Express.

Back to Top
Easy Rich Web with Application Express and Dynamic Actions
Anthony Rayner, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Dynamic Actions provide an easy way to define client-side behavior in your Application Express applications, without needing to know JavaScript or AJAX. In this session, you will learn everything you need to know about Dynamic Actions, directly from the developer of the feature. Anthony will talk about its beginnings, its architecture, what's possible, and also discuss how to approach common situations with Dynamic Actions. You will also learn about what's coming in our next release to make things even easier, and be able to put forward any Dynamic Action questions you may have. Want to improve your application's user experience and give them that richer and more interactive look and feel? It's easy with Dynamic Actions!

Back to Top
Websheet Applications - Who, What, When, Where, Why & How?
Karen Reliford, TransAmerica Training Management
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

What's the difference between a websheet application and a database application? Why create a websheet application in first place? Where would they be the most useful? Who would be the ideal user(s) for a websheet application and when should we consider building a websheet application solution? How do we build and manage websheet applications? Come to this presentation for answers to these questions and others and to learn more about this relatively new feature available to us in Application Express

Back to Top
Dynamic Actions: Functionality for Making Pages
Karen Reliford, TransAmerica Training Management
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Just what is a Dynamic Action anyway? Is it a feature like Interactive Reports? Well, not really, no it isn't ...so...come to this presentation to learn about one of the most interesting new features in Application Express - Dynamic Actions. They pack some major power that developers can incorporate into their applications for end users. This presentation will focus on some interesting and fun features that will incorporate simple yet powerful Dynamic Actions into your APEX pages....and learn how to make your pages "Come Alive!”

Back to Top
Enhanced Essbase User Input: Improving End User Experience While Providing Robust Data Integrity
John Richardson, US Bank
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Essbase

This will be a demonstration of techniques for making Essbase data submission less cumbersome for users while adding additional levels of data integrity. This process includes using API calls through a VSTO solution, applying business rules, dynamic roll up and managerial calc scripts, and audit logging. This allows users to submit thousands of data points (potentially at rollup nodes) using free form entry or standard templates. The presentation will show US Bank's solution using these universal techniques.

Back to Top
Get the Look and Feel You Want in Your APEX Applications
Jorge Rimblas, Rimblas Consulting
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

You just received an image or layered file from marketing with the design for an application you need to build. You're wondering what to do. How do I translate this into a usable APEX template? APEX provides great flexibility that allows your applications to fit within your corporate visual theme, but many people don't realize that the APEX built-in themes are not static or your only option. HTML and CSS can be daunting when your expertise lies within the database realm. This session will show you that a little understanding goes a long way.

Back to Top
Oracle Business Intelligence Systems Management Best Practices and New Features
Mark Rittman, Rittman Mead Consulting
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Business Intelligence - Subtopic: OBIEE

Oracle Business Intelligence 11g uses Oracle Fusion Middleware and Oracle WebLogic Server to provide a distributed systems management environment through Oracle Enterprise Manager. Many BI configuration options are now managed through Oracle Enterprise Manager and can be scripted with the Oracle WebLogic Server scripting tool. This presentation provides an overview of the Oracle BI systems management environment; discusses best practices for managing a distributed, clustered environment; and looks in particular at best practices for scripting, deployment, diagnostics, logging, backup and recovery, and performing common systems management tasks.

Back to Top
Inside Oracle Exalytics and Oracle TimesTen
Mark Rittman, Rittman Mead Consulting
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: OBIEE

The new Oracle Exalytics and accompanying Oracle TimesTen database makes it now possible to provide in-memory analytics on top of an Oracle data warehouse. In this session, we will look at the internals of Exalytics and TimesTen, examine how the new in-memory features work, provide performance figures and benchmarks and provide guidance on when to use Exalytics on top of an Oracle data warehouse, and OLAP, solution.

Back to Top
APEX & jQuery Mobile: A Winning Team
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

One of the major new features of the upcoming APEX 4.2 release is the integration of the jQuery Mobile framework. With jQuery Mobile integrated, it will be possible to declaratively develop mobile Web applications on top of your Oracle database. This alone is fun already. But what about combining APEX, jQuery Mobile, and soccer? During June 2012, the European Championship Football will be held, and again, Christian will put the APEX-based prediction game FIFApex.net online. The FIFApex EURO 2012 game will be accompanied by a mobile version, APEX-based too. This presentation will demonstrate how the mobile application has been designed and built with Oracle Application Express and the integrated jQuery Mobile themes. AND: Kscope12 participants will have the chance to win prizes for best predicting results of matches played during the conference.

Back to Top
Create a Native Mobile App with APEX
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

With jQuery Mobile integrated, we can now easily build browser-based applications optimized for usage on mobile devices. But if you want your application to be used frequently and present a more native experience to the user, you should consider offering your application as a native mobile application (app). This presentation will show how an Oracle Application Express application can be converted into a native mobile app, offering more advanced interaction with your mobile device's capabilities. TIP: Visit Christian's presentation on APEX & jQuery Mobile first. Both presentations will use the same demo application.

Back to Top
Dynamic SQL in the 11g World
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Developers Toolbox - Subtopic: Coding

Dynamic SQL is one of the most critical tools in the developer's toolbox. It empowers well-written systems to rapidly realign with the real world. In addition to the core elements required to properly utilize Dynamic SQL, this presentation focuses on effective and appropriate usage of all 11g additions to the PL/SQL language (in conjunction with other advanced features such as object types, collections, large objects, etc). Real-life examples are used as illustrations for all key points.

Back to Top
Essbase Application Design Considerations for Beginners
Edward Roske, interRel Consulting
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Essbase Beginner - Subtopic: Introductory content for new users

New to Essbase? This session will guide you through thinking multi-dimensionally. It will explain the different types of Essbase cubes and what you need to consider when building your cubes. It will cover topics such as: dimensions, structures, alternate hierarchies, and attributes.

Back to Top
The Secrets Behind the Fusion Applications: Are They Real, Can I See Them, & How Do They Affect Them?
Edward Roske, interRel Consulting
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Fusion Middleware - Subtopic: AppsTech

In this session, you'll get to see it in action for what is probably the first time. You'll leave knowing what exactly Fusion is, how it will save you 60 percent time over your traditional ways of working with ERPs like Oracle EBS & PeopleSoft, and how you can explain all this to your friends and coworkers. Join Oracle Fusion Advocate and Oracle ACE Director, Edward Roske, as he separates the marketing myths from the practical realities of Fusion Applications.

Back to Top
Oracle Essbase Worst Practices - Lessons from a Moron
Edward Roske, interRel Consulting
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Essbase - Subtopic: Essbase

Edward Roske, co-author of the best-selling Essbase books ever written, has built over 500 Essbase cubes in his life. While the vast majority of those were wildly successful, this is not their story. In this session, you'll be hearing about the disasters, the mistakes, the things you should never do in Essbase that have made for some obscenely large, impractical, unworkable, and unusable applications. While your average session would cover all the tips, tricks, and best practices you should do, no one ever shows you what happens if you don't follow those optimizations. Give us an hour and we'll make sure you never look like a total Edward.

Back to Top
Optimizing Essbase Calc Scripts and Formulas
Edward Roske, interRel Consulting
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Essbase - Subtopic: Essbase

Abstract to come.

Back to Top
Ask interRel's Oracle EPM/Hyperion Gurus: More Fun Than a Barrel of Consultants
Edward Roske, interRel Consulting
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Cibolo Canyon 7
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Are there Oracle EPM/Hyperion questions that have been burning holes in your brain for years because no one has ever been able to answer them? Don’t miss your chance to attend this special, one-hour panel session with interRel’s two Oracle ACE Directors, Edward Roske and Tracy McMullen, and our Oracle ACE, Glenn Schwartzberg, to get the answers you’ve been dying to ask. This session will offer a combination of common questions we’ve heard over the years from our customers as well as queries from the audience on their toughest Hyperion issues and questions for our Oracle ACE Directors and interRel experts. This session promises to be both educational and amusing as we watch Edward, Tracy, Glenn, and possibly some other invited guests flounder for answers for your viewing enjoyment.

Back to Top
Introduction to Hyperion Workforce Planning
Teresa Roy, ATC Logistics & Electronics
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: Planning

Have you heard of WorkForce Planning but don't know specifically how it works? Are you uncertain if it is a good fit or will meet the projection, forecast, or budget needs of your organization? This session will walk through the out-of-the box WFP functionality for planning salary, taxes, and benefits for existing and new employees. The presentation will conclude with items that are NOT a part included in an out-of-box WFP implementation. This is a must-see for those considering WFP.

Back to Top
Exalytics and Essbase
Gabby Rubin, Oracle Corporation
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: BI Applications

Learn about specific Essbase enhancements in Exalytics, when you can benefit from the performance improvements and what it might mean for existing Essbase implementations. See some of the latest performance results from customer and internal testing scenarios.

Back to Top
Essbase 11.1.2.2 New Features
Gabby Rubin, Oracle Corporation
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Essbase - Subtopic: Essbase

With Oracle Essbase being a key foundation product in both Oracle Enterprise Performance Management application and Oracle Business Intelligence, many new and exciting features are being added and enhanced. Attend this session to learn what was introduced in the last year and what you can expect from Oracle Essbase in respect to Standalone custom Essbase applications, EPM, Oracle Business Intelligence integration and Exalytics.

Back to Top
An Overview of Oracle Exalytics
Gabby Rubin, Oracle Corporation
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Business Intelligence - Subtopic: BI Applications

Learn about the Oracle Exalytics In-Memory Machine. This overview will complement other deep-dive sessions, and will describe Exalytics’ best-in-class hardware plus BI platform and in-memory software optimizations. How the Exalytics engineered system delivers a dynamic user interface and speed-of-thought style of visual analysis will be covered. Described also will be Exalytics’ certification for Oracle’s Analytic Applications – where out of the box support drives fastest time to value and extreme performance for ERP, CRM, EPM and industry-based solutions.

Back to Top
A Forward Look at Essbase
Gabby Rubin, Oracle Corporation
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Essbase

With the expansion of Essbase within the Oracle product line how might the future of Essbase look like is respect to possible use cases? Provide your insight and feedback in this interactive discussion.

Back to Top
Appilcation Express: Customizing Flash Chart XML
Christoph Ruepprich, Hotsos Enterprises Ltd.
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

The new Application Express 4 charts now allow for much greater flexibility in displaying and controlling flash charts. This presentation will look in detail at the chart XML for flash charts, and learn how to manipulate its various components. You will learn how to control attributes like line thickness, tooltip behavior, background shading, and how to change chart attributes depending on data that is being passed to the chart page.

Back to Top
Modern PL/SQL Code Checking and Dependency Analysis
Philipp Salvisberg, Trivadis AG
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Developers Toolbox - Subtopic: Coding

Identifying guideline violations in early development stages reduces development times and costs. Using such techniques in database-centric architectures is not common, so standard tooling is currently missing or insufficiently configurable for specific customer guidelines. Trivadis used Eclipse Xtext to define the PL/SQL grammar of Oracle Database 11g Release 2 to check the compliance with the Trivadis SQL and PL/SQL guidelines. The chosen solution is suited for various purposes such as dependency analysis beyond querying the Oracle data dictionary. This session presents the approach with the help of real-life examples.

Back to Top
Essbase Custom Defined Functions Soup 2 Nuts
Robb Salzmann, Accelatis
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Essbase

Many people are discovering the power of Essbase CDFs. Sometimes the documentation and examples can be a bit confusing in describing this complicated process, leaving users to fend for themselves. Essbase Custom Defined Functions - Soup 2 Nuts will present the attendee with the start to finish process for creating and using an Essbase CDF. During the session, we will create an actual Java class. The process of manipulating the new Java class into a usable CDF will be demonstrated and discussed including coding, creating the jar file, registering the jar with Essbase using Maxl, and viewing the CDF in the Calc editor. Finally, we will actually use the CDF we just created in a calc script. The aim is for the attendee to come away from this session with the knowledge and information needed to successfully create and use their own CDFs.

Back to Top
Using FDM to Manage Data Movement in a Multi-product Environment
Tony Scalese, Edgewater Ranzal
Co-presenter(s):

David Longo, Accellent

When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Essbase - Subtopic: Data Management

This session will explore data management in a 11.1.2.1 multiproduct (HFM & Planning) implementation. The use of FDM w/ERPi to load EBS general ledger actual data to HFM will be highlighted, as well as how, and more importantly, why FDM was used to move data (Actual & Budget) between the EPMA enabled applications. This session will discuss the best practices for how the consolidation and elimination engine of HFM was used to complement the driver-based capabilities of Planning. Finally, this session will discuss using FDM to load history from Hyperion Enterprise when upgrading to HFM.

Back to Top
Reducing Implementation/Upgrade Risk with FDM
Tony Scalese, Edgewater Ranzal
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: Essbase - Subtopic: Data Management

Are you about to embark on an EPM implementation or upgrade? You likely have identified that your biggest project timeline risk as data reconciliation/validation. In this session, learn how you can use your investment in FDM to mitigate this risk. See how a custom FDM solution has helped a number of EPM customers ensure that resources are freed up from the tedious data validation activities and are instead focused on value add activities such as testing functionality, building reports, or training end users.

Back to Top
Putting the Budget to Bed the Budget Process ... from Painful to Painless
Kent Schleich, City of Albuquerque
Co-presenter(s):

Janice D'Aloia, Mo'mix Solutions

When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Hyperion Applications - Subtopic: Planning

The City of Albuquerque, along with their implementation partner, Mo'mix Solutions, will present how their implementation of Hyperion Planning for Public Sector has helped them achieve their goals to replace an aging and outdated legacy budgeting system as well as to significantly improve and streamline the budgeting process. Their new system gives the City the ability to effectively analyze their budget data.

Back to Top
Writing Good SQL Code for MySQL
Baron Schwartz, Percona
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Database - Subtopic: MySQL

You need to consider many things when writing good queries, but what can you learn by focusing on the SQL code only, ignoring other topics such as table structures, indexes, and EXPLAIN plans? It turns out that textual analysis of SQL code can reveal a surprising amount, and thus it can be helpful to run "lint checks" on your SQL. This talk will show you how to spot and correct bad patterns in SQL, some of which are MySQL-specific, but many of which are platform-agnostic. The examples are drawn from problems the presenter has seen in the wild. The talk will also include an introduction to the open-source pt-query-advisor tool, which can help you analyze MySQL queries.

Back to Top
Introduction to Essbase Studio
Glenn Schwartzberg, interRel Consulting
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Essbase Beginner - Subtopic: Introductory content for new users

One of the exciting new features of Oracle Essbase 11x is the new Oracle Essbase Studio. You may have heard the buzz about this new Oracle Essbase design and management tool. Attend this session to learn the details of this big enhancement. Oracle Essbase Studio enables you to connect to several sources and build Oracle Essbase models more efficiently. Oracle Essbase Studio also adds new features such as XOLAP and expanded drill-through to sources beyond just relational databases (drill to anywhere). Oracle Essbase Studio will eventually replace both Oracle Essbase Integration Services and Oracle Essbase Administration Services, so start the learning process now.

Back to Top
So Many Tools, What Do I Use?
Glenn Schwartzberg, interRel Consulting
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Essbase

EIS, EAS, EPMA, ODI, OBIEE, FDM, ERPI, EPMA, Essbase Studio, EIEIO (Oh wait, the last one is old McDonalds). There are so many tools out there, which one should you use? This session will explore the similarities and differences of the different tools and how to select which one to use in different situations.

Back to Top
Integrating Oracle Essbase & OBIEE+ With Data Warehouse Strategy
Glenn Schwartzberg, interRel Consulting
When: Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Topic: Business Intelligence - Subtopic: OBIEE

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition helps drive value from your warehouse solution. Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

Back to Top
Next Level MDX
Glenn Schwartzberg, interRel Consulting
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Essbase - Subtopic: Essbase

Take your MDX skills to the next level during this session where experts help you get beyond MDX 101.

Back to Top
APEX 4 - Error Handling Enhancements
John Scott, APEX Evangelists
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

Let's face it, no application is perfect, but how you handle the errors in your application can make a big difference to how your end users perceive your application. With the new error handling capabilities in APEX4 you can do some truly amazing things. In this session I will show practical uses for what is possible and just how far you can take it.

Back to Top
APEX: When Push Comes to Shove (or Using HTML5 WebSockets)
John Scott, APEX Evangelists
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Plug-ins & Dynamic Actions

This session will cover one of the nice new features in HTML5, namely WebSockets. Rather than using the traditional polling methods to determine when data has changed in your application, WebSockets allow the server to PUSH notifications to the browser, which has all kinds of implications for scalability and usability of applications. The presenter will show some different ways in which you can use WebSockets in any APEX application to really make your application stand out.

Back to Top
Exactly How Ccomplex Can APEX Applications Get?
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

Join us in a discussion on what it takes to develop complex APEX applications: how to work with the framework and not against or around it and how to develop a well-performing APEX database application that complies to modern Web requirements. This session will go beyond the typical theoretical discussions, as well as compare first-hand experience of developing real APEX, Forms, and ADF applications.

Back to Top
Forms 11g, ADF and APEX: Co-existence in Enterprise Applications
When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Developers Toolbox - Subtopic: Tools

For some time now, Oracle Forms has addressed all the needs for database development. The next challenge is taking advantage of the newest features in Forms 11g and integrating enterprise Forms applications with other modern technologies, like ADF and APEX. We will present and exemplify live our first-hand experience of migrating large, enterprise Oracle Forms applications to Forms 11g, ADF and APEX. The demonstration will not only take into consideration the web layout redesign, but will also offer solutions for dealing with true challenges like: how to assess the amount of work, how to re-use components and preserve the investment in Oracle Forms, how to ensure a smooth coexistence of Forms 11g, ADF and APEX. Come and join us in discussing the lessons we have learnt from our latest migration projects, the dos and don’ts and much more.

Back to Top
Beginner's Guide to Oracle Hyperion Financial Reporting
Mehmet Sevinc, Bank of the West
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Essbase Beginner - Subtopic: Introductory content for new users

This presentation will include ten to fifteen steps to become an FR Studio Expert. Users with no Financial Reporting Studio experience will benefit from this presentation the most. At the end of the presentation, participants will understand the benefits of using FR Studio, learn the pros of FR Studio vs. using Excel reports, and see that FR Studio could be mapped to various database resources. Participants will also get to see a demonstration of building a Profit and Loss Variance Report using FR Studio.

Back to Top
Building Mobile Web Applications with Oracle Application Express
Marc Sewtz, Oracle Corporation
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

Oracle Application Express (APEX) is a declarative web application development tool for the Oracle Database. It allows to rapidly built applications that run on any platform that supports a web browser, including mobile devices. With smart phones and tablets approaching 10% of all browser usage, building web applications that work well and look good on smaller screens and respond to touch input and gestures, becomes increasingly important. To help our customers with building these kinds of user interfaces APEX integrates the jQuery Mobile framework. jQuery Mobile is a unified, HTML5-based user interface system, supporting all popular mobile platforms and built on the jQuery and jQuery UI foundation. This session gives an overview of the basics of jQuery Mobile, explains how it is integrated with APEX, and how customers can quickly build mobile web applications and extend their existing APEX applications with mobile capabilities

Back to Top
Evolving Hyperion Web Analysis to OBIEE Answers+
Markus Shipley, interRel Consulting
When: Wednesday June 27, Session 16, 3:00 pm - 4:00 pm
Topic: Business Intelligence - Subtopic: Reporting Solutions

Hyperion Web Analysis is not Oracle's strategic direction for ad-hoc analysis (against cubes or otherwise). Oracle is going to be putting all their research and development into OBIEE Answers+. With the newest release of Answers+ (11g), you now have much better access against Essbase, so the question is: how do I migrate from Web Analysis to Answers? Well, there isn't a migration tool, but this session will show you how to recreate your core Web Analysis functionality in Answers. The session will also let you know what, at the moment, Answers still can't do that Web Analysis can. In one hour, you'll be well on your way to moving to OBIEE Answers+!

Back to Top
Introduction to CapEX Planning
Markus Shipley, interRel Consulting
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Hyperion Applications - Subtopic: Planning

You may have already come across CapEx (capital expenditure) Planning and you may already even own it, but do you have any idea how to use it? In this session, you'll find out if CapEx is a good fit for your asset budgeting needs as this session goes behind the scenes. The session will show you the business rules, smart lists, accounts, formulas, and more that make up CapEx, so by the end, you'll know if CapEx is right for you. If you are considering CapEx and want to know if you should buy it or if you own it and want to know if now is the time to implement, don't miss this session.

Back to Top
Beginners Guide to Oracle Data Integrator for Oracle EPM Developers
Markus Shipley, interRel Consulting
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Data Management

HAL is circling the drain as our EPM solution for integrating EPM data. It is time for you to begin learning about the go forward strategy for Oracle EPM integration: ODI. ODI can interface hierarchies and data between source data systems and Hyperion Planning, Financial Management and Essbase, building dimensions, loading data, and extracting data. This session will introduce you to ODI and explain some of ODI's confusing terms like topology, data servers, logical and physical architectures, and knowledge modules.

Back to Top
SQL Developer Tips and Tricks
Jeff Smith, Oracle Corporation
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Developers Toolbox - Subtopic: Tools

You use the GUI because you want to be productive, right? Do you ever get the feeling you're only really using a small fraction of what the database and SQL Developer have to offer? If so, then you've come to the right place. Stock up on tips guaranteed to save you time, and make your experience with your code and the database much more enjoyable. If you ever write SQL or PL/SQL, then this presentation is for you.

Back to Top
Debugging PL/SQL With SQL Developer
Jeff Smith, Oracle Corporation
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Developers Toolbox - Subtopic: Tools

Do you need to know exactly what is being executed when your application runs and do you need to debug it while the application is running? Or do you need to debug batch jobs that can't be called from the command line due to complex setup scenarios? Throw out your DBMS_OUTPUT and use SQL Developer's remote debugging facility.

Back to Top
The Right Information, the Right Tool, the Right Time: Defining the Right Business Intelligence Architecture for Today's Complex OBIEE 11g Enterprise Implementations
Richard Solari, Deloitte
Co-presenter(s):

Joshua Kedzierski, Deloitte

When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: OBIEE

In the past, reporting was typically executed in silos, resulting in a proliferation of reporting tools to meet the disparate needs of each department, with each managed and maintained separately. OBIEE 11g offers a new vision of the convergence of EBS Publisher, EPM, and OBIEE into a centrally managed platform. Today's complex world requires a comprehensive BI architecture utilizing complementary tools to deliver the best of functionality while minimizing cost and effort. The presentation will include lessons learned from real-world experience and a review of solution tools and templates to properly define a BI architecture utilizing all of OBIEE's functionality.

Back to Top
Sustaining, Optimizing & Deriving the Value of your Enterprise BI Solution Using OBIEE Usage Tracking
Richard Solari, Deloitte
Co-presenter(s):

Nabhanil Mondal, Deloitte

When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Business Intelligence - Subtopic: Reporting Solutions

For large enterprise BI implementations, it becomes difficult to monitor, sustain, and optimize application performance. Usage Tracking, one of OBIEE's out-of-the-box capabilities, can be utilized beyond tracking report count or run times to define advanced KPIs to demonstrate the value of the implementation, tune performance bottlenecks, and optimize global deployments. The solution analyzes Dashboard vs. Answers Usage, usage trends, and application performance based on Geographical Locations. Analytical reports, including Heat Maps, charts, and trends can be built on top of this data. By understanding this analysis, participants will learn how to optimize the value and performance of their BI solutions.

Back to Top
Responsive Web Design and the Enterprise
Brian Spendolini, JSA2 Solutions
When: Wednesday June 27, Session 12, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Mobile Development & Advanced UI

Responsive web design allows the web page to adapt or respond to the device or screen size it encounters. From iPads to iPhones to BlackBerry devices and Android tablets, they all have a variety of screen resolutions. Don’t forget laptops and desktops. Business apps also need to scale to that 24-inch monitor on your desk to the 13-inch laptop in your bag. This presentation will walk the attendees through a responsive web design framework. See what’s behind the covers and what allows the pages to scale using HTML and CSS (cascading style sheets). In this presentation, the attendees will see a responsive application being built, tested, and displayed on a multitude of devices and screen resolutions and the resulting effect on the page itself. The business application builder being used will be Application Express, but the techniques can be applied to any web-based toolset.

Back to Top
Creating the Perfect APEX Development Environment
Brian Spendolini, JSA2 Solutions
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Developing in APEX is easy...but creating the environment to support this development is sometimes tricky. In this presentation, learn how to setup your browser for testing and developing in APEX. Next see how to build an APEX VM from scratch using free VM tools and operating systems. Next set up your desktop with the right text editors and development tools for optimal productivity. Next hear and see some tips and tricks that work for many of the star players in the APEX world. All tips/tricks and software will be presented for Windows as well as Mac environments.

Back to Top
High Quality PDF Printing with APEX & PL/PDF
Scott Spendolini, Sumneva
When: Tuesday June 26, Session 6, 8:30 am - 9:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

Since it's introduction, Oracle APEX has evolved from a basic toolkit for small applications to an enterprise-ready platform for applications of almost any size. However, one area has been at almost a standstill since its inception: printing. This session will discuss how to integrate PL/PDF - a 3rd party PL/SQL-based printing solution - with Oracle APEX, so that you can provide your end users with beautiful PDF reports in almost no time. It will use real-world examples and discuss now only basic reports, but also charts, templates and bar codes.

Back to Top
Upgrading the Fun Ships® with Oracle APEX
Scott Spendolini, Sumneva
Co-presenter(s):

Jermone Raja, Carnival Cruise Lines

 

When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Application Express - Subtopic: The Basics: Forms, Reports, Charts and More

Forget the new waterslides, the expanded suites, and the freshly renovated grand ballrooms. The best upgrade to Carnival Cruise Lines ships is Oracle Application Express! On every Carnival Cruise Lines ship is an Oracle Database 11g server, tasked with running the property and guest management systems. Originally installed almost twenty years ago, many of the applications built to interact with the database are still in Oracle Forms – some even in character mode. As times and regulations changed, it was becoming increasingly difficult to adapt these systems to both SOX and PCI requirements. In order to satisfy these requirements, management was looking to modernize theses systems, but trying to do it in the most cost-effective way possible. Thus, Carnival turned to Oracle Application Express 4.1 to modernize their systems. With the assistance of Sumneva, Carnival was able to migrate a working prototype of their embarkation application from Forms to APEX in less than two days! The new APEX-based embarkation application interfaces with existing passport and credit card readers, which will speed up the check-in process significantly, providing both cost savings and more revenue for Carnival. Perhaps most importantly, Carnival was able to leverage their existing staff of PL/SQL developers and their domain expertise, as very little of the existing sophisticated PL/SQL code had to be changed. This system will eventually be rolled out to all twenty-three Carnival ships and will lead the charge in modernizing all Forms-based applications to Oracle APEX in the near future.

Back to Top
Securing APEX Applications with sumnevaSERT
Scott Spendolini, Sumneva
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Cibolo Canyon 5
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Security in information technology is more critical today than it ever has been. Breaches are unfortunately all too common. As an APEX developer, securing your applications falls squarely on your shoulders. However, often times security becomes an afterthought; if it gets addressed at all. For this reason, we developed sumnevaSERT. sumnevaSERT is an APEX application that quickly evaluates your APEX applications for common security vulnerabilities and provides step-by-step instructions on how to mitigate them. sumnevaSERT is not just an evaluation tool, but it’s also designed to be used by your developers during your development process, as it has complete integration with the APEX development environment. Whether you have a single APEX application or hundreds of them, sumnevaSERT can help ensure you that they are as secure as they can possibly be.

Back to Top
Integrating Business Rules with SOA
Payal Srivastava, Oracle Corporation
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Fusion Middleware - Subtopic: SOA

This session will include specific examples of how business rules can make SOA applications more flexible; including ways to let business users make changes.

Back to Top
Compelling, Dynamic, Graphical - And If We Are Lucky - USEFUL E-mail Generation
Timothy St. Hilaire, BAE Systems
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Application Express - Subtopic: Integration, Migration, Web-Services

With all of the draws to get individual attention from users, how do you make e-mail communication effective? How many systems are built where the primary use is to generate SPAM mail? This presentation will discuss techniques for including complex reports, dynamic graphics, and user feedback within e-mail communications with the goal of making the message itself more effective and relevant. Examples will include: Dynamic Images, consuming external reports for communication, e-mail construction techniques, follow-up methods with security considerations, and methods for managing e-mail follow-up.

Back to Top
All About the APEX Listener
Timothy St. Hilaire, BAE Systems
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Application Express - Subtopic: Infrastructure/Management/Security

With the release of the Java-based APEX listener, there is an even easier way to implement your APEX applications. The J2EE implementation offers functionality including a Web-based configuration, enhanced security, Excel uploading, and file caching. This session will show how to deploy and configure the APEX listener, how to test for common installation issues, and secure your implementation. The session will go through a full installation showing how easy configuration is and demonstrating the debugging methods discussed.

Back to Top
End-to-End Oracle ADF Development in Eclipse
Greg Stachnick, Oracle Corporation
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Fusion Middleware - Subtopic: ADF

With Fusion Applications now a reality, interest in Oracle ADF development is at an all time high. In addition to the flexibility of runtime frameworks, Oracle offers a choice in development tools for ADF. In this session, attendees will learn how to use Oracle Enterprise Pack for Eclipse to author rich ADF applications using standard JEE technologies, like JPA, EJB, and Web Services to build rich applications using Oracle ADF Faces and Oracle ADF Task Flows deploying to Oracle WebLogic Server. This demo-driven session will explore design time support for ADF dependency analysis, debugging, and refactoring to iteratively develop an application in real time.

Back to Top
The Four User Types of OBIEE
Steven Stein, INFOSYS
When: Thursday June 28, Session 19, 11:45 am - 12:45 pm
Topic: Business Intelligence - Subtopic: OBIEE

There are many types of users, and you'll learn to show the business what the different OBIEE users want. Originally formulated during a large state government implementation with dozens of agencies reporting needs at stake, this presentation clarified the use of OBIEE and the optimal direction to take for nearly a thousand reporting requirements.

Back to Top
OBIEE11g Clustering and High Availability: Hack Fest
Borkur Steingrimsson, Rittman Mead Consulting
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Business Intelligence - Subtopic: OBIEE

Looking in to the possibilities of the extensive capabilities of the scripting environment of OBIEE11g, we will start to see amazing options for us to expand our implementations. Reconfiguring an embedded OBIEE system or re-arranging the system components to better fit our needs can all be achieved with some well placed 'hacks.'

Back to Top
OBIEE Answers and BI Publisher: Friends or Foes?
Borkur Steingrimsson, Rittman Mead Consulting
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Business Intelligence - Subtopic: Infrastructure/Management/Security

With the great enhancements of the Oracle Business Intelligence Publisher functionalities in the 11g version, a lot of similarities can be found in comparison to OBIEE Answers. Can one be considered to be a direct competitor to the other? Or are these two tools mutually beneficial to us and only extend the ways in which users can exploit OBIEE?

Back to Top
Beyond the Whitepaper - Fully Customizing OBIEE 11g
Ben Strykowski, Accenture
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Business Intelligence - Subtopic: OBIEE

Attendees will learn how to customize OBIEE 11g well beyond the short 'Customizing Oracle 11g Whitepaper' released by Oracle earlier this year. This has proved to be invaluable to many customers and clients in light of the dramatic changes Oracle has made in releasing OBIEE 11g. The main goal is to provide custom UI functionality available in 10g within 11g for customers looking to preserve the consistency of their application when migrating from 10g. Additional custom options will be covered as well.

Back to Top
An Oracle Geek's Guide to Successful Dating
Sean Stuber, American Electric Power
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Developers Toolbox - Subtopic: Coding

A short examination of Oracle's date/time datatypes and best practices for manipulating them in SQL and PL/SQL.

Back to Top
Joined at the Hip: Integrating Planning and Essbase Applications with HFM and FDM
Deanna Sunde, The Hackett Group
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Hyperion Applications - Subtopic: Planning

Don't be caught stuck in a silo when integrating Oracle Hyperion Planning and Essbase with HFM. Designing integrations for global organizations with complex entity structures, elimination entries, and multiple currencies requires special consideration. Using a case study approach, best practices in designing dimensions and integrating metadata are presented. Different options are discussed along with the corresponding pros and cons and EPMA implications.

Back to Top
Enterprise-wide Performance Management Using OBIEE, Essbase & DRM: Eaton Vance Case Study
Kevin Taylor, Eaton Vance Corporation
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Business Intelligence - Subtopic: BI Applications

This session demonstrates how asset management firm Eaton Vance partnered with Performance Architects to provide company-wide analytics using OBIEE, Essbase and DRM. The discussion includes an overview of the business opportunity, outlines the requirements process, technical architecture, and change management in relation to data governance and integration using DRM. The discussion will also address lessons learned using these tools together. The presentation will conclude with an overview of Eaton Vance’s future plans for continuing to use these tools as its enterprise-wide reporting and analytics platform, integrating both sales and assets under management (AUM) metrics and metadata.

Back to Top
Design Time, Design Time @ Run Time, Personalization...What the Huh?
Floyd Teter, Innowave Technology
When: Monday June 25, Session 5, 4:15 pm - 5:15 pm
Topic: Fusion Middleware - Subtopic: AppsTech

This session will review the functionality, use cases, and architecture behind Design Time, Design Time @ Run Time, and Personalization. Learn the concepts and tools supporting each method and when to use what.

Back to Top
Moving Beyond the P&L: Essbase for Bank Planning and Technology Reporting
Evan Thayer, E*TRADE Financial
When: Monday June 25, Session 4, 2:45 pm - 3:45 pm
Topic: EPM Business Content - Subtopic: Case Studies/Panels

Join E*TRADE Financial as they discuss the implementation of two new Essbase applications designed to support Capital Markets Finance and Technology Finance. E*TRADE Financial implemented Hyperion Planning and Essbase for P&L planning and forecasting almost ten years ago, but only recently began to leverage Essbase for expanded purposes. Learn how the Capital Markets and Technology Finance teams leveraged Oracle, ODI, and Essbase to implement automated processes and new cubes to replace time intensive and manual processes for various reporting and forecasting needs. This session will provide an overview of the process changes, application design considerations, and lessons learned from the projects.

Back to Top
Equity Pickup and Complex Ownership
Danny Tijerina, Ernst & Young
When: Tuesday June 26, Session 10, 3:45 pm - 4:45 pm
Topic: Hyperion Applications - Subtopic: HFM

Learn the techno speak behind the accounting and how to accomplish equity pickup and complex ownership

Back to Top
Accounting Speak for the Techno Geek
Danny Tijerina, Ernst & Young
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

Are you a geek and want to get a better understanding of financial jargon, then this session is for you.

Back to Top
Financial Close All Stars Panel
Danny Tijerina, Ernst & Young
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: HFM
Advanced Essbase Java API Tips and Tricks
Tim Tow, Applied OLAP
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Essbase - Subtopic: Essbase

Essbase is a key component in the Oracle Fusion Applications strategy. As the Oracle Fusion Applications are written in Java, it is clear the Essbase Java API plays an important role in Oracle's future. Attend this session and learn Essbase Java API tips and tricks from one of the world's experts in the Essbase Java API. The session will cover some of the common issues developers encounter when writing Java API applications, as well as tips on how to build and maintain dependable software that utilizes Essbase.

Back to Top
Oracle Fusion Accounting Hub: Where Oracle Fusion and Essbase Become One
Tim Tow, Applied OLAP
Co-presenter(s):

Rob Zwiebach, Oracle Corporation

When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Essbase - Subtopic: Essbase

Since the acquisition of Hyperion by Oracle, many Essbase professionals have wondered about the future of Essbase and how Oracle may leverage Essbase in its Fusion strategy. Wonder no more as Oracle has made Essbase a core component in its Oracle Fusion Accounting Hub. This session will explore the usage of Essbase within the Fusion Accounting Hub product and what it means for Essbase professionals. The session will also discuss integration of the Fusion Accounting Hub with HFM and strategies for deploying Fusion Accounting Hub over top of existing general ledgers including E-Business Suite, PeopleSoft, and others.

Back to Top
Solving the Performance Management Puzzle: Dodeca® Customers Reveal Their Answers
Tim Tow, Applied OLAP
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Cibolo Canyon 8/9
Topic: Vendor Presentation - Subtopic: Vendor Presentation

Modern corporate systems are large and complex and often have many pieces that need to fit together. Dodeca helps companies complete their systems by providing a flexible, scalable, high-performance user interface platform for delivering the right information to users regardless of its source. Attend this panel discussion featuring representatives from The Kroger Company, Wells Fargo, and Forestar, who together have over 20,000 Dodeca users, and learn how these companies have leveraged Dodeca to improve their user’s experience and how they realized a greater return on their investment in Oracle Essbase and other database technologies.

Back to Top
Hyperion Planning Approvals and Data Validation
Jake Turrell, US-Analytics
When: Wednesday June 27, Session 14, 11:15 am - 12:15 pm
Topic: Hyperion Applications - Subtopic: Planning

With the release of Hyperion Planning 11.1.2, Workflow and Data Validations are tightly integrated. This presentation will walk attendees through the process of configuring Approvals. A detailed live demo will highlight each of the three Approvals templates and show how Data Validations can be inserted into the workflow process.

Back to Top
Running Hyperion Planning on Your Laptop
Jake Turrell, US-Analytics
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Hyperion Applications - Subtopic: Planning

Hyperion Planning and its related applications represent an increasingly complex and frequently changing set of tools. The associated learning curve is significant, and staying up-to-date can be difficult. Developers who want to master these tools need an environment where they can learn and experiment without affecting a "real" environment. A personal EPM Sandbox environment is a critical tool for any serious developer or administrator who wants to gain a deeper understanding of Hyperion Planning. This presentation will provide attendees with a step-by-step guide to getting Hyperion Planning up and running on a laptop.

Back to Top
Survival of the Fittest: How to Evolve Your Existing Oracle Forms Applications to the 21st Century
Mia Urman, OraPlayer
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Developers Toolbox - Subtopic: Tools

What are you supposed to do with the fifteen plus years of investment you have in Oracle Forms? Just throw it away? Let it stagnate? Or are there other options? This session will discuss the game plan for Forms users to move into new platforms with existing systems. Topics include: upgrading to Forms 11g (including new features demo), developing and integrating with ADF/APEX, and how to exploit Oracle Forms business logic in new channels. The session will then go one step further by demonstrating an ADF data control to run Oracle Forms business logic silently from an ADF faces UI and an ADF mobile application.

Back to Top
Oracle Forms Extreme Makeover - Tips and Tricks for Oracle Forms GUI Modernization
Mia Urman, OraPlayer
When: Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Topic: Developers Toolbox - Subtopic: Tools

Think migration is the only way to get modern, sleek looking web applications? Do we really need a new technology to have good looking Forms systems? This session will give practical tips and tricks on how to modernize the look of your applications WITHOUT migration! The session will show how Forms can be transformed using only design techniques, incorporating Java elements, and integrating with ADF technology. The session will also show a live demo of taking a tired old Forms system and bringing it into the 21st century.

Back to Top
Enterprise Projects Financial Planning - An Integrated Approach
Shankar Viswanathan, Oracle Corporation
When: Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
Topic: EPM Business Content - Subtopic: EPM Business Content

Hyperion Planning's Enterprise Project Planning Application comes with the inherent capabilities for task-based proposal and rank-based and KPI-based approval of project plans. Project funding decisions are closely tied to the long-range plans of the organization. Project forecasts give an early indication of revisions needed to a project which in turn can influence changes in the organization's long-range plans. The application allows for an integrated closed loop process during the various phases of a project's life cycle in an organization.

Back to Top
Deep Dive into the New Features in Planning 11.1.2.2
Shankar Viswanathan, Oracle Corporation
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Hyperion Applications - Subtopic: Planning

The 11.1.2.2 release of Planning comes with a new pre-packaged Project Financial Planning Application and provides a new Web 2.0 look and feel user experience for Hyperion Planning on the Web. Within its Smart View for Office interface, the Predictive Planning capabilities allow Planning users to improve accuracy through the use of statistical forecasting. The availability of Strategic Finance within Smart View in this release now allows users of Strategic Finance to perform real time what-if scenario modeling in Excel and tie it into their Planning process. The release also delivers significant enhancements to the Public Sector Budgeting Application offering.

Back to Top
EPM Development Panel
Toufic Wakim, Oracle Corporation
When: Monday June 25, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Infrastructure/Management/Security
To Slice or Not to Slice? The Next Advancement in ASO Cubes.
Angela Wilcox, BI Architect – MedAssets
When: Wednesday June 27, Session 13, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: Essbase

As the new ASO technologies come out with each release, it is increasingly difficult to find in-depth information on the features as well as functional examples of when and how to use them. This session will go into the details of when and how to use the new ASO slices. It will address the undocumented information of how these work and things that need to be considered as you make decisions. Code examples will also be provided on merging, loading, clearing, and agging when using slices.

Back to Top
Why Can't I Look at an Essbase Cube?
Angela Wilcox, BI Architect – MedAssets
When: Monday June 25, Session 2, 10:00 am - 11:00 am
Topic: Essbase Beginner - Subtopic: EPM Beginner Track

This session is ideal for the brand new Essbase developer who wants to understand this new technology. One of the key challenges early on is being able to draw correlations between Essbase and other technologies you are used to (maybe SQL Server, or DB2, or Oracle Databases) working with. Working from a long history of training and mentoring new developers, this session will draw on real-life examples and techniques for assisting the user in understanding what Essbase is and how it fundamentally works.

Back to Top
EPM/BI Testing - Best Practices Before and After Implementation
Angela Wilcox, BI Architect – MedAssets
Co-presenter(s):

Ron Dempesmeier,

When: Monday June 25, Session 3, 11:30 am - 12:30 pm
Topic: Business Intelligence - Subtopic: OBIEE

Drawing from a session presented at OpenWorld for 2011, the presenters will take their most asked about features from the presentation and present it for Kscope users. Not only will the user walk away with an enhanced sense that they understand some of the key requirements and best practices for testing new applications, but the user will have some code examples and steps for creating their own tracking tools for installations that have gone live.

Back to Top
Implementing Financial Close Management & Custom Integrations
Rich Wilkie, Oracle Corporation
When: Tuesday June 26, Session 11, 5:00 pm - 6:00 pm
Topic: Hyperion Applications - Subtopic: Reporting and Other Hyperion Apps

Get the most out of Oracle Hyperion Financial Close Suite by learning some of the latest tips and tricks for optimizing your Financial Close Management solution. In this session, you will learn about Close Manager custom integrations with leading Oracle and non-Oracle solutions. Additionally you will learn about the new Account Reconciliations module which is dedicated to the management of account reconciliations.

Back to Top
Intro to HFM 11.1.2.2: Working with Almost Unlimited Custom Dimensions, and Intro to an Entirely New User Interface
Rich Wilkie, Oracle Corporation
When: Thursday June 28, Session 18, 10:30 am - 11:30 am
Topic: Hyperion Applications - Subtopic: HFM
Intro to Oracle Financial Management Analytics (HFM pre-built dashboard for OBIEE)
Rich Wilkie, Oracle Corporation
When: Thursday June 28, Session 17, 8:30 am - 9:30 am
Topic: Hyperion Applications - Subtopic: HFM

to come

Back to Top
Hyperion Report Creation and Automation Using Smart View VBA Functions
Jim Wilking, Harbinger Consulting Group
When: Tuesday June 26, Session 7, 9:45 am - 10:45 am
Room: Grand Oaks E
Topic: Vendor Presentation - Subtopic: Vendor Presentation

In addition to performing ad-hoc analysis, Hyperion Smart View is used for report generation. HCG senior consultant Jim Wilking will demonstrate various ways to streamline and automate Smart View reporting to increase reporting efficiency, allowing users to focus on analyzing data rather than generating reports. Using Essbase as an example, HCG will provide a high-level overview along with tips and tricks for utilizing Smart View automation and VBA toolkit functions.

Back to Top

Enter your e-mail to be added to our database so you will not miss any deadlines.


From Twitter

    Sorry, this stream was unable to get updates. Please check settings or wait for the service to return.