ODTUG Kscope12 - Presentations

Robb Salzmann, Accelatis

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.

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.

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?

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.

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.

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.

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.

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...?"

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

Stephen Bowden, Peloton

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.

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.

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.

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.

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.

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.

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.

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.

Chris Bauman, Pepperdine University

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.

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!

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.

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.

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.

Ervin Peter, Deloitte

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.

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.

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.

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.

David Collins, Ernst&Young

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Nikos Psomas, Oracle Corporation

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.

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

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.

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.

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.

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!

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.

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.

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.

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.

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.

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.

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.

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.

Joe Huang, Oracle Corporation

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.

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.

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.

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.

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.

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.

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.

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."

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.

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.

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.

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.

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.

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!

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

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.

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.

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.

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.

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!).

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Greg Vlahos, Analytic Vision

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.

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.

Duncan Mills, Oracle Corporation

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.

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.

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.

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.

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.

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.

Chris Bales, Oracle Corporation
Noel Portugal, Oracle Corporation

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.

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.

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.

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.

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.

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.

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.

Planning and HFM experts answer your tool related questions.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Pete Cammisa, Innovus Partners

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.

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.

Maria Colgan, Oracle Corporation

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.

Todd Weinstein, Huron Consulting Group

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.

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?

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!

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.

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.

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.

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.

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 .

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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!”

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.

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.

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.

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.

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.

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.

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.

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.

Learn core debugging techniques for ADF-based Frameworks.

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.

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.

Stephen Bowden, Peloton

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.

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.

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.

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.

Grant Ronald, Oracle Corporation

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.

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.

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?

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.

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.

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?

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.

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.

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.

Peter Raganitsch, click-click IT Solutions

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.

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.

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!

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.

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.

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.

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.

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

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.

 Jonathan Etkin, Performance Architects

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!

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.

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.

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.

Shankar Viswanathan, Oracle Corporation

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

 Paul Holliman, UK Government

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.

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!

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

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!”

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Abstract to come.

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.

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.

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.

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.

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.

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.

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.

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.

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.

David Longo, Accellent

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.

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.

Janice D'Aloia, Mo'mix Solutions

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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

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+!

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.

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.

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.

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.

Joshua Kedzierski, Deloitte

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.

Nabhanil Mondal, Deloitte

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.

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.

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.

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.

Jermone Raja, Carnival Cruise Lines

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.

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.

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

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.

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.

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.

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.

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

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?

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.

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

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.

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.

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.

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.

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

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

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.

Rob Zwiebach, Oracle Corporation

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Ron Dempesmeier,

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.

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.

to come

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.