Multi-unit, multi-concept restaurant companies face challenging reporting requirements. How should they compare promotion, holiday, and labor performance data across concepts? How should they maximize fraud detection capabilities? How should they arm restaurant operators with the data they need to react to changes affecting day-to-day operations as well as over-time goals? An industry-leading data model, integrated metadata, and prebuilt reports and dashboards deliver the answers to these questions and more. Deliver relevant, actionable mobile analytics for the restaurant industry with an integrated solution of Oracle Business Intelligence and Oracle Endeca Information Discovery.

Training seminars are usually delivered as a set of tasks combined by instructions for execution. While this "click here, then here" approach may demonstrate "how" to visualize data using OBIEE, attendees are less likely to understand "why" particular choices were made. What's missing from this paradigm is "content." Without it, users get confused about why they are performing certain tasks. In this results-driven hands-on lab, attendees will build dashboards that use data to tell a story, conform to best practices in dashboard design, and never lose focus on the finished product.

During the rollout of Smart View to thousands of users, GE experienced a high number of support requests around the use and navigation in Smart View. This presentation will describe the tools and techniques GE's administrative staff used to meet this challenge. Using the Smart View Toolkit, the Excel API, and freeware from Microsoft, GE has created enrichments to the Smart View user interface. In this presentation, I display and demonstrate a fully customized Excel ribbon designed to group commonly used Smart View menus and controls in an intuitive and easy to learn fashion.
This presentation will also detail the methods and tools used to make Smart View's use easier and more intuitive for GE's users. Easily created custom menus will be showcased along with the tools and techniques used to create them.
The benefits users have received from this work are:
* Easy intuitive navigation and use of options and settings---options are grouped and presented in one logically arranged dialog.
* Put more distance between the Refresh and Submit Data buttons!
* Added missing and difficult to find menu items, such as Alias Table Selection, Substitution Variable Maintenance Refresh All, Query Designer, "Zoom-on-the-fly"
* Two custom user ribbons: user and admin

The interRel MythBusters team will prove and disprove urban legends and popular misconceptions about the latest release of Oracle Hyperion Planning. Uncover the truth behind the myths of Hyperion Planning's popular key selling features and their implementation realities. We'll confirm or bust myths about the new features, such as ASO plan type and adding members on-the-fly, and provide clarity to other features often over extrapolated. Become better educated and set realistic expectations for your planning implementation and upgrade. If you are about to start a Hyperion Planning implementation or are looking to upgrade to the newest version, don't miss this presentation!

In the upcoming release of Oracle Application Express 5.0, there will be once again many significant major product enhancements, the so-called "marquee features" as described in the Statement of Direction (SOD) for Oracle APEX. Nevertheless, the APEX team will, in addition to the marquees features, add a ton of smaller improvements that will improve the developer's productivity. This presentation will focus on the many smaller enhancements of the product.

All roads lead to Rome ... with regards to Oracle Application Express, one can choose many different approaches to generate print-ready reports in various formats, such as PDF, RTF, MS Excel, MS Word, and many others. There are myriad technologies and products one can use to generate reports, such as BI Publisher, JasperReports, Cocoon, BIRT, PL/JRXML to PDF, PL/PDF, and out-of-the-box functionality leveraging the APEX Listener. In addition to that, there are also numerous plug-ins available as well.
All of the above will use different technical approaches, and have different requirements and different pros and cons. In this presentation, get an overview of the most important options and their requirements, and when to use which.

Security threats to web applications are ever present and increasingly exploited using automated tools. Our experience with security testing APEX applications shows that in many cases exploitable SQL Injection conditions arose due to insecure code patterns. The impact of simple coding errors can be substantial. It allows an attacker to take control of the APEX instance and access sensitive data in the database. We will explain how simple code changes can fully protect against SQL Injection.

The ability to find, analyze, and quantify individual or groups of patterns within a data set is now a key business requirement. The Oracle Database already supports the discovery of simple patterns through the use of features such as the LIKE operator and regular expressions. For more sophisticated pattern matching requirements, developers have been forced to write complex code that involves a lot of data movement, which increases the complexity of performance optimizations, increases data latency, and reduces data security. Oracle 12c provides a completely new native SQL syntax that uses the power of regular expressions to allow inter-row pattern search capability. In this session, we'll explore the new 12c MATCH_RECOGNIZE construct that allows us to define patterns---in terms of characters or sets of characters---and provides the ability to search for those patterns across rows.

Oracle ACE and music expert Chris Barbieri takes you on a musical journey of the implementation lifecycle of Hyperion Financial Management through music. From David Bowie's countdown in "Space Oddity" to Pink Floyd's "Money," Chris guides you from requirements, design, through go-live.

In this third installment of the "What Would Happen..." series, Chris Barbieri takes a Mythbusters approach to explain what would happen if I...
- Changed the Org By Period flag on an existing application?
- Added a dimension or two - what happens to rules and reports?
- Added years to an application?
- Changed an account's Line Item Detail flag?
- Removed the Allow Adjs flag on an entity?
- Changed the alias on a custom dimension?
The central theme for this session is how to set up and test each situation, and also observe the application and database changes associated with each. The outcome will provide you with a much deeper understanding of how HFM actually works.

There is a lot of misinformation and myths about what happens during an HFM consolidation. For most, the HFM Consolidation Engine is a black box that impacts the most vital aspect of your financial close process. In this session, we will look under the hood and provide you with insight on the consolidation software. Learn details from the team who wrote the engine and ask them questions that will help you improve your consolidation performance and predictability.

This is a practical HFM/Essbase session intended to educate HFM users about Essbase. It will be less conceptual than the Comparative Anatomy session done two years ago. This session will have a deeper discussion of individual features and specific design options. For instance, I will cover how HFM handles YTD reporting vs. multiple options in Essbase.

This session will walk through how the Help Desk can be leveraged to simplify and expedite the support cycle. We'll also explore tools and methodologies for building a Hyperion Help Desk. Lastly, we'll look at how several Hyperion clients have developed Help Desks of varying complexities. We'll show details on the effort that went into developing the Help Desk process as well as the benefits they've received. We'll also discuss how Accelatis software for Oracle Hyperion can also help streamline the support process.

You've lived with your Planning application, but you're just not loving it anymore. Discover why not and what to do about it so you can fall in love all over again. Using real-world examples, Nick Blazosky will guide you through how to give your Planning application an extreme makeover. It will include practical tips for managing a Planning overhaul from both a technical and a functional standpoint. You will also learn some of the common pitfalls that derail redesign efforts and best practices for avoiding them. Let this session be your guide in explaining a proven step-by-step approach to application redesign. So before you strip your application down to the studs, attend this session and pick up some tools of the trade to help you with your Planning remodel.

The convenience and productivity gains that mobile devices provide are driving the growth of mobile EPM reporting. As a result, many companies are beginning to roll out mobile EPM reporting solutions, perhaps for the first time ever. Of course, there are many considerations, and this session will focus on mobile EPM best practices. We will identify and answer many of the important questions, including:
* How do we connect to our reports when working from home or traveling?
* Can we encrypt the data?
* What additional security can we use to secure our data?
* Does the mobile device cache any of the reports?

ADF Essentials provides probably the most powerful (free) framework for developing Java/JEE web applications with high productivity and rich functionality in Oracle JDeveloper or Eclipse (with the OEPE plugin) that can be deployed across JEE Containers, including Tomcat, JBoss, WebSphere, GlassFish, and WebLogic. ADF Essentials is exactly the same as ADF; it is just a subset of ADF. Even some of the highly advanced features in ADF are included in ADF Essentials, such as Data Visualization (DVT), Business Components (ADF BC), Data Binding, and Taskflows. The parts not included in ADF Essentials are by and large more for specific use cases or targeted at integration with other components in the Oracle Fusion Middleware stack. In this session, you will learn how you can use ADF Essentials to develop applications with rich functionality at low cost.

Virtually every mobile app has some kind of location-based services and interaction with social networks. Usually an app is also able to receive push notifications and work with these notifications.
ADF Mobile enables you to implement features like this and interact with the world surrounding the mobile device. In this session, you will learn how to hook up your device to such sources of "remote" information.

Oracle ADF Mobile has been around for a while. There is a great developer guide available for everybody who wants to create an ADF Mobile application. However, when you are building your first ADF Mobile application you will definitely run into issues that cannot be resolved by reading the developer guide.
Think of performance issues when taking pictures with modern devices. Images can take up to five megabytes. How on earth can you upload these to your enterprise database? How do you make your application look like a native app? What can you do to create a grid-like springboard? These are all topics not covered by the developer guide or by any available ADF Mobile training. In this session, you will learn solutions for these and more ADF Mobile challenges.

Oracle DRM has established itself as the leading platform for effective management of dimensions, attributes, and other enterprise metadata. This session will provide valuable tips to accelerate DRM projects by demonstrating the steps required to plan, use, and manage the tool. Explore the best practices and common pitfalls associated with DRM deployment. Learn what to do at the keyboard when starting from scratch and performing common dimension management functions.

There are those who say that the reports in Hyperion Financial Reporting cannot be sped up. They are the speed they are, and it's all based on how much data you're seeing in the reports. While the number one thing you can do to speed up your reports is to speed up your data source, there are at least 10 major things you can do to speed up your report itself. Come learn these tips along with the hot features in 11.1.2 that will improve and speed up your FR reports.

This presentation is about protecting data and access within the Oracle database. I will be explaining and demonstrating available features. Pros and cons will be addressed, but ultimately it is for each designer and developer to decide what is best in a given situation. The importance of minimal permissions and need-to-know will be highlighted, as well as ways to prevent or at least monitor access by users with DBA or ANY privileges.
Roles, application context, and virtual private databases are all mechanisms that can be applied to restrict access to a level that is tailored to the needs of a user group. Database Vault can restrict access to any type user---including the DBA---and Label Security adds multi-level access control.
Coded solutions to increase security include:
- Refrain from direct table access and use API's instead.
- Be mindful of SQL injection.
- Detect and encounter execution of DDL in general or against certain objects.
- Consider splitting elements of sensitive data and apply independent protection.
* Apply encryption to anything from individual fields to columns, tables and an entire tablespace.
* Log what is going on and protect the log. After all, if something is stolen or tampered with it is best to know about it.

Are there really cost benefits for using virtual machines versus physical servers? What are the pros and cons of either solution? Is it safe to use virtual servers in a production environment? In this session, we will discuss performance, cost, and risk mitigation differences of Essbase servers when used in virtual versus physical configurations.

This presentation will walk you through the steps of migrating an MS SQL database to Oracle using Oracle's free tool SQL Developer. I will also cover some of the pitfalls to avoid during the process. While this presentation will only cover MS SQL, it applies to several other DB platforms. If you need to move some data around in your development environments and allow your DBAs to focus on production, then this session is for you.

A successful real-time BI implementation involves integrating the logical and physical model, source and target databases, ETL subsystems, and front-end dashboards and reports. Agile methodologies often struggle to deliver real-time implementations due to the complexity of the intermingled moving parts.
Using the Oracle Information Management Reference Architecture as a backdrop, attendees will see how to construct a complete real-time BI system using Oracle Business Intelligence, Oracle Data Integrator, and Oracle GoldenGate, driven by an Agile approach that focuses on user stories and time-boxed iterations.

The Oracle Business Intelligence (OBIEE) metadata repository is arguably its most powerful feature, but is also its single greatest barrier to entry for new developers. This barrier is harder to cross when those developers are new to enterprise BI Tools, or perhaps new to BI in general.
The goal of this session is to introduce the OBIEE metadata repository to new developers, including a step-by-step demonstration of the development process. Attendees will understand the value that the Business Model and Mapping (BMM) layer adds to the metadata repository and how to utilize its features for their own internal projects.

Enjoy a webcast live with Kevin McGinley and Stewart Bryson. Come to this unique and fun event during which they will host an interview-style panel with guest stars, important discussion, and a little comedy. Don't miss this important Business Intelligence event!

The latest, greatest incarnation of Oracle Database, 12c, is chock full of interesting and exciting new features. This presentation introduces the attendee to just three of them available within SQL alone. Top-N queries can now employ simpler syntax with the use of the new row_limiting clause, which allows you to limit the rows returned by a query. You can also now define a PL/SQL function in the WITH clause of a query and reference it within the query, as well as any of the query's subqueries.
And last but not least, temporal validity enables you to have data visible depending on its time-based validity, as determined by the periods of time for which it is considered valid. Any application can now support a situation where it is important to view only the data within a table considered valid as of a specified time period instead of all the data within a table, which is the current default. This presentation provides an overview of each of these valuable 12c features with a comparison of the effort required to code your applications to obtain similar results but with different methodologies.

With BI Applications 11.1.1.7, this presentation will highlight the architecture and model changes from the database to ETL, the BI repository (RPD), and the presentation layer, offering insights and recommendations around BI Applications on Oracle Data Integrator.

This Deep Dive into APEX Interactive Reports explores APEX 5.0 features and all usability enhancements since their introduction in APEX 3.0.
We'll cover APEX 5.0 new features, APEX 4.2 new features, dynamic actions, navigation and printing options.
This session highlights the Good - IR's are very powerful, are you leveraging it all? , the Bad - all this power has some limitations - and the Ugly - style and printing features still have a ways to go. We'll demonstrate how to maximize the good, work with or around the limitations, how to style Interactive Reports pre and post APEX 5.0 and detail basic and complex PDF print options.
Are you leveraging the full power of Interactive Reports? This session gives you the knowledge to do so.

To enable world-class planning capabilities for organizations of all sizes, Oracle has released Oracle Planning and Budgeting Cloud Service (PBCS), providing finance organizations the ability to:
* Quickly deploy world-class planning applications in the cloud
* Easily scale planning deployments across organizations
* Not be bogged down by CAPEX infrastructure investments or on-site infrastructure maintenance
Peloton is proud to sponsor the Hands-On Training sessions at Kscope14. Learn how Oracle's Planning and Budgeting Cloud Service can give your organization easy access to world-class planning capabilities.
During this training session, you will learn how to:
* Load data into Oracle Planning and Budgeting Cloud Service
* Configure a basic planning application in PBCS
* Navigate through the new cloud-based configuration and setting capabilities

Recx is at the forefront of Oracle APEX security. This has given us unique insight into the key security issues that face APEX applications today. This presentation will show the most common security issues found within typical APEX applications.

In this hour, attendees will use Oracle SQL Developer Data Modeler to connect to an existing database and reverse engineer it to a relational and logical data model. They will then see how they can customize the display of their diagrams, make changes to their models, and version those changes using the integrated Subversion support. SQL Developer Data Modeler is ideal for the single designer and for team environments. Attendees will see how easy it is to accommodate both design environments using this completely free set of technology from Oracle.

Participate in this hands-on lab to learn about the new Oracle SQL Developer 4.0 RESTful services. REST can be accessed from any client and any language, making database applications more accessible than ever. The new RESTful services make this easier than with many other options.

In this case study, hear how the United Technologies Corporation, a globally distributed, Fortune 500 company manages their Oracle Hyperion EPM metadata using Orchestra Networks' cost-effective, DRM alternative: MDM for Oracle Hyperion EPM. The session will cover practical issues: data exchange with HFM, governance, workflow. Also discussed, how other alternatives compare and their key differences. A solution overview and demonstration is included in this session.

Are you an expert server-side software developer who needs to migrate to a browser-based environment like Oracle Application Express (APEX)? Then this presentation is for you. It will help you to "break the back" on the somewhat steep learning curve that is required when you start learning how to effectively use client-side browser tools like FireFox's Firebug and Chrome's DevTools. The presentation leads you, step by step, from a simple "hello world" web page to some real-world APEX pages---showing you along the way how to use the browser tools to inspect, test, and debug your HTML, CSS, DOM, AJAX, and JavaScript code. The presentation is designed to be a primer that will kick-start your client-side development effort.

This presentation is an introduction to the Oracle Mobile Cloud Service. Mobile applications are not just the front end, there are a lot of important capabilities that are required from the backend too. In this session we'll introduce you to Oracle's cloud based mobile offering and explain what it provides and why it is important for mobile developers.

In researching possible solutions for replacing an outdated Discoverer instance used for HR reporting, APEX became the tool of choice. However, as with any change in core technologies, a number of issues were encountered that needed to be resolved.
This presentation will examine the steps used to integrate EBS 11i and APEX 4.2, including the mapping of responsibilities used to secure data consumed by the users and how to provide menu and navigator links to launch APEX reports directly from EBS.

The use of Oracle BI Mobile is expanding rapidly. The Oracle BI Mobile Application Designer released with Oracle BI 11.1.7.1 as well as the Oracle BI Mobile application and the Mobile SDK provide a comprehensive feature set to deploy well-developed mobile applications. Learn how the award-winning General Dynamics BI Collaborative, the General Dynamics BI/EPM Center of Excellence, leverages the Oracle BI Mobile offering across General Dynamics with the security needed for aerospace and defense organizations.

The use of Oracle BI Mobile is expanding rapidly. The Oracle BI Mobile App Designer released with Oracle BI 11.1.7.1 as well as the Oracle BI Mobile application and the Mobile SDK provide a comprehensive feature set to deploy well-developed mobile applications. Learn how the award-winning General Dynamics BI Collaborative, the General Dynamics BI/EPM Center of Excellence, leverages the Oracle BI Mobile offering across General Dynamics with the security needed for aerospace and defense organizations.

The acquisition of Hyperion Solutions by Oracle brought more than just world-class Performance Management applications into its portfolio. The true value of the technology lies in the possibility to extend and integrate disparate information into a single analytic foundation. Through this foundation, organizations have learned to exploit their data to predict and achieve better results. In this session, the presenter will use live demo to teach you how the combination of Oracle Business Intelligence and Oracle Essbase is used by leading organizations to extend their current information investments well beyond classic query, dashboards or reports.

Now more than anytime during the information age, Oracle solutions are more reliable and more affordable for even the small to mid-size companies. As Oracle technology continues to advance, one trend is significantly clear; Oracle solutions are solving more business and technology challenges, and have become much easier to deploy. The success of the Oracle Cloud and the bundling of Oracle's new offerings within the ERP, CRM, HCM, BI, and EPM stack make all this possible. Learn what Oracle can do for the mid-market with quicker speed to value and simplified deployment strategies. Let us help you understand how Oracle's Fusion ERP, BI Foundation Suite, and the Oracle EPM platform can advance your business; either as an on-premise solution or as a cloud-hosted solution. The need for corporation's desire to gain quicker value and reduced total cost of ownership continues to be in high demand and now Oracle makes that easier to achieve.

Essbase ASO provides a storage architecture optimized for high speed data loads, aggregations, and query response time, when databases are well-designed. One challenge with ASO is the restrictions inherent in stored vs. dynamic hierarchies and how the tradeoffs necessary to accomplish certain financial reporting tasks result in poor performance. Other challenges with ASO continue to focus on time calculations. In this session, Gary Crisci, senior architect at GE and Oracle ACE, will demonstrate workarounds to common financial reporting challenges in ASO and walk through strategies to convert large BSO applications to ASO. The presentation will include a case study for a large financial reporting BSO cube that was converted to ASO.

Reporting analysts often spend more time creating reports, rather than analyzing the data. It's also how data is presented, which with the correct use of visualization and perception techniques can aid users' understanding. Learn techniques to create reporting that delivers actionable insight faster to users.

The presentation shows how an APEX "Image Geotagging Application" makes use of spatial and multimedia technology within the Oracle Database. Oracle Multimedia is being used to extract the location information and scale or rotate the image; Oracle Locator manages the location information. An APEX Plugin finally shows all images on a map. The presentation gives a short overview on these technologies (which are part of Standard Edition) and shows how APEX developers can efficiently integrate them into their applications.

Data Relationship Governance (DRG) is one of the newest modules in Oracle Hyperion Data Relationship Management (DRM). DRG is a tool that allows you to do workflow in order to get new accounts and cost centers in DRM. It uses a web interface that allows users to submit a request to make additions, deletions, or changes to the current structures in DRM. DRG is new leading-edge technology, and even though it doesn't yet have all the bells and whistles there are many good reasons to work with it now. In this session, Steve Davis, TopDown Consulting solutions architect and DRM expert, will discuss the pluses, minuses, what issues we foresee, bottlenecks, etc. with DRG. He'll provide examples on how you can take advantage of DRG today even though it's a new tool. He'll also provide tips, tricks and best practices for working collaboratively with DRG.

Creating APEX pages that are also understandable for other APEX developers can be really tricky. The complexity of a page often determines the implementation technique. One project can even have multiple implementation approaches.

You might have noticed that ASO applications are listed in Calc Manager, and this begs a number of questions:
1. What can Calc Manager do for your ASO application?
2. What can't Calc Manager do for your ASO application?
3. What are the benefits of Calc Manager for an ASO database?
4. What are the best practices for using Calc Manager with an Essbase cube?
In this session, Paul Hoch, principal architect for TopDown Consulting, and Ludovic De Paz, senior consultant for TopDown Consulting, will answer these questions and more. The session will include real-life examples and case studies of successful implementations, as well as limits, gotchas, and workarounds.

Whether your company is already using Hyperion Planning or Essbase for budgets and forecasts, or is still in the design phases, it is never a bad time to think about the relationships between P&L, balance sheet, and cash-flow accounts. In this session, walk through a comprehensive example of how the use of roll-forwards and movements in the outline can simplify an otherwise complex process to calculate EndBal=BegBal+Mvmts+CTA. It's currency translation adjustment (CTA) made easy.

DBAs working on Agile projects using continuous integration techniques with developers using object relational mappers (ORMs) often have challenges with schema evolution. In this presentation, DBAs will learn tips and techniques for making evolutionary database schema changes while minimizing impacts on application developers.

Your organization wants to see Oracle Financials in Multi-Dimensions. After considering options, the organization has finalized EPMA Planning as the tool of choice. However, you have dimensions with a very large number of members. In fact, some dimensions may have more than 50,000 members. To add to the complexity, the members need to be reordered. Knowing that EPM Planning applications can suffer poor performance when resorting is required during metadata updates on large dimensions, should you opt to use Classic Planning instead of EPMA, or should you try one of the following novel approaches? Also, how do you handle incremental updates to a manually maintained EPMA dimension so there are no record kick-outs during data loads? We will contrast the different approaches with pros and cons of each approach. Please join this session and discover for yourself how you could utilize EPMA more effectively for metadata and data management and empower yourself for future challenges.

Two use cases - one with 'Generation' build and the other with 'Parent-Child' build, will show how identical results can be achieved with either build. At the end of the session, you will be ready to tackle any Essbase Studio implementation with confidence.

Oracle's ADF Business Component Application Module pooling parameters are one of the least understood parts of ADF applications, but they are key to making a scalable application. This presentation will undertake a deep dive for developers on how to configure the parameters and what the impact of setting them is, all with the goal of building successful ADF applications.

Nowadays, APIs are all the rage. Some even say that SOA is dead - a relic of a previous IT age. Yes, the rich web and mobile applications of tomorrow need web services. But why would anybody bother with a service bus or a BPM engine when HTTP and REST are all you need in the eyes of many?
In this session, you will discover how SOA principles are still relevant for the architectures of today, and how they can be applied to REST web service APIs. In addition, you will see how the various components of Fusion Middleware, such as Oracle Service Bus, Oracle API Gateway, Oracle SOA Suite and Oracle Mobile Suite, have a role to play in a modern API infrastructure.

The longest journey starts with one step, but sometimes it's difficult to know in which direction. This session is an accelerated guide as to WHY ADF might be important to you, WHAT it is, and HOW you develop using it. This is the definitive guide (based on show-and-tell and not just PowerPoint) to getting the right knowledge to make an informed decision on Oracle ADF.

Everyone in the Enterprise has an impact on SG&A expenses. From your salary to the office supplies you use to the travel you take on behalf of the company, it's everyone's job to help maintain and control these expenses. This session gives a background on SG&A performance management and demonstrates approaches to managing the impact that SG&A expenses can have on the organization. To that end, it will be especially useful for anyone in Finance, IT, and business management --- at all functions and layers of the organization. Using Oracle EPM tools and EPM management processes, you will leave with new ideas for optimizing SG&A expense performance in your organization.

Learn about the project approach and implementation experiences for an ADF Mobile iPad application supporting remote inspections for utility company Power South Energy. The application includes the use of GPS location data and synchronization process between SQLite and Oracle DB.

Learn about the Project Planning, Implementation/Migration Strategy and Quality Control during a large scale Oracle Forms migration project.
Planning a migration project includes several challenges: Preparation of a reliable effort estimation, Decision on an Implementation/migration strategy and prioritization, Staffing Training of the project team and the Quality Assurance/Monitoring along the project phases. The presentations illustrates all these challenges based on real project examples. In addition alternatives for Oracle Forms Modernization scenarios will be discussed with the focus on Hybrid Migration strategies where Oracle Forms and ADF technology are both accepted as an integrated architectural element. For most organizations a hybrid Migration approach significantly reduces the project risks by allowing a phased technology transition.

Lifecycle Management is one of the most versatile and least understood features of EPM. It is often seen as only a tool to move some components from one environment to another. LCM, however, has many more uses in today's EPM implementations. This session will discuss the features of LCM and how they relate to different real-world scenarios such as backup, disaster recovery, and bulk loading. Throughout the presentation, live examples will be given of different use cases to demonstrate the many features of LCM. Additionally, tips and tricks will be discussed on how to take advantage of the power of this great tool.

Have you ever tried to find a logic error in PL/SQL? If so, you know how frustrating it can be! Using the PL/SQL debugger in SQL Developer can make your life so much easier. You can execute your code one line at a time, skip lines of code, step into called procedures, set breakpoints, see variable values, and change variable values during runtime. Proficiency using the debugger eliminates the need for debugging statements, which must be removed before moving the code to production. This session will cover the privileges and setup required for debugging, as well as a complete demo of debugging code.

This presentation will examine how to leverage the features of Oracle XML in Oracle Database 12c to make it easy to develop applications that go beyond what is possible with the traditional relational data model.
We will discuss the problems of dealing with variable data models and outline a solution that provides extreme flexibility while still providing full relational access and performance. We will also address the challenge of exchanging information between different system, and see how XML and XML DB makes it possible to exchange large volumes of information in a reasonable efficient manner.
We will also examine how XMLDB and Oracle's Database Native Web Services make it possible to easily integrate Oracle Database 12c and the large volumes of application logic tied up in PL/SQL code into today's SOA environments. We will also take a brief look at how XML, HTTP and DBNWS provide a new paradigm for creating applications that run directly out of the database.
Finally we will look at how the Oracle XML DB repository makes it easy to integrate documents into your applications, providing a secure, easy to use platform that provides basic content management services for all types of document.

This presentation will detail the proposed SQL/JSON standard that will allow relational databases to store and query data represented in the JSON format. Explore how to store JSON in the RDBMS and how to query JSON using proposed new extensions to the SQL standard.

Learn how Oracle Business Intelligence provides capabilities to black box itself. This may be useful if you want to embed the functionality of Oracle BI within your own product via silent installation, programmatic manipulation of the Oracle BI objects, and administration using the Systems Management API.

Continuous Integration should be a goal for every development organization and every project. Ongoing testing results in fewer bugs, faster development, and higher quality, which combine to make happier users--and project managers. CI requires multiple tools working together to be effective. This session will walk you through the installation and basic configuration of a common set of CI tools.

During this presentation, we will use PL/SQL Developer to change a package and APEX to change an application. We'll check the package into Subversion and, figuratively, go home for the evening. Then we'll see Jenkins deploy a new database instance, build an application installation package, deploy it to the new database instance, and check for any errors. Selenium will run some UI tests. Finally, we'll see what reports await us in the morning.

Exalytics is the future of in-memory, virtually real-time analytics. Its contains optimized versions of Essbase, OBIEE, TimesTen all running in-memory on a really powerful server. You'll learn how it will speed up basically everything you want to do in the world of BI: loading, calculating, querying, and more. Learn how WellPoint went from top-line AIX servers to awesome performance, their experiences from the data center to Essbase performance, performance benchmarks, and lessons regarding performance tuning.

What is Predictive Planning, and how does this feature work? When should it be used? Is it easier or more difficult to use than a custom solution? At this session, explore various forecasting techniques and see a full demonstration of the setup, options, and use of this Hyperion Planning feature.

In the criminal justice system, all Hyperion Planning designs are innocent until proven guilty, either by confession, plea bargain, or trial by jury. This is one of those trials. Come be a member of the jury, or even a surprise witness. Listen to opening remarks from two senior Hyperion Planning architects who will compare and contrast the "traditional" approach to Hyperion Planning design vs. unconventional design alternatives. This trial will cover opposing approaches to topics such as dense/sparse settings, driver-based calculations, and form design. Witnesses will be called from the audience to provide key testimony that may or may not support the case. You, the jury, will provide the verdict in this fast-paced trial of traditional Hyperion Planning design.

The journey to private cloud is full of promise...and peril. Any hero brave enough to accept the challenge must see this film and learn the secrets to building a successful cloud. Cloud Odyssey: A Hero's Quest follows Cyrus Agarwal, chief engineer of the Stratus star cruiser, as he leads humanity's first interstellar trek. Destination: the cloud planet. As in your journey to private cloud, our hero will encounter obstacles, find allies, and learn from a trusted mentor. Join Cyrus and the crew of the Stratus for this unique, sci-fi movie experience while learning key success factors for your own journey to cloud.

This session takes a journey from the surface of the declarative approach into the deep of real-life hands-on programming. Hear how to create and manipulate Oracle Application Development Framework (Oracle ADF) objects at runtime programmatically. See how to define a complete business components model on the fly, and learn the advanced techniques of dynamic creation of objects such as entities, view objects, and lists of values. Learn how to populate view objects programmatically, how to create and apply view criteria at runtime, how to work with multiple row sets, and how to use aggregation functions. See how to create dynamic tree binding definitions and dynamic tables. Learn how to manipulate train task flows programmatically at runtime.

This session takes a trip across the ocean of Oracle Application Development Framework (Oracle ADF). Hear how to avoid the most common pitfalls developing a real-world Oracle ADF application. Live examples reveal hidden rocks across business service, controller, and view layers of the application. Learn the proper way to design master-detail entities and entity associations. Discover the traps of list of values and see how to escape performance issues related to view objects and view accessors. Hear how to avoid the rocks defining managed bean scopes in Oracle ADF task flows, and learn the ropes of handling exceptions capably. Explore how to bypass hidden reefs working with Oracle ADF Faces components.

NoSQL and Big Data have a lot of momentum, and even Oracle Corporation has joined the fray with its own NoSQL offering and Hadoop connectors. The NoSQL and Big Data camps claim relational technology cannot handle the performance, scalability, and availability demands of a wired world. In this session, Iggy demystifies NoSQL and Big Data and surveys the new product landscape. Iggy then explains that the deficiencies of relational technology are actually a result of deliberate choices made by the relational movement in its early years. The relational camp needs to revisit these choices if it wants to compete with NoSQL and Big Data technologies in the area of performance, scalability, and availability.
Iggy will:
* Demystify NoSQL using the example of Amazon Dynamo
* Compare the novel approach of Amazon with the conventional approach of eBay
* Survey the NoSQL and Big Data landscape, including the Oracle NoSQL solution
* Explain what makes relational technology so sacred
* Identify the missteps of the relational camp

NoSQL and Big Data have a lot of momentum, and even Oracle Corporation has joined the fray with its own NoSQL offering and Hadoop connectors. The NoSQL and Big Data camps claim relational technology cannot handle the performance, scalability, and availability demands of a wired world. In this session, Iggy demystifies NoSQL and Big Data and surveys the new product landscape. Iggy then explains that the deficiencies of relational technology are actually a result of deliberate choices made by the relational movement in its early years. The relational camp needs to revisit these choices if it wants to compete with NoSQL and Big Data technologies in the area of performance, scalability, and availability.
Iggy will:
* Demystify NoSQL using the example of Amazon Dynamo
* Compare the novel approach of Amazon with the conventional approach of eBay
* Survey the NoSQL and Big Data landscape, including the Oracle NoSQL solution
* Explain what makes relational technology so sacred
* Identify the missteps of the relational camp

Using a combination of Essbase, SQL Server, IBM DB2, and Dodeca, The Kroger Co. manages all of its financial analysis, forecasting, and budgeting. This session will describe how these processes work, starting with the high-level forecasting process and progressing through the massive account-level budgeting process including discussions of the value that drill-through to journal detail brings to our flux analysis. The system, which is automated with load rules and report scripts, makes the process simple and easy to follow to manage positive employee turnover. Learn how Kroger manages over 500 Essbase cubes and thousands of users in our fast-changing environment with a small headcount. No need to be technical to understand this one as this session was written by accountants for accountants!

The Function Result Cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data that is requested repeatedly by database sessions. This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on 11.1 or higher should be taking advantage of this feature. Learn all about it!

The worlds, baldest, oldest PL/SQL experts (Bryn Llewellyn and Steven Feuerstein) talk about some of the most exciting aspects of developing applications with PL/SQL, and take questions from our audience.

In this presentation we will cover various infrastructure topics, utilities and diagnostic tools in EPM 11.1.2.x that will help make your job easier and resolve problems quicker.
* Monitoring your EPM environment with Oracle Enterprise Manager
* Ziplogs -- Send all your logs to Oracle Support in a few easy steps
* ResetConfigTask -- revert a product back to unconfirmed, very helpful when a task fails and you want to run it again
* Log Analysis Utility -- This tool compiles all logs and let's your search for specific errors & date/time range, very handy when you don't know which log to look at
* Maintenance -- Housekeeping, common logs to rotate/archive: HFM Event log, HFM odl log, Essbase.log, app.log. There is an essbase.cfg setting that will autorotate for you without stopping. HFM logging.xml setting to rotate on max size.
* Starter logs -- Analyze startup time and confirm PASS/FAIL. Evaluate NUM_THREADS for potentially faster startup.
* Discuss PSUs and frequency - Latest Patch Set Updates for EPM Products (1400559.1)
* Virtualization -- when it works and when it doesn't

This presentation is a primer for the main place that ADF developers write Java code -- managed beans. Attendees will learn about the main use cases for managed beans, some tips for making it easier, and some warnings about how not to use them. Some sample code will be provided, including some of the most common lines of code that are used in a managed bean.

Hyperion Strategic Finance (HSF) is an excellent business modeling application that can help your organization with its long-range planning for a more complete financial picture. This session will cover the basics of implementing HSF, what's new in 11.1.2 (and how the exciting enhancements will benefit you). After this session, you will have an understanding of what exactly HSF is, prepare your strategic plan or forecast with advanced business modeling, and learn how you can benefit from all HSF has to offer. BONUS #1: For Essbase fans, we'll be covering at the end of the session how to use your Essbase awesomeness to analyze all your HSF data. BONUS #2: We'll all get to learn what a Monte Carlo simulation is and why you should actually care.

Oracle Data Integrator (ODI) 12c is the major release that deeply changes the way integration jobs are developed. Keeping its strengths but getting closer to Oracle Warehouse Builder (OWB), it's more than ever the best-of-breed data-integration tool. How do you develop the new ODI 12c mappings? Is it still possible to use the former paradigm? What is a reusable mapping? What is the debugger and how do you use it efficiently to reduce testing time? What are the improvements in terms of parallelism and how the log writing overhead is reduced? How do you have several technical implementations using the same business logic? Is there a way to migrate from OWB? All your questions will be answered and some hidden new features will be exposed to the light. After this session, you will be able to do the jump to this new version.

The new Oracle Data Integrator (ODI) 12c release is an exciting combination of the best concepts of the old Oracle Data Integrator and Oracle Warehouse Builder product lines. But why is that good for large Business Intelligence implementations? Well, Business Intelligence projects do tend to involve not only multiple sources but also often use multiple targets for aggregate computation and storage, e.g. Essbase, TimesTen, Oracle Database, etc. The target technology used might also change over time. Oracle BI does offer Aggregate Builder and, on Exalytics, Summary Advisor as features that generate scripts for aggregate computation. However, especially in larger organizations, complex environments, and for maintenance and audit reasons, the use of DI tools is often preferred or even mandatory. And here the unique feature set of ODI 12c makes the difference. Most important in this context are ODI 12c's separation of logical business logic design from technical implementation, support of heterogeneous technical landscapes, and new code-generation capabilities.
This presentation will explain and demonstrate the scenario, features, and benefits of ODI 12c vital to the BI realm. Live demonstrations using ODI 12c for implementing aggregate computation targeting different environments (Oracle Database, TimesTen, MySQL) will be given. This way, attendees will learn why ODI 12c is the best DI product for BI projects and how its major features can be used in typically fast-changing BI environments. Thus, they will be enabled to achieve better BI performance and faster customer requirement satisfaction, with less effort, while not sacrificing solution quality.

Do you have a complex Hyperion environment that could benefit from a team of skilled Hyperion-specific resources to manage and maintain your applications? Join UPenn and MindStream Analytics to learn about how the technical and functional expertise of a dedicated Managed Services helpdesk increases application efficiency. MindStream has found that measuring specific KPIs and understanding how the environment is used, stabilizes, and decreases aggregation times increasing the availability of real-time budget and forecast values for the business. This proactive approach prevents system issues from affecting the end users' day-to-day activities.

Dynamic actions provide the ability to build interactivity into your applications without having to learn a lot of JavaScript. However, to the uninitiated, dynamic actions can be daunting. This session will introduce you to dynamic actions from the most basic to some more intermediate examples, and will give you the right grounding to continue on your own.

Design Patterns gained popularity in the early 90s when the Gang of Four published their seminal work, "Design Patterns: Elements of Reusable Object-Oriented Software." More generically, a design pattern is a general reusable solution to a commonly occurring problem within a given context in software design.
This presentation will examine the concept as it relates to APEX and introduce the attendee to a number of design patterns for common APEX problems. Some might surprise you.

Kscope puts more Essbase expertize into the same spot as any other event in the world. Rapid-fire panel discussions are always fun and well-attended, but don't allow much time for divergent views on a problem or considered answers.
This year we will ask attendees to submit questions throughout the week, with the most popular and interesting put to a panel of Essbase thought leaders. The panelists will have time to discuss (or argue) and present more detailed responses than might be possible in 'live' sessions or presentation Q&As.
The stellar panel line-up will be:
Carol Crider (Senior Technical Support Specialist, Oracle)
Steve Liebermensch (Essbase Product Manager, Oracle)
Mark Rittman (Oracle Ace Director, Rittman-Mead)
Glenn Schwartzberg (Oracle Ace Director, InterRel)
Tim Tow (Oracle Ace Director, Applied OLAP)
Sarah Zumbrum (Oracle Ace Associate, Finit Solutions)
Questions can be submitted via email to EssbaseDeepDive@gmail.com, by tweeting with hashtag #EssbaseDeepDive, or directly to @CubeCoderDotCom. Anything and everything Essbase-related is fair game!

In some Hyperion Planning projects, security becomes so complex that it takes more than just putting some security groups on the high-level members of the dimensions. Global companies often have the necessity to create multiple planning applications to meet the diverse regions of the globe. However, what happens when the business requires a single application with a single plan type that contains cost center from different regions around the entity hierarchy? Moreover, that data is restricted according to the region's security group using only one attribute dimension. Furthermore, each user can see aggregated values correctly for your region only.
This case study will show how to generate and maintain leaf-level member security settings based on physical geography attribute dimension on one of Dell's global Planning applications using only ODI and planning application metadata repository information.

Over the years, I developed a certain way of working. In this presentation, I want to share the things I do in almost any project, including creating a global page, reusing codes for the back-end database, reusable code for shuttles, using the advisor, and packaging the application.

This presentation will introduce Hadoop to Oracle developers and DBAs focusing on the technical aspects as well as on the use cases for Hadoop and reasons it became so popular. The attendees will walk away with a solid understanding of Hadoop principles and practical information how to get started with Hadoop.

Designing tables for slowly changing dimensions (SCDs) is one of the most difficult tasks in a database supporting BI/DW applications. Dimensions are not supposed to be large, but SCDs can grow to hundreds of millions of rows, larger than many fact tables. This can make them a performance nightmare.

A good data model, done right the first time, can save you time and money. We have all seen the charts on the increasing cost of finding a mistake/bug/error late in a software development cycle. Would you like to reduce, or even eliminate, your risk of finding one of those errors late in the game? Of course you would! Who wouldn't? Nobody plans to miss a requirement or make a bad design decision (well, nobody sane, anyway). No modeler worth his or her salt wants to leave a model incomplete or incorrect. So what can you do to minimize the risk?
In this talk, get a best-practice approach to developing your data models that Kent has been using for over 15 years. It is a simple, repeatable process for reviewing your models. It is one that even a nonmodeler could follow. Kent will share his checklist of what to look for and what to ask the modeler (or yourself) to make sure you get the best possible model. As a bonus, Kent will share how he uses SQL Developer Data Modeler to collect the information and report it.

Oracle SQL Developer Data Modeler (SDDM) has been around for a few years now and is up to version 4.x. It really is an industrial-strength data modeling tool that can be used for any data-modeling task you need to tackle. Over the years, Kent has found quite a few features and utilities in the tool he relies on to make him more efficient (and agile) in developing my models. This presentation will demonstrate at least five of these features, tips, and tricks. He will walk through things such as modifying the delivered reporting templates, how to create and apply object-naming templates, how to use a table template and transformation script to add audit columns to every table, and using the new meta data export tool and several other cool things you might not know are there. Because there will likely be patches and new releases before the conference, there is a good chance there will be some new things to show as well. This might be a bit of a whirlwind demo, so get SDDM installed on your device and bring it to the session so you can follow along.

This presentation will explore one of the major bottlenecks in database application development: the movement of data from production databases to development though QA, UAT, and test including building and managing development and QA environments. You will export what the impact is, how to solve these bottlenecks, and metrics to track to validate the solution.

How would it impact your company to create as many database copies as fast as you want with no storage impact? It would reduce storage excesses, free up DBAs from route work, allowing them to concentrate on innovation, and accelerate development and company productivity. Find out how instance-thin database clones are available now in the industry.

Have you ever needed to write a complex Essbase member formula in an ASO cube? Have you struggled with getting the MDX right for the formula to work? This session will go over the types of MDX formulas available, examine some of the more commonly used MDX formulas, and discuss when each one should or could be used. A framework will be provided on how to methodically approach building a MDX member formula to ensure you get accurate results and allow you to build a super-complex (and hopefully efficient) member formula to be used in your ASO database. The same framework can even be used to help troubleshoot when a formula breaks or when the logic of a complex formula needs to be adjusted. Best practices will also be shared to start you on your way to mastering MDX.

Analytic functions can often help you, using data across rows in ways to allow you to solve tasks that otherwise might have called for slowly using the data one row at a time procedurally. This presentation will show several such cases of using analytic functions to avoid slow procedural data handling. All cases are from actual production system and will hopefully serve as inspiration.

There are many ways you can access external data from within the Oracle database. This presentation will show different methods using HTTP or FTP protocol getting raw data, files, or XML via proprietary calls or web-service calls (either REST or SOAP). Topics include HttpUriType, UTL_HTTP, UTL_DBWS, APEX_WEB_SERVICE API, and more.

Weep for our northern BI brother Kevin McGinley. Bitterly cold and inhumane winters. No grits or mama-approved biscuits. And possibly worst of all, suspect college football. It was a clear and balmy Georgia night in downtown Atlanta when a gaggle of SEC blowhards led by none other than Rittman Mead's Stewart Bryson (OK, myself included, admittedly) ganged up on poor Kevin to let him have it when he made the mistake of comparing his beloved Big 10 conference to our SEC religion.
And then just to add insult to injury, I later decided to pit Kevin's first true love (OBIEE, of course) against him to settle the debate, once and for all.

With the release of APEX 4.2, we can develop applications for mobile devices like we've never done before. In APEX 5.0, mobile development is taken to the next level. In this session, you will learn (and see) how to develop a mobile application that doesn't only look awesome but is also full of functionality. Forms, reports, transitions, etc.: After this session, you can build everything you've seen in a native application yourself.

According to Gartner, in 2015 50% of all mobile applications will be hybrid. So it is the right time to jump on the bandwagon and start building hybrid mobile applications yourself. And you don't need to know Java, Object C, C++ or other "strange" languages. Using Oracle Application Express and PhoneGap/Cordova, you can create awesome-looking and functioning near-to-native applications. In this session, you will learn how to do it and what it takes. And of course, the session will contain a lot of demos.

Want a tool that can help you automate your Essbase processes and other Hyperion administrative tasks? And, you can do it without going back to college for a programming degree? If so, come learn about a great free tool that you already have installed: Windows PowerShell. This session will start with a high-level overview of PowerShell, covering the basics of the technology and its functionality. Walk through real-world examples showing how Hyperion administrators can use PowerShell to manipulate metadata faster and easier, export datasets faster with more control over format, and maintain a modular library of functions that can be reused to develop batches more quickly and easily. Come find out what that funky blue button in Windows does and why it's the best free Windows built-in tool that you're not using.

When thinking about rules, are you an administrator filled with a mortal dread akin to the impending zombie apocalypse? JimTheRulesGuy will take you on a journey to understanding the rules in your system. Prepare without horror for the day when you actually need to shed light on the dark crypt of your rules.

Would you rather face a charging horde of stampeding zombies than write override rules? Let JimTheRulesGuy show you how to take the drama out of getting translated data to be whatever you need it to be.

The new 11.1.2.3 Fusion edition of Oracle EPM brings many new features, functionally, and options for deployment. Whether it is Oracle Cloud, SaaS, Exalytics, or in-house systems, Oracle ACE director Eric Helmer walks though best practices and considerations to make your journey to Fusion painless by choosing the right deployment scenario for you.

Data Modeler is known to be an amazing tool for database design. But are there any other use cases for the tool? In this presentation, find out how to use the tool for database design and eight other use cases.

When it comes to EPM planning, companies have traditionally taken a "more is better" approach regarding the level of detail included. Operating under the guiding principle that you can't manage what you can't measure has caused departments to get too mired in the details, leading to time-consuming planning cycles and a history of overspending. Tighter budgets and competition between departments for budget allocation has only exacerbated the inclusion of every possible line-item in planning. Driver-based planning is a new approach to EPM planning and focuses only on the actionable drivers of the business, allowing the rest to "just happen." This allows employees to be more nimble, react to market conditions more quickly, and make decisions about factors that are truly under their control. In this session, attendees will learn how to implement a driver-based planning solution and gain executive support for this new way of planning.

"Wouldn't it be nice if I could find 'the one'?" Haven't we all said this at one time or another? Having been struck off his PowerShell horse on the way back from ODTUG by an Aultman bolt of lightning, a certain Essbase developer went into seclusion. There, he reflected on what had just happened, saw the light, rejected his automating ways, and set out on a new mission. Against all kinds of opposition and logistical roadblocks, he championed the conversion of a large collection of automation scripts from a Windows platform to a Linux platform, from CMD, esscmd, MaxL, VBScript, and PowerShell to Groovy. This is his story.
Properly crediting, summarizing, and building on the work of others, the presentation documents the script conversion process, highlighting difficulties, constructing patterns, from simple to complex, covering not only interaction with Essbase through the Essbase JAPI, and using Groovy to complete data-manipulation tasks outside of Essbase, some essential to application maintenance, some just convenient. Sufficient examples are provided to facilitate step-by-step learning and replication.

Changing dimensions is a well-known challenge in dimensional data modeling. Oracle Hyperion Planning, and its underlying dimensional database and OLAP engine (Essbase), are not immune to it. A relatively new Essbase feature called "varying attributes" is Oracle's response to this challenge. It is a powerful feature, but this presentation is concerned with requirements that go beyond capabilities. The terms "Fast-Ghanging" and "Hyperion Planning" included in the title are meant to eliminate the possibility of using varying attributes for two primary reasons: They do not support continually changing user-driven attribute assignments, and they are not supported by Hyperion Planning. Several solutions, one of them implemented at an S&P 500 company, are presented and discussed in sufficient detail to facilitate replication. The solutions are all based on dynamically calculated dimension members designed to convert a single dimension into multiple dimensions based on data values supplied by users. These values represent what would have otherwise been members of extra dimensions. The solution is similar, from a computational point of view, both to the dynamic allocation of global values and to the implementation of varying attribute dimensions, but it offers, in addition, the possibility of allowing users to interactively extend or modify the dimensionality of selected data points. Probably most importantly, the heart of the solution is not dependent on a "still-not-available" product feature; it could be implemented, in principle, on any platform capable of modeling dimensionality.

All businesses experience change. It is crucial for finance teams to be able to reflect those changes within their applications. The functionality of varying attributes takes the ability to group and analyze members of dimensions to a new level. Now, instead of simply assigning static attributes to dimension members, Essbase Studio users can create varying attributes that change along with an independent dimension. This session is sure to give you a new outlook on member attributes and the benefits they provide.

After passing all functional tests, many web applications fail under the regular load conditions. Just 100 active users may be sufficient to cause severe errors and a decline in performance. In this session, load testing of ADF applications with the Oracle Application Testing Suite and Apache JMeter will be discussed and demonstrated. With these tools, you have an analysis-instrument to do performance analysis and regression analysis after new patches/releases. A proper managed load test also gives insight in the effects configuration parameters. The speaker will share best test practices to perform load tests and offer typical solutions for creating an efficient, scalable ADF application.

iOS, Android, RIM, native, hybrid, web-based, ADF Mobile, device-native, HTML5, AMX, PhoneGap, Cordova, iTunes, GooglePlay, XCode: If you're looking into mobile application development, this is just some of the vocabulary you're probably trying to get your head around. The different mobile developer programs can seem daunting and vary in complexity; for instance, with iOS you need to understand and consider developer licenses, developer certificates, profiles, device registration, and work within the iOS portal. What about your teams and the mobile paradigm? Do you need new skills, processes, IT procedures, and even hardware to be successful in mobile? Are there best practices and design patterns to follow? How and where do you test and distribute your mobile applications? Are you ready for rolling updates of iOS/Android requiring instant fixes to your app? Join this session for an introduction to making the most of mobile. Learn how to quick-start your mobile development. And the good news? It's not as daunting as you think. If you're an Application Development Framework (ADF) or Fusion developer, you are already a mobile developer. If not, come and see how you can be!

Learn how to add data visualization to your web applications. Use charts, gauges, drill-down visualization, and more to show your data in new ways. In this session, you'll see how Oracle ADF Face's data-visualization tools make those tasks simple with minimal to no coding needed.

Learn how Oracle's mobile application framework simplifies the task of building mobile applications that run on both iOS and Android devices. See how to leverage device capabilities, build rich UIs, and add business logic. No previous experience required.

What are the security options available to you when developing an ADF Mobile app? What security do you need in your app? Do you need authentication of the user, to use roles and privileges to restrict access to features? Does your app call secured web services? Do you need to be able to update endpoints 'on the fly' at runtime? These and more security concepts will be discussed, explained and demoed in this session.

This talk is an overview of the OWASP Top 10 security vulnerabilities common to all web applications, regardless of platform. It will then demonstrate the appropriate countermeasures available in ADF to better secure your application. You need not be a security guru to attend this session; ADF developers of all skill levels are welcome.

Oracle Essbase has a great reputation for being a powerful financial analytics tool (and rightfully so). As a result of its multidimensional nature and reporting flexibility, Essbase has built a strong base of advocates in departments beyond just finance. A global investment management firm is a longtime champion of Essbase. One of the firm's core values is cultivating a diverse workforce. Over the past few years, managers received reports that summarized associate headcount by ethnicity, gender and other attributes. These reports were sourced using enormous Excel pivot tables. The pivot tables were extremely cumbersome to maintain and quite frequently contained links that had the potential to break as managers requested additional attributes on their reports.
Recognizing the power of Essbase with the firm's multiple finance applications, the firm decided to further leverage its investment and make the human-resources department a champion of Essbase as well. By storing key diversity metrics in Essbase ASO applications, Human Resources was able to quickly transform its Excel-based processes and reports to create various diversity reports using Oracle Essbase. No longer was a request by a manager for different report views such a daunting task. Join us to learn how an innovative approach to using Essbase could benefit core data collection and reporting processes outside the realm of finance in your organization.

By now, you have probably heard that Oracle Data Integrator (ODI) is a great tool for moving data within your architecture. It provides a standardized, best practice, and robust architecture that can replace existing data movement processes. But have you heard how other organizations are using this unique next-generation Extract Load and Transform (ETL) technology to improve performance and reduce data integration costs?

If you need to integrate Essbase with both Oracle and third-party applications, this session will provide an excellent overview of all the programmatic ways of retrieving your Essbase data and metadata.

Can Application Express scale? Can Application Express development be fast? This session will focus on a wide variety of topics, from creating a secure and efficient development and production environment to focusing on measures to develop, diagnose, tune, and manage an enormously scalable Application Express environment.

What if the IT/business would like to review the PDF files before they reach the end users? What if IT would like to reduce the overhead on its Exchange servers?
This session deals with BatchDriver API and how it can be efficiently used to publish PDF reports (any documents) in Workspace along with required level of security.
Material includes:
* Overview of control statements
* How accessor control and data control statements can be used in BatchDriver API to upload documents into Workspace
* How category control statements can be used to change permissions/properties of Workspace objects
* Overview of useful Workspace APIs

Need a scripting tool to work with your ORACLE databases? In this presentation, we will look at Python and how it can be used to script basic Oracle monitoring, management, and administration tasks. Come to this presentation to learn why you should definitely have Python in your scripting arsenal.

"Pagination" (of which Top-N is a special case) is a very common SQL query technique. It deals with extracting a limited number of "most interesting" records from a potentially large qualifying result set. While pagination requests seem simple (and Oracle 12c made them even simpler), executing them efficiently requires some groundwork in both schema design and query coding.
In this presentation, take a look at a few real-life pagination examples and use several techniques (i.e. "perfect indexes" and "restart tokens") to make them execute efficiently. There will also be discussion of a few pitfalls and how to avoid them.

In "Top Technology Trends for 2013," The Gartner Group identified Business Analytics related tools and technology in three of their top ten areas of corporate focus. Over the last several years, Business Intelligence applications and technologies have consistently made this list as well. But what does "Analytics" mean to a finance function typically focused on driving down transactional costs, managing risk, and satisfying a myriad of external statutory, regulatory, and compliance needs? In this presentation intended for all audience levels, you will learn how several Ranzal clients have maximized the value of their EPM investments through the deployment of analytical solutions that go beyond traditional EPM and help to bridge the gap between operational activities and financial outcomes, ultimately transforming finance into a strategic business partner that helps to enable organizational growth.
Specific presentation agenda topics covered in this session will include the following:
- Insight into the major drivers for Business Analytics
- An overview of key enabling EPM/BI software, including: Hyperion Profitability and Cost Management (HPCM), Hyperion Planning, DRM, FDMEE, and Oracle BI Foundation Suite (OBIEE/Essbase)
- Multiple client case studies focused on phased EPM/BI expansion and convergence
- An overview of Edgewater Ranzal's "Start Anywhere" EPM/BI Convergence Roadmap
- Key system features and implementation techniques to achieve success
Time for Q&A will be provided at the end.

Enterprise applications must provide reasonable performance on a large scale. One of the most important ideas in application development is to build instrumentation into applications to enable performance tracking and tuning. Oracle ADF provides multiple mechanisms for instrumenting and tracking performance. This session will show different options for Oracle ADF instrumentation and how they might be used to provide better application performance. Example code will illustrate how effective instrumentation can be in identifying and solving performance issues.

Attendees are introduced to the new and improved features of Oracle 12c 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: identity columns, improved sequences, invisible columns, improved defaults, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements.

Deploying a Java EE web application consists of wrapping all application files into a single Java archive file (the EAR, or Enterprise ARchive) and then copying this file to the application server. The Oracle WebLogic Server (WLS) is a standard Java EE runtime process to which you deploy Java-based applications for use in a web runtime environment.
This hands-on session consists of an introductory presentation that explains the process of deploying an ADF application to Oracle WebLogic Server. It outlines JDeveloper utilities and profiles that help you create an EAR file with all required libraries. It also describes how to deploy applications using both JDeveloper and WLS console. Attendees will then have a chance to obtain experience with these techniques in a hands-on lab.

This presentation explores how to implement a layout design using Application Development Framework Faces Rich Client (ADF Faces RC) components. It explains and demonstrates different categories of ADF Faces layout components and their properties that allow the developer to declaratively create a specific layout. It also explains and demonstrates nesting layout components and how this technique could be used to modify the standard tab order. The session ends with some advice about how to approach implementation of a layout design, including using resources such as cheat sheets, component guides, and component documentation. The principles in this session apply to web and mobile development.

Co-presenter(s): Cheryl Kwiatkowski, California State University System

When:
Jun 25, 2014, Session 16, 4:30 pm - 5:30 pm

Topic: Business Intelligence - Subtopic: BI Applications

This session will review the full lifecycle implementation of OBIA in the ODI (E-LT)-based version of analytics, including the lessons learned in making the decision to select ODI, project planning, architecture, installation, requirements gathering, fit/gap analysis, configuration, testing, training, and support.

This session will focus on how to correct many common issues developers struggle with in APEX Responsive Templates:
* Laying out form elements side by side
* Creating responsive tables
* Dealing with responsive menus
* How to write custom media queries when necessary
* Why a responsive template might blow up when an extra container in the page template is added

A wristband that can unlock and start your car based on a unique cardiac rhythm. Head-mounted displays that layer digital information over reality. Computers, robots, drones, and more controlled with a wave of the hand or a flick of the wrist. Everyday objects connected to the Internet that convey information in an ambient way. Fully functional computers on tiny sticks. Invisible fences that control the flow of data.
Science fiction isn't fiction anymore, and people aren't tied to PCs and desks. Everything is a device, everything is connected, everything is smart, and everything is an experience.
Come see the R&D work of Oracle's Applications User Experience team and explore new devices, trends, and platforms.

This session is a comprehensive lesson on Essbase partitioning. Perfect for the beginner or intermediate Essbase administrator, it will cover partitioning basics and step-by-step instructions for creating both simple and complex partitions.

BSO Essbase was a revolution on its release in 1992. No other OLAP database was as fast, flexible, or easy to develop. ASO Essbase was a brilliant trick; it looked like BSO Essbase to administrators and acted like BSO Essbase to users, but it was completely different under the skin in every manner imaginable to allow ASO Essbase applications to scale far beyond the limits of BSO Essbase. But those very same properties came with a cost in terms of language flexibility, procedural calculations, and application design. Could Oracle manage to combine the best of both engines into a unified kernel? The answer is Hybrid Essbase. Join this never-before-revealed review of this fascinating new engine, its amazing performance capabilities, and how Hybrid compares to BSO and ASO.
Included will be demonstrations of real Essbase and Planning cubes and comparison of the capabilities and calculation times of both the BSO and Hybrid versions. The session will also include brief discussion of some of the other features of the new version. But in any case, be assured that this will touch on both the promise of Hybrid and the disappointments in what we have seen.

Planning with a native ASO Essbase engine has been a long time coming, but it is finally here. Does this now mean that all of the scaling, capacity, and performance issues that many larger Planning applications have struggled with are now magically resolved? Or are there still some restrictions? And has ASO brought new good practices that must be observed? Join Cameron Lackpour, a Planning practitioner since Planning 1.5, and Dan Pressman, Mr. ASO, as they review what is great and maybe not so great about ASO Planning and how to make your ASO Planning implementation a success.

Planning and Essbase are two arrows in the Oracle EPM quiver that are indelibly tied together. Essbase is the calculation and analytical heart of Planning; Planning is the incredibly popular application wrapped around Essbase. One could not exist without the other.
Yet when we EPM practitioners think about these twin tools, when they are sold to customers, when they are implemented for clients, and even when Essbase and Planning are presented at conferences, it often seems as though they are two completely separate products. Ignoring the intertwined nature of the products lessens their power and utilization. It's time to end this artificial separation.
Join Oracle product managers Gabby Rubin (Essbase) and Shankar Viswanathan (Planning) in a never-before, you'll-only-see-it-at-Kscope, OMG-they-are-actually-doing-it panel that lets you, the best and brightest Planning and Essbase practitioners, ask just about any question you might have about current product features, where the two products are headed, and why the two products maybe do need to be separate yet linked offerings.
What's happening with Essbase that will radically change the way we implement Planning? How is Planning driving the feature set of Essbase? What do you wish the two products would do better together? This is our chance to understand how Oracle views and understands the products.
Send your questions to the Twitter hashtag #PlanningDeepDive and hear your question put direct to Oracle management.

Oracle User Productivity Kit (UPK) is an easy-to-use and comprehensive content development, deployment, and maintenance platform for increasing user productivity and enterprise training effectiveness. Oracle UPK supports applications from Oracle, SAP, and Microsoft as well as custom applications. Content development can be purely application-specific or accommodate a well-balanced mix of business process. Furthermore, Oracle UPK can assist in documentation output through a variety of formats as well as enable organizational readiness through user tracking and competency measurement. The audience will learn how UPK can add tremendous value through increased end-user adoption and reduced organizational risk in regards to EPM implementations, throughout the entire project life cycle.

This session will briefly explore the various methods for exporting data out of HFM (Extended Analytics Link vs. Extended Analytics). It will explain why each of these methods did not meet the business requirements. The session will then focus on the solution that was employed to solve the problem: an API-based application that uses process management to drive the extract process. The session will walk you through the application that was created and how the API calls were used to create a unique solution that is based on process management. You will gain familiarity with the HFM API calls and Smart View VBA calls as well as gain another way to extract data out of your HFM application.

Building rolling trend reports in Hyperion Financial Reports utilizing advanced range and suppression techniques can allow the developer to build robust and low-maintenance financial reports, thereby eliminating the need for excessive columns as well as report templates.

In the spring of 2013, Oracle announced that the terminal release of FDM/ERPi "FDM Classic" would be release 11.1.2.3 and the replacement product would be FDM Enterprise Edition, which combines functionality from FDM/ERPi. This session will present lessons learned when migrating from FDM/ERPi 11.1.2.2.300 to FDMEE 11.1.2.3.100.

Typically a company will have tens to hundreds of Financial Reporting reports. Unfortunately, Oracle has not provided a solution to report on the usage of FR, with the exception of FR logs. This session will demonstrate how the FR logs can be parsed to report the key metrics of who, what, when, how long, and POV.

In this presentation, the APEX Quality Assurance Plugin will be demonstrated. It's a plugin based on APEX 4.2, which gives every person who works with APEX an easy and powerful opportunity to define your own testing rules. These rules can be defined in SQL syntax to support every possibility for a rule defined in the database. On the one hand, rules against the APEX repository such as using no "never condition" or don't use a help label without a help text can be defined. On the other hand, checks against the whole database dictionary or checking contents of tables are possible.
The plugin is easy to install and will bring a start set of rules by installation with it. When the plugin is installed, it can be used on the Global Page to be shown on every single APEX page to show all problems on that special page that is developed.
Many more ideas will be shown, such as combining the plugin with a scheduler job and/or sending summaries from every page to the developers by mail, which can be really helpful. Overall, it's an easy and fast way to find bugs while you are developing, and it's a far more powerful and adjustable tool then the APEX Advisor.

This session will discuss how Blue Stone has partnered with a fast-growing social media company to build and utilize Hyperion Strategic Finance to enable a more analytic long-range planning process. The session will cover the company's process before Hyperion Strategic Finance as well as the benefits of leveraging Hyperion Strategic Finance. The session will also touch on the driver-based model that would provide the opportunity for finance to look at the following:
* Scenario analysis around revenue drivers (daily users, clicks per user, cost per click, etc.)
* Changes to headcount and the corresponding effect on SG&A expenses (headcount, equity/new employee, cash/new employee)
* M&A and Capex inputs and relationships with financial accounts

When the requirements get complicated there is a straighforward strategy to writing efficient SQL that will reduce the amount of time you lose trying to get the database to do the right thing; but it requires knowledge of the data, the metadata, and the intent of the query.
In this presentation I start with the basic principle of efficient data access; then look at ways of analysing the data (in case you are not familiar with it already); finally I outline the principle of efficient data access, using a graphical approach to model a query, and finish with a small example
from a production system I was called to review some time ago.

You may have heard that when you write code to address relational databases, you don't need to know HOW taccess the data. The statement is true, but not in the way that it's often interpreted.
The optimizer will ensure that if you write the correct statement you will get the correct answer - but there are many reasons why the optimizer might not get to that answer in the most efficient way. If you learn a little bit about how the optimizer "thinks" and how it analyzes the problems you give it, you will soon learn to recognize when, and why, it's going to make mistakes and what you can do to push it into a reasonable execution path.

This session will explore the features and functionality released in Exalytics. Additionally it will describe some of the features we are currently working to develop for future iterations of the solution. There will be a definitive slant towards Essbase functionality throughout the session.

This session will discuss some of the differences between CalcParallel and FixParallel. In addition, a deeper discussion into some of the nuances behind maximizing performance of both methods. Some examples comparing the two will be presented to highlight how FixParallel adds to Essbase's ability to go faster and utilize larger architectures.

Today's CFOs face a constant onslaught of cost pressures, regulatory changes, and ever-changing market dynamics. Many are saddled with unwieldy, expensive financial information architectures consuming the precious resources needed to meet new analytical and reporting requirements. Hear how leverage of a data warehouse and best-of-breed tools such as Oracle EPM and Business Intelligence products are helping companies reduce infrastructure cost while improving business performance.

1. Understand the full life cycle of a discovery application.
2. Learn why data discovery is critical for your organization. and an integral part of your Business Analytics strategy.
3. Hear what kinds of problems have been addressed by Oracle Endeca Information Discovery and where you can apply this innovative new product.

Two things are certain in this life: death and taxes. Implementing the right software will help you and your company make the best of it. Learn from the experience of those who implemented the new Hyperion Tax Provisioning software and then came back to this world.

With HFM approaching its 12th birthday, some applications that are old enough to enjoy this milestone are starting to show a mid-life expansion. Michael Malandra, lead consultant with Edgewater Ranzal, explains different approaches to archiving old data as part of a massive database reduction program.

Database security is important, from design to development to production. With Oracle Database 12c, there are some new key security features that help in securing the environment and keeping it that way. This presentation will discuss the cool new security features and demonstrate ways to implement features such as data redaction for APEX applications without any code changes.

Getting your point across visually is an increasingly important component of web applications. Take your visualizations to a new level by animating the exploration of previously static screens, using movement to show changes over time, and providing interactive filtering facilities to visualizations.
Concepts, methods, and implementation considerations of different ways that time elements can be incorporated into visualizations will be covered. The demo will cover analysis of a static visualization and implementing animation to show changes over time. The demo will be performed on Application Express, but implementation points for other common web-enabled languages will be highlighted.

Oracle Business Intelligence has the power to amaze users by producing interactive, visual dashboards. Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents.

So your users want to see all of their data - at the customer level. They also want to see it at the product SKU level. They also want to see it by store. They would also like the kitchen sink. Attend this session so you can give them the kitchen sink and everything else. Drawing from experience with real clients, learn some simple tricks and some advanced techniques to maximize your ASO database performance. Whether you have millions of members or billions of rows of data, this session is just what you need to get the most out of your large-scale ASO cubes. This session will offer cache settings, load rule tweaks, slices of data, and much more.

Essbase and HFM store data very differently, but that doesn't mean that we don't need to see HFM data inside of Essbase and Planning. With eliminations and other interesting things inside of the value dimension, how do we handle that in Essbase? Now that EAL is available, do I still need EA? When should I use one over the other and what are the benefits? If you need to get data out of HFM for Essbase or any other application, this is a must-see session with real-world examples and live demos.

Hyperion Planning provides an excellent platform for deploying enterprise-scale budgeting and forecasting solutions. But there are some basic functions that Planning simply cannot accommodate out of the box. Learn how to delete years from the past, remove dimensions you no longer use or need, and report on secured objects and who is doing what on your applications. This session will also provide a primer to the Planning Repository and a variety of queries for attendees to take home and void their warranties.

A group of APEX developers have joined hands and developed a free Twitter Bootstrap APEX theme and made it available for everyone who wants to use it. In this presentation, you'll learn about Twitter Bootstrap and how to use the theme in APEX for building fancy applications. In addition, the theme has some other cool features for creating fancy buttons and user-friendly form validations.

Securely exposing data from an APEX environment via RESTful web services is now possible using the APEX Listener 2 and, in turn, Open Authorization 2.0 (OAuth2). This session will introduce the concepts behind this process while showing attendees a demonstration of the same. Specifically, the session will explain the advantages of RESTful web services over other web service technologies. Then, after explaining the mechanics of OAuth2, the session will walk through the process of setting up a web service in APEX using the APEX Listener and calling it from a third-party client. Particular attention will be paid to the security techniques used in this infrastructure.

This session offers a practical guide to RPD data modeling. John will give away trade secrets on how and when to model data in OBI and why actually using best practices may, in fact, save your skin in unexpected ways further down the road. He will also explore "old school" vs. "new school" methods of modeling and explore the cost and benefits of each. As always, John will have a section for those new and fancy 11.1.1.7.x features you have been thinking about using but just haven't had the time to explore.

In Oracle Application Express 4.2, new features give developers the ability to easily create mobile web applications that look like native mobile applications. But with new capabilities come new challenges. One such challenge developers must contend with is that mobile devices often lose their Internet connections where signals are weak. Is there anything developers can do to prevent the loss of Internet from rendering mobile application built with Oracle Application Express useless? The short answer is yes, at least to some degree, thanks to several new technologies that have emerged to tackle this common problem. In this session, you will learn about these exciting new technologies and how they can be utilized in Oracle Application Express applications.

While OBIEE includes some standard (and some not-so-standard) views, there are a host of visualization tools out there aimed at increasing any web-based tool's ability to visualize data. This session will walk through the technical integration of several visualization tools into OBIEE and show examples of them in action so you can add more value and sophistication to your OBIEE dashboards.

For years now, OBIEE has been supplanting Web Analysis, Interactive Reporting, SQR, and a whole lot of other Hyperion reporting tools. OBIEE has been Oracle's strategic BI reporting suite of tools for five-plus years, so why are EPM developers and users so slow to adopt it? Well, there's nothing to be afraid of, and in OBIEE 11, there's much to be impressed by. EPM people out there will learn the easiest ways to start developing in OBIEE, including using Smart View to make OBIEE queries and using Oracle BI Mobile App Designer to make Business Intelligence presentations as easily as they make PowerPoints. Whether you're a business or technical person, learn how OBIEE can make your life better and make your Essbase cubes and Hyperion applications look even better. Come on into the OBIEE pool, little EPM swimmer: The water's fine.

In this session, a panel of four of the top minds in EPM and BI reporting will square off in a battle of pure wits. These experts will be given real-world business cases and be pitted against one another to come up with the best reporting solution. Hear why they make the case for their solution - and root for your favorite. Do you have unanswered questions about how to accomplish your reporting needs? Do you use Smart View, FR, OBIEE, or charts drawn on the back of a napkin? This session will be interactive, so be sure to come with your questions and see if just maybe you have what it takes to stump these experts.

For the last twenty years, Essbase Calc Scripts have been the most powerful way to control calculations in Essbase BSO (and in a similar fashion, in Essbase ASO starting in 11.1.2). While still powerful, is there a better way? Is it possible that we should start using Hyperion Calc Manager not just for Planning and HFM but to also write our Essbase calculations? In this session, Oracle ACE Directors Glenn Schwartzberg and Tracy McMullen will face off to determine which solution is the best today. Two products will enter, but only one will leave.

Apart from Twitter, LinkedIn, Google, Facebook, Yahoo!, Amazon, and so on, for most companies, the source of big data is predominantly data residing in RDBMS and secondarily weblogs.
For analyzing RDBMS data and correlating with weblogs using MapReduce patterns, you either ship data to an external MapReduce cluster or bring MapReduce function to the RDBMS.
The session discusses the most recent tools and techniques for processing big data, the need for quality of service (QoS) such as security, manageability and integration then describes a database-resident Hadoop container for running Hadoop mappers and reducers directly in RDBMS.
The integration of Hadoop job steps in SQL queries makes easier for non-Java developers to reuse them transparently. DBAs and Database developers will learn how develop and schedule MapReduce jobs without learning Hadoop.

Because of file-size limitations and to have more features for file uploads such as drag/drop and multiple file uploads, we had to integrate APEX RESTFul Web Services and a jQuery plugin. In this session, find out the solution and how to implement it.

During this session, learn how to create and maintain multilingual applications. Find out how to run the APEX Builder in multiple languages and explain the translation process. See a demonstration of how to export and import the translated applications and how to add the ability to switch from one language to another during the execution of an application. This session contains technical information as well as live demonstrations.

Want to deliver critical analytics and BI data to your end users on their mobile devices? Want to include data from OBI, Essbase, Relational Databases, and even Excel? If your answers are "yes," then join us for this hands-on lab. You will create a mobile app with no code and no need to call IT.
You will be presented with a data file (we will use Excel as the data source) and a use case for executives. You will need to create an application for the phone, the tablet, or both, that solves the use case.
Don't worry; we will help you through the process, and we will show you how to connect to a data source, create an application (including sub-pages, filters, drilling, and more), and deploy and test the application.
The lab will include installing BI Mobile App Designer (Trial Edition), so bring your laptop (Windows or Mac) and your mobile device of choice (tablet or phone).

Let's face it; w all still live in Excel, so why not leverage Excel capabilities while accessing all my organizations data sources? In this presentation, go through the process of combining multiple data sources in a single spreadsheet. Data sources will include OBI, Essbase, HFM, and Planning, and you will find out how, as an end user, you can combine data from various sources into a compiling analysis. This presentation will use the latest release for Smart View and Office 2013 to pull off this multisource madness.

How long does your code take to run? Is it changing? When it is slow, WHY is it slow? Is it your fault, or somebody else's? Can you prove it? How much faster could your code be? Do you know how to measure the performance of your code as user workloads and data volumes increase? These are fundamental questions about performance, but the vast majority of Oracle application developers can't answer them. The most popular performance tools available to them - and to the database administrators that run their code in production - are incapable of answering any of these questions. But the Oracle Database can give you exactly what you need to answer these questions and many more. You can know exactly where YOUR CODE is spending YOUR TIME. This session explains how.

MDX is an industry-standard language that is at the heart of Essbase ASO calculations. It can be used to query both ASO and BSO. It also shows up in plenty of other places, such as triggers and Smart Query.
This session starts at the beginning, and using hands-on exercises it quickly develops MDX concepts, basic syntax and the most commonly used functions. Next we will make some comparisons and conversions from BSO Calc language. Last we will cover some intermediate topics, including conditionals and rolling calculations.
Topics include:
· Syntax basics and concepts
· Basic queries and member calculations
* Hierarchical and cross-dimensional references
* Controlling calculation order
* Simple and complex ratios
* IIF and CASE
* Rolling calculations

Oracle Data Relationship Management (DRM) is a critical tool for centrally managing hierarchies across your Hyperion landscape. See how Baker Hughes built a data-driven model and expanded beyond Hyperion by leveraging DRM as the centerpiece of a master data hub used for enterprise hierarchy management. Baker Hughes is leading the way in providing hierarchies as a service offering by exposing hierarchies, properties, and dynamic data mapping for consumption by a broad range of enterprise applications.

CXO-Cockpit delivers web-based and mobile dashboard solutions for Hyperion HFM, Hyperion Essbase, and Hyperion Enterprise EPM systems. The finance-owned suite of reporting tools offers cost-effective, quick-to-implement, and Excel-like functionality that enable effective decision making. During this presentation, the powerful reporting and dashboard functionality of the CXO-Cockpit will be demonstrated to you live. CXO-Cockpit serves a fast-growing user community of over 2,000 financial professionals and more than 50 leading multinationals globally. Frank A. Loglisci and Jesse Lane will discuss how CXO-Cockpit was implemented at the CA Technologies organization and how the cost-effective solution adds value to their reporting processes.

This session demonstrates a weekly cash-flow reporting solution leveraging the Oracle Hyperion EPM System for financial modeling and analysis with the Oracle Business Intelligence platform for reporting both financial results and operational drivers impacting the financial performance.

The session starts with a basic introduction to the language, moves through intermediate query techniques for combining dimensions, and finishes by demonstrating metadata filtering techniques in queries. Slides in the session are provided for reference, but their use will be limited as the session is primarily demo-focused. Further, attendees will receive an MDX cheat sheet that shows common calculation script commands converted to MDX.

This session will cover single sign-on among APEX applications within the same workspace, separate workspaces and separate databases. It will also provide a method for secure single sign-on from other applications to APEX applications.

Just having an idea for a plugin is not enough. A number of questions will arise when you want to get started: What type of plugin should it be? What kind of properties do you want the users to control? Can the plugin be based on a SQL statement? What kind of measures should you take to create a secure plugin? This session is your starting point.

This presentation will demonstrate dispelling some myths about small projects using big tools, such as Oracle Database. Oracle is often perceived as a big tool and discarded for consideration by small projects. .NET developer culture is especially averse to any Oracle anything in the stack of tools at hand.

This presentation will walk through the team development tools that come out of the box with JDeveloper and show how they can be implemented in such a way as to 1) increase developers' productivity and 2) not slow coding and build efforts down.

It's no longer enough to build a Hyperion environment that suits only the basic needs of a finance organization. Manual processes, administrative overhead, and a skills shortage forces organizations to overburden the administrator with maintenance tasks rather than development or new projects. This presentation will focus on unique ways to empower administrators and end users to manage their data efficiently, reducing reliance on human intervention, and reducing the stress related to seasonal use. By leveraging the available existing infrastructure, our lessons learned, and new features (v.11.1.2.3), users can update data, perform what-if analysis, and get near real-time congruence with source systems.

This session will provide best practices in upgrading Hyperion product suite directly from 9.3.1 version to 11.1.2.2.3. It would explain lessons learned at the global Hyperion project at Citrix Systems Inc.

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 of how you can maximize your Oracle Database investment. This session is aimed squarely at those who've only ever heard of Application Express or are just starting out.

Be one of the first people to learn how to build mobile web-based applications using the latest and greatest features being delivered with Oracle Application Express 5.0. Learn how you can declaratively build a compelling mobile application that uses some of the latest HTML 5 capabilities. No hand crafting or in-depth knowledge of JavaScript or AJAX is required. This brand-new hands-on lab will be hosted on a special APEX 5.0 environment.

This session will provide an overview of the major new features being delivered in Oracle Application Express 5.0. The main goal of Oracle Application Express 5.0 is to improve developer productivity. See how the many improvements to both the Application Builder and the components you can use to build applications can make it even faster and easier to exceed your customer's business requirements when building web applications with Oracle Application Express.

This one "double" session (two-plus hours) is designed to take you through building a comprehensive application using Application Express. This hands-on-lab session is designed for people with no prior knowledge or very little experience developing with Application Express. You will learn how to develop a large number of different application components and walk out with the confidence and understanding of how to start building your own applications using Oracle Application Express. For this lab, please pre-install Oracle VirtualBox and the APP Dev VM.

Please join EPM Customers; Russell Morton, from Baker Hughes, Edward Cody, from General Dynamics, and Nikki Verhoff, from Verizon wireless, as they discuss their implementation success stories with Data Relationship Management. This session is organized as a customer panel to discuss their first hand experiences including business challenges, solutions to effectively manage master data changes across the organization, business benefits achieved, best practices and lessons learned!

Self-directed learning about a product as complex as Oracle E-Business Suite can be challenging, and for many developers in the Oracle space, interfacing with EBS is crucial, not optional. Oracle provides pre-built Oracle Virtual Machine (OVM) templates to help people deploy demo environments quickly, but this presents its own set of problems: building an Oracle VM Server is a resource-intensive task, not for the faint of heart. Fortunately, there's another option.
This talk will demonstrate deployment of the E-Business Suite 12.1 OVM templates in Oracle VirtualBox instead of Oracle VM, to create an R12 sandbox (aka "Vision") environment on your workstation. We will discuss the required tools, explain the techniques, and help you to see just how easy this can be. There will also be a live demo during this presentation; when we say "in an hour," we mean it!

The latest release of Toad for Oracle seamlessly connects you to the Toad World user community, facilitating Q&A with industry experts, interaction with peers, and access to a wealth of platform information. During this session, you'll learn how to leverage several development-related connected intelligence features through a series of use case scenarios, including:
* Jump Search -- solve problems by searching on any Toad or Oracle topic in question, or discover new, valuable Toad features
* Forum window -- start discussions, collaborate, and conduct Q&A with other Toad users without leaving Toad
* MyToad -- connect to Toad and your Oracle server to execute scripts and generate reports from any web-enabled device
Join us to see how you and your team can become more efficient and better informed with Toad for Oracle.

This lab will cover the ins and outs of loading Master Data to DRM, along with enriching the information with DRM formulas, inheritance, and default values. The exercises will include the creation of an export file that would be ready to load into a target system.

In every industry, there is always talk about businesses needing to stay competitive. The only way to do this is through informed decisions and agile business practices. These only come about with quality forecasts that shape future outcomes and the ability to immediately react to changing events. This is why many companies are looking for alternatives to annual budgets.
A rolling forecast is a more fluid approach to planning and forecasting. You will always find change happening in your business, and even the smallest amount of it can impact on your numbers, focus, plans, etc. With a rolling forecast, you can emphasize the forward movement of the business because it is always looking ahead twelve to eighteen months. You avoid the cliff event such as end-of-year with a continuous process that combines the traditional plan and forecast.
In this session, using case studies and real-world examples, Juan will discuss the ins and outs of rolling forecasts, covering:
* Transitioning traditional forecasting to rolling forecasts
* Implementing rolling forecasts
* Advanced methods in rolling forecasts
* Understanding your forecast
The session will include guidelines, tips, tricks, and best practices to make sure you get the most out of this approach.

Automation is the king when it comes to eliminating resource-intensive, lesser-return tasks and moving DBAs onto more challenging and rewarding projects. This session will focus on the "as-a-service" features in the Enterprise Manager 12c suite, including prerequisites, designing, security, and implementing.

Creating a Virtualbox environment with a ZFSSA simulator to work with Database as a Service, (DBaaS) and Middleware as a Service, (MWaaS) These are essential features to many developers and DBAs today. The ability to create a self-service portal for developers to request databases on demand/as needed and for a DBA, to release the demands on their time to allocate to more important tasks.

The interface has not only changed, but so has so much else. The narrowed view of monitoring becomes one of amazement as you realize your entire infrastructure management, monitoring, and cloud migration can be done from the one console. This session will cover all the newest features and coolest tricks that will assist you in troubleshooting issues, fixing problems, and building out an environment that gives everyone from the developer to the DBA more time to do what interests them vs. the same tedious task day in and day out.

Why are some cubes fast and some are slow? When is it OK to use MDX, and when should (or what types of) MDX be avoided? How do solve order, dynamic, and stored hierarchies interact?
By understanding how Essbase goes about resolving a query, many of these questions will answer themselves. Much of this understanding comes from the cryptic bitmap-statistics dialog in cube properties. All of this is summarized in 12+1 rules. These 12+1 rules are discussed and used to illustrate how they should be adopted when designing your cubes.
In particular, there are implications and options for the design of alternative hierarchies. These options will be discussed in terms of the tradeoffs of cost (in storage size) vs. performance (in retrieval time). Concrete examples will be demonstrated.

This will be a series of questions submitted by the audience in advance to the head of Essbase development. This format will allow the questions to be grouped and organized into a coherent flow. It will also allow certain "safe-harbor" questions to be avoided if necessary.

This is an overview of LCM specifically for HFM developers/administrators. We will explain LCM, how it works, and where it fits in relative to the other tools available, such as the Database Copy Utility.

Oracle APEX 4.2 comes with a wealth of packaged applications. These can be immediately used and might cover your requirements. But have you ever unlocked such an application and looked at what you can learn from the code and the way it is implemented?
There are many interesting things hidden in those packaged apps: plugins, themes, code snippets, ideas, and much more. Find out the highlights, how to extract them easily, and how to reuse some of the code and then see how you can read the APEX code of the Application Builder itself. Prepare yourself to absorb all the APEX know-how.

So you are putting your APEX application out there and the whole world can access it and play with it, and some script kiddies are going to try to break it. Sound scary? This session tries to give you a checklist of things you'll have to think about before publishing your application to the world. There will also be solutions and techniques for how to fix things and improve the user experience. The session will cover design, security, SEO, and some general lessons learned over the past few years.

Oracle's Application Express platform (APEX) has emerged as the most compelling Rapid Application Development (RAD) platform available in the Oracle ecosystem. It is easy to learn, provides broadly useful functionality, and is free to develop and use for existing Oracle customers. However, it has never been positioned as a "serious" development platform for mission-critical enterprise and super-enterprise product development. After all, it's free and it doesn't support Java.
Alternatives to APEX are quickly narrowed to Open Source Frameworks, Oracle's Java based ADF, and Oracle Forms. Developers, managers, and architects find themselves at a crossroads trying to balance their clients' requests for Rich Internet Applications (RIA) that are more "Google-like" (in their words) with the pressure to do more with less (time, resources, and capital) using RAD. Compounding this is the need to validate with their peers that they are using an enterprise ready software stack for serious product development.
Let us show you our solution to this dilemma and introduce you to the FOEX Framework, a set of over 100 feature-rich plugins that extend Oracle APEX with Sencha's Ext JS, an RIA framework validated by Gartner Group and used by 50% of Fortune 100 companies. This marriage gives you the best of both worlds, giving you true RRIAD - Rapid Rich Internet Application Development. In other words, you can finally deliver to your clients desktop-like features in your web application amazingly fast and easy with an industry-validated software development stack.

Providing real-time data to its global customers is a necessity for IFPI (International Federation of the Phonographic Industry), a not-for-profit organization with a mission to safeguard the rights of record producers and promote the value of recorded music. Using Oracle Streams and Oracle Warehouse Builder (OWB) for real-time data replication and integration, meeting this goal was becoming a challenge. The solution was difficult to maintain and overall throughput was degrading as data volume increased. The need for greater stability and performance led IFPI to implement Oracle GoldenGate and Oracle Data Integrator. This session will describe the innovative approach taken to complete the migration from a Streams and OWB implementation to a more robust, maintainable, and performant GoldenGate and ODI integrated solution.

Oracle has developed a strategy for creating outstanding mobile applications. Learn about three key principles that are applied to our overall design and development process. Our mobile applications embody simplicity, mobility, and extensibility. You will see these principles demonstrated in UX design patterns, which are implemented with ADF and ADF Mobile creating mobile applications that stand out from the rest.

Thinking about utilizing EPMA but don't know what first steps to take? Leaving the familiar world of the HFM Client and all your Excel metadata files and macros may seem daunting, but getting your feet wet in EPMA can be a low-risk activity that adds value to your organization. This presentation will cover a few pros and cons of Classic vs. EPMA and then focus on the specifics of EPMA metadata management.

Allocations are not only the crux of your financial process, but more often than not, they're a tangled web that is hard to unravel. It doesn't have to be that way. By using what you already have, you can make a rock-solid allocations solution for your organization and begin to navigate the budgeting and forecasting process with ease.

This session will provide an overview of the Hyperion Planning utilities with three in-depth client case-study examples to help consultants and business users better utilize the available administrative utilities.

The APEX Listener has many features and options above and beyond a simple replacement for mod_plsql. This session will give an overview of all the options available to users, which range from best practices on connection pooling to how to install and configure RESTful services.

See how to quickly configure Oracle Application Express Listener in just a few minutes, using Oracle SQL Developer. Learn how to rapidly develop JSON-based RESTful Web Services to web-enable data stored in your Oracle Database instance using simple SQL queries and PL/SQL blocks. A demo mobile app is built during this presentation to show how easy it is use these RESTful services to expose data stored in Oracle Database to client applications.

Every development shop is unique, and sometimes that uniqueness can hinder using tools. SQL Developer and Data Modeler have multiple mechanisms that allow for customizations. These customizations can range from simple to complex and can help tailor the tooling to any environment. Some are as simple as colored warning to remind the user what is production vs. development. Some could auto-generate code by walking over a data model. The most complex can change anything at all in the tool. Ever think of a command that should be in SQL Plus scripting? Want to auto-generate table APIs?

APEX development is not just about Oracle PL/SQL and SQL. In fact, it requires other disciplines to provide a richer user experience. With some knowledge of HTML, CSS, and JavaScript, your APEX applications can begin to shine. However, you need a helper to better work with this technologies. If you're running SQL, you may use SQL Developer, but what do you use for HTML, JavaScript, and CSS? Enter inspectors. In this session, we'll cover the built-in inspectors for Chrome, Firefox, Safari, and the famous Firebug plugin among others.
Learn the ins and outs of these tools and how they improve your everyday work with APEX. They are easy to use. No installation required (except for Firebug) and a just keystroke away.

With Oracle's announcement at the last OpenWorld, OBIEE will now be available in the Oracle Cloud as "Reporting as a Service." What does this new product promise, and what other options are there for running OBIEE in the cloud - either Oracle's or from platform and infrastructure-as-a-service providers such as Amazon AWS, Rackspace, and VMware? In this session, we'll look at various approaches to running OBIEE in the cloud and licensing and product features, and see how supporting infrastructure such as data warehouse databases, ETL tools, and identity management can also be deployed in the cloud to support OBIEE.

This presentation goes through the development of an OBIEE application sourcing data from "big data" sources via the new Hadoop connector in OBIEE 11.1.1.7 and other big data and unstructured sources via ODI11g. Aimed at developers looking to build BI dashboards using Hadoop-sourced data, the session provides an end-to-end guide to developing a repository and dashboard connecting to Hadoop via Hive and also looks at how you can optionally leverage the in-memory store within Exalytics to make interactive big data analysis faster.

See how core TimesTen technology works and how to best deploy it as part of a vanilla OBIEE, and Exalytics OBIEE, architecture. See how having a separate mid-tier database permits more agile development than when you've just got a single, monolithic data warehouse.

Most APEX applications are built with one of the standard themes installed with the framework. This may be sufficient when using an application internally. As soon as you are launching an application for a public audience or business, you want to match your application's look and feel to your own brand and style. APEX allows complete customization of your application's user interface elements. But where to start? What do you need? More importantly: What do you need to know? About APEX, web technologies such as HTML and CSS, and, how to bring this together? Documentation on this subject is very sparse. This session will cover the basics of the APEX theming mechanism, and how to customize existing themes and build an entire new theme.

Oracle Application Express is using its own syntax to pass URL parameters, called the f?p syntax. In fact, there is only one standard URL search-path parameter: "p". This makes APEX URL's less readable for users and very difficult to understand for search engines. This session will explain and demonstrate a few techniques, including how to enable standard URL syntax in conjunction with APEX, to present pretty URLs to users and search engines just using the APEX Listener and the database.

Everyone is talking about mobile business intelligence (sometimes called Business Analytics Anywhere). Before your CEO or CFO asks you to put reports on his or her iPad, make sure you have a solution in mind. Luckily, Oracle has two really good mobile answers: OBIEE Mobile Analytics and Oracle Hyperion Financial Reporting. In this session, you will be shown both possible solutions. You will leave understanding the benefits of both and the basics of how to implement. If you want to see analytics on your iPhone, iPad, or Android device, come to hear about the best current solutions available.

Join ACE Directors Edward Roske and Glenn Schwartzberg as they fight out who has the best optimization tips and tricks. Who will win this epic battle of minds? Come find out. At minimum, the audience will win as they get some of the great optimization ideas and hear different viewpoints on optimization.

With the new release of Essbase, it's easier than ever to use the calculation power of block storage with the scalability of ASO. Block storage has a richer calculation language and great control of writeback. ASO allows larger applications and faster aggregations. Now it's possible to use the right technology tool for the right job. In this session, find out when to use each type and when to use the two together. While many have been rolling their own for years, it's now possible to more seamlessly integrate Essbase BSO and ASO in a way that will make your Essbase friends die from witnessing your awesomeness.

With Oracle Essbase being a key platform for Oracle Enterprise Performance Management applications, Oracle Business Intelligence, and Fusion, 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 the upcoming year.

The integration of Oracle Business Intelligence and Essbase had been a significant on-going undertaking for Oracle in the last few years. However, while technical integration is important, it needs to have strong footing in customer use cases in order to drive value and adoption. Join us as we explore what is available today from Oracle, how these products work together and what is the vision of Oracle when it comes to Essbase and BI.

Ever wonder how much easier it would be to make sense of your geographic data if you could visualize it? Learn how to free your geographic data from the confines of your tables, and render it in colorful pins and polygons, to provide you with a better perspective.

Your organization has invested in HFM, Planning, Essbase, and other EPM components. In this session, we will explore how you can continue to leverage your investment in FDMEE to manage data integration as well as intrasystem data movement. Key product functionality will be outlined. A discussion of best/leading practice use cases for FDMEE within the EPM stack will follow. The session will conclude with a real-world case study.

Your FDM Classic application has a number of event, custom and import scripts. You're considering an upgrade to FDMEE but are concerned about the new scripting language (Jython) used by FDMEE. In this session, explore the fundamentals of Jython scripting used by FDMEE. This will include a review of an editor used to create scripts and an overview of a basic import script.

If you've just been handed the keys to your own Hyperion implementation, or you're simply looking for advice and insight from peer experiences for the day-to-day management of Hyperion, this is your session. Join Rich as he discusses practical tactics and strategies for managing your implemented Hyperion solution. He will walk through a punch list of actionable practices spanning an organization and its financial calendar. The session will discuss real-life situations and provide the inside scoop on what makes an implemented solution run efficiently.

Don't let consultants have all the fun. This tour of the Essbase Block Storage Option (BSO) is for everyone. Take a peek under the hood of this awesome architecture and walk away with a foundational understanding of DENSE and SPARSE settings in your Essbase models. Your business doesn't stand still, and when the business model changes, the calculations you rely on in Essbase need to change, too. This presentation will act as a springboard to have you writing and tuning your own calculation scripts in no time.

This session, begins with taking data from OBIEE and using it to build a cube using Essbase Studio for fast response time. The cube will then be used within an OBIEE RPD to do very fast reporting and will be spun out to mobile devices using Mobile BI and Mobile App Designer.

Now that you have mastered the basics of smart View and can retrieve data, no it is time to learn some of the advanced features to make your life easier. Details of what will be included will be added closer to the conference.

This session will introduce Essbase Studio as told by Glenn, the Essbase Studio guru. Come to this session for an overview of the features and functionality for beginners. It will cover the main areas of what it is and how it works, and walk through the creation of a cube from start to finish. Experience Glenn's overwhelming enthusiasm for the best data-integration tool around.

Let's face it: Developers usually don't enjoy testing. However, there are a lot of tools available that make testing easy, quick, and rewarding. In this session, find out how you can use some cutting-edge tools to make testing your APEX applications easier.

While Oracle APEX is great at doing many things, sometimes you want to step outside of the box. Node.JS is a relatively new platform that is becoming increasingly popular with web developers. This session will cover how you can integrate Node.JS and APEX to create some amazing features.

As part of the Oracle Business Intelligence Foundation Suite, Oracle Scorecard and Strategy Management (OSSM) is one of the least-emphasized components of Oracle's flagship analytics offering. However, there are many must-see features and architecturally beneficial components that practitioners and users of Oracle BI should be aware of to fully realize the full potential of OBIEE. As the go-forward replacement for the Hyperion Performance Scorecard application, this session is perfect for both a Hyperion and Oracle BI audience. This session shows attendees how to prototype an OSSM solution and how to leverage and write back to Essbase from within OSSM. In addition, the session investigates the benefits of the OSSM integration with OBIEE and highlights differences with its legacy Hyperion Scorecarding application.

Hyperion Planning and Oracle BI Applications both have a history of initially leveraging Informatica as the ETL tool of choice before being roadmapped to Oracle Data Integrator. Oracle Data Integrator is the key data transformation and movement tool for Oracle products. This session seeks to inform attendees about best practices for development, migrating between environments, and administration. This session will cover similarities between Hyperion Planning ETL development and Oracle BI Application development with ODI 11g.

NoSQL and NoSQL databases are hot topics. Did you know that Oracle has a NoSQL database product? This session will provide an overview of Oracle NoSQL Database, including the latest features included in Release 3.0. The session will cover the new Table data model, Secondary Indexes, Data Center support and Security features. This session will also include a demonstration of table and index creation as well as simple get, put and delete operations that are available from the NoSQL command line interface."

HPCM provides a business-user-oriented application for building and maintaining allocations models. It is flexible, provides traceability to highlight each step in the allocation process, and creates results in an Essbase cube for analysis.

University of California, Berkeley purchased Oracle Hyperion Public Sector Planning and Budgeting (PSPB) to implement employee/position budgeting, which uses Oracle Hyperion Planning as the foundation. It provided out-of-the-box configurable position and employee models. The university has the capability to budget by position and/or employee, associating them to existing or new positions. This includes managing the allocation of various funding sources to position level budgets and efficiently managing future dated changes.

The first half of this session introduces Oracle Database support for .NET, including Oracle Data Provider for .NET (ODP.NET) and Oracle Developer Tools for Visual Studio. We'll demonstrate how to use Oracle Database with Visual Studio for .NET development. The second half discusses recent and upcoming features in the most recent Oracle .NET releases, including Entity Framework 6 and Code First, Visual Studio 2013, fully-managed ODP.NET, Oracle Schema Comparison tools, and support for new Oracle Database 12c features, such as multitenant database administration from Visual Studio.

.NET and Oracle programmers frequently work with SQL and PL/SQL, whether that means setting up a call to a stored procedure from .NET code, writing and debugging PL/SQL stored procedure code, or generating deployment SQL scripts and checking them into source control. This session begins with coding tips and tricks for writing performant .NET code that leverages PL/SQL. Next, we demonstrate SQL and PL/SQL script creation, editing, debugging, source control management, and automated performance tuning of both the SQL as well as the .NET application as a whole. Finally, we show how to use the new Schema Compare tools which greatly assist developers during development and deployment.

When you approach developing for mobile devices, there is much more than just development tools that you need to consider. In this session, get an introduction to the complete mobile development platform from Oracle. Learn how the platform can help you with aspects of application development, accessing back-end systems, securing, synchronization, app management, and more.

With a shift in the type of devices accessing your web application and the rise of touch-based mobile tablets and phones, it's time to start thinking "mobile first" when designing your web applications. In this session, you'll learn what is different about designing interfaces targeting mobile devices. You'll also review the new features in the latest versions of Oracle ADF Faces and how they can help you create better user interfaces for mobile web applications.

This session explains SQL Plan Management (SPM) mechanics and Plan Migration methods available with SPM. Some scripts to migrate Executions Plans using SPM are explained and shared. One of the scripts can become handy when you need to capture a good performing Execution Plan and associate it to the same or slightly modified SQL (for example, when the good plan only produces with a hint but you cannot modify the application).

Adaptive Cursor Sharing (ACS) is a feature available since 11g. It is enabled by default. ACS can help to generate multiple non-persistent Optimal Execution Plans for a given SQL, but it requires a sequence of events for it to get truly activated. This presentation describes what is ACS, when it is used, and when it isn't. Then it demonstrates ACS capabilities and limitations with a live demo.

Jeff will show you the things he thinks will save you the most time. Bonus: You might have a little bit of fun, too. These sessions are are highly interactive and appropriate for everyone, from new folks to advanced DBA types.

Fit and finish features of the Oracle data-modeling solution that make working with your models and designs easier and more enjoyable. A tips-and-tricks-type presentation, Jeff will discuss the features he gets asked about the most by users and show how to go from walking to running in the tool.

If you're building Oracle APEX applications, there's a good chance they are business-centric applications that will mostly be used by employees of your organization. The main goal of the user interface of these applications is to be functional and intuitive, not flashy and eccentric. Throw in the challenges of cross-browser compatibility and mobile support, and designing a user interface gets pretty complex. This session will outline some techniques and tools that can be applied when designing user interfaces for these business-centric applications. All solutions will be presented in a format that does not require advanced graphics design experience.

APEX is one of the fastest ways to build and deploy a web application based on the Oracle Database. But before jumping into this technology, it's important to have a basic understanding of how to do it securely.
Designed for those just starting out with or wanting to learn more about APEX, this session will outline the basics of the security constructs that are embedded in Oracle Application Express. It will cover how user management in APEX works, authentication, how to secure pages and components, and an overview of APEX's architecture.

In this case study, the attendees will see and learn how Oracle moved an internal APEX system to the Internet. Topics covered will be how to secure the data in the database with various methods APEX uses, such as context and VPD; how to use APEX authentication groups to secure apps, pages, regions, tabs, and even data from user to user; and an in-depth look at setting up the mid tiers. The mid-tier section will go into external and internal deployment plans and architectures using the APEX Listener on WebLogic as well as running the APEX apps in SSL. APEX Listener app authorization will also be covered. Last, go over securing your APEX app for the Internet, what tools and methods are used, load testing, and deployment concerns.

Securing an application - APEX or otherwise - is too often an afterthought, if it gets done at all. With an almost-weekly high-profile security breach, it is critical to spend time securing your application. But where do you start?
This two-hour deep-dive session will discuss and demonstrate what you, as an APEX developer, can do to ensure that your applications are as secure as possible. It will discuss which settings - at both the instance and application level - play an important role in securing your instance and applications. Different architectures and the pros and cons of each will be considered, and it will also show how to ensure that you're not introducing vulnerabilities when you write code.

As your APEX footprint grows and becomes more critical to your organization, so do things such as security, manageability, and support. These concerns should be addressed before they become too large or unwieldy to deal with. Thus, Enkitec has developed a set of tools and services to augment the security, manageability, and support of any size organization that has invested in APEX. This session will highlight and demonstrate Enkitec's APEX tools and support offerings. eSERT is an APEX application that identifies security vulnerabilities in other APEX applications. eFramework is an enterprise-class management tool used to better manage and monitor a suite of APEX applications. And lastly, Enkitec OnDemand Support provides customers with access to Enkitec's APEX experts for assistance with any APEX-related issue.

How do you get started with your APEX developments in order to avoid critical mistakes? By attending this session, you will take a glance at what should be done in terms of coaching, best practices, methodology, and more. We will present our approach based on more than nine years of APEX development with over 500 projects delivered to date. We will discuss the challenges of developing major applications in a collaborative environment and how to evaluate a migration from Oracle Forms to APEX. This is a great session for beginners, and there is lots to learn for experienced developers.

The Oracle Application Express tool includes methods to consume different web services. Did you know it could also serve web services? This talk will discuss methods for creating web services and compare them to commercial offerings. As web services are like any other web-based application, security must also be taken into account. There may be some risks to making too much information available. This will also discuss methods for securing web services and taking some of the mystery out of the process.
This will be a technical discussion showing both the capabilities of APEX as well as describing ideas that can be shared with other developers supporting the collaboration of the community.

The concept of cookies is simple, but the implementation can be challenging. Understanding when to use cookies to create an effective user experience is the goal of this presentation. When cookies are sometimes referred to as a security risk, it can also cause confusion. This session will cover the use of cookies within the APEX framework and compare and contrast the security risks with the benefits. Demonstration of effective use of cookie applications will be given and how to protect your cookies from being improperly used.

An introduction to building data-integration routines using FDME. Bridge the gap between FDM Classic and FDMEE, or get familiar with the features and functions of the new tool. Configure FDMEE, build a load location and mapping routine, and discuss practical tips/tricks along the way. Also discuss the ODI engine, basic scripting, and the approach for integration with a GL system.

This session will aim to provide the lonely Hyperion ranger with some tips and tricks to survive working solo vs. working as a team (both in a good way, of course). Examples of how to handle fire drills will be provided. Examples of ways to put out fire drills will be displayed. The session will allow you to gain insight and understanding with regard to how to cope under pressure and deal with your customers, your management, your cross-functional teams, and even yourself.

Exelixis, a biopharmaceutical company that produces cancer drugs, implemented Oracle Planning and rolling forecasting on a rapid schedule. This presentation describes in detail the implementation of driver-based rolling forecasting, workforce planning, a custom capital asset planning application, and customization of the approval process so human resources can approve new hires on a one-by-one basis.

Learn about Oracle Hyperion Workforce Planning -- what is "out of the box" and perhaps more importantly, what is not. This session presents Best Practices including at what level to plan, budget or forecast at: by employee, by position or a "hybrid" approach. Assets and Accelerators are shown including questionnaires used for requirements gathering and design documents. The "out-of-the-box" Workforce Planning module is demonstrated. Common configuration changes (and not so common ones) are shown using a case study approach from a number of client implementations. These configuration changes include: long range planning at a higher level, multi-year forecasts and additional dimensions/accounts.

Herbalife, operating in more than seventy countries, has adopted a phased approach in its journey to world-class EPM. The first leg was to implement Hyperion Planning, Hyperion Financial Management, and Essbase reporting. Later phases included calculating transfer profit, implementing cash-flow reporting and rolling forecasts, and an application to better analyze results and spot trends with commentary included. The analytic application automates calculations and uses flags for each normalization item to indicate which report it is part of and whether or not it is included in year-on-year analysis. This presentation will describe the phases and architecture, and help you roadmap your own journey.

1. See what new innovations and BI product releases have been delivered in the last year.
2. Understand what key trends are driving Oracle's BI roadmap.
3. Learn what future development is planned for all of Oracle's BI and Analytic products.

Over the years, many Essbase customers and partners have customized their applications with the Essbase Visual Basic, or "VB" API. As Microsoft support for VB ended over eight years ago, the writing is on the wall for those customers still running applications written using the VB API, and the logical choice is Java and the Essbase Java API. Attend this session to learn the basics of how to get started with the Java programming language and with the Essbase Java API.

The Next Generation Outline Extractor is a the follow-up to the classic OlapUnderground Essbase Outline Extractor that is used by thousands of Essbase customers. This session explores some of the new capabilities of the Next Generation Outline Extractor, including command line operations exports directly to a relational database. Attend this session to learn how to leverage this free utility in your company.

Essbase and Java are key components of the Oracle Fusion strategy. As a result, the Essbase Java API is now the lead API for Essbase. Attend this session to learn Essbase Java API tips and tricks from one of the world's experts in the Essbase Java API. This will cover some of the common issues developers encounter when writing Java API applications including Essbase data retrieval and update operations, member operations, custom calculations, and procedures for updating Java API applications to new versions of Essbase.

This panel discussion, featuring experienced financial executives from Wells Fargo, Kroger, and other Dodeca customers, will focus on how their companies use and manage the popular and ubiquitous spreadsheet format to provide the user interface for planning, reporting, and analysis applications without the risks and inefficiencies normally associated with distributed Excel workbooks. The panel will discuss the implementation of the Dodeca Spreadsheet Management System at their companies focusing on how Dodeca mitigates risk, improves user productivity, and expands user/management acceptance of their systems.

Hyperion Planning 11.1.2.3 now offers support for ASO databases, but are you ready to implement this exciting new feature? Are you aware of the limitations? Do you have tested workarounds? Can you effectively set the expectations of your end users? This session will provide an implementation roadmap that will highlight:
* A live demo of Hyperion Planning 11.1.2.3 with an ASO Plan Type
* Implementation steps and best practices
* A review of Planning's ASO limitations
* Creative workarounds for these limitations
* How to correctly set end-user expectations
Attendees will leave this session with a solid understanding of Planning's new ASO features and limitations as well as a host of best practices. Attendees will receive documented code samples and a full LCM export of the demo application.

This session will cover a creative solution to implementing FCM at a large independent oil and gas company. The solution includes simplifying the standard configuration to plan FCM-related closing tasks, account reconciliations using ARM, and application integration.

In this session, travel through the journey from legacy systems to ADF Mobile. The challenge was to build an app that had all the bells and whistles of a cutting-edge mobile app, including gestures control, graphing, barcode capture, camera, and notifications but also is backed by existing legacy business logic as a web service. Go through the development process from defining the taskflows and business processes to developing the web services and designing the UI. Then learn tips and tricks, including demos both of the ADF Mobile development process and the final product. As more of your users begin to demand mobile solutions, this session will guide you on how to begin your Mobile journey.

Hearing conflicting reports about the future of Oracle Forms? In this session, we hope to set the record straight. Meet with some of the leading Oracle Forms experts for an open Q&A on the if, when, and why of migrating away from Oracle Forms including the options, costs, risks, and benefits. The Oracle Forms product manager will briefly discuss Oracle's vision for the future of Oracle Forms including: Can you squeeze a few more years out of your systems, or do you need to migrate to a new technology today? Then the panel will give thoughts on if you must migrate, then which next-generation development technology should you choose? Panelists will do their best to represent all major options, including Stay in Forms, move to: Java, Oracle ADF, Oracle APEX,.NET, and even new third-party development tools.

"If you can do it in SQL, use SQL." But sometimes even the very powerful version of SQL that Oracle provides is not enough and you need more, like loops, conditions, etc. If you can make the output of a function act like it's a table, then you can use it in SQL and have access to all of the power PL/SQL provides. After this session, you will know how to create functions that can be used as tables in SQL.

Find out how to build out your own personal developer/DBA sandbox in this three-part exercise. Get help configuring your environment and installing your software. Some of the best minds in the Oracle universe will help guide you through all the necessary steps.

One of the keys to successfully managing and controlling information delivery is the ability to efficiently manage master data (hierarchies and dimensions). You need to ensure one common hierarchy between your various systems -- from ERPs to data warehouses to Hyperion. During this session, Verizon Wireless will discuss how it uses Hyperion Data Relationship Management to meet its enterprise-wide master data management and governance needs and how Oracle Data Relationship Governance provides essential change management and data quality remediation workflows, captures business changes, and applies them with consistency across transactional and analytical system silos. The session will also cover an overview of these applications, an introduction to the now fully web-based Hyperion Data Relationship Management, review key DRM features, and demonstrate how DRM addresses financial compliance challenges across your enterprise.

Planning on the go is a reality now with Planning capabilities being supported on tablets and phones. With a slick mobile-friendly user interface, planners and executives can now have constant visibility to plan information and act on the go based on current insight. All familiar end-user Planning capabilities are being enabled on mobile. This session will also touch on the other exciting projects that are underway within the Planning Development team.

Oracle Planning and Budgeting Cloud Service is one of Oracle Cloud's software as a service (SaaS) marquee offerings. It offers organizations the best in class Oracle Hyperion planning and budgeting solution, re-engineered to work within Oracle's Public Cloud Service. The robust functionality of a world-class solution offered with the benefits of a cloud offering will help organizations improve their decision-making capabilities while deploying quickly and reducing costs. This session provides an overview and demo of this exciting new Planning Cloud offering.

The vast majority of organizations who implement one or more of Oracle's Business Intelligence applications end up designing their own dashboards, analyses, and visualizations. During this informative session, we will evaluate several prepackaged dashboards and offer suggestions for extensions and improvements, review dashboard design best practices, and demonstrate cutting edge visualizations. Oracle BI 11g is perhaps the most complete and comprehensive Business Intelligence platform technology, but because it is so powerful and flexible, careful consideration must be given to the visual interface design in order to maximize investment returns. You'll learn best practices in dashboard design along with specific dos and don'ts. You'll see how to customize dashboards using skins, style sheets, and HTML. You'll understand how to extend OBI's native visualizations with Java script and advanced visualizations. You'll see how to adapt and modify your current dashboards, visualizations, and analyses for use with mobile devices such smart phones and tablets.

Everyone knows they should be integrating data mining and predictive analytics, but it can be challenging to discuss the merits of a project before team members share a common understanding of data mining and predictive analytics. This session will share a detailed outline of the best-practice methodology for getting clients started with Oracle Data Mining and Oracle R Enterprise, how we develop that common understanding using "live" software, and how to facilitate brainstorming sessions to identify projects with the highest ROIs. It will share excerpts from the three-day start-up process to create a common set of skills and knowledge through hands-on learning with live software and complemented by expert guidance for placing tools and algorithms within a broader analytics context.

As project portfolios grew, Biogen Idec was challenged with finding a transparent, efficient solution to simplify capital project planning. To help increase data visibility and user efficiency, Biogen Idec elected to implement Oracle's Project Financial Planning application (PFP) to help streamline project planning.
This case study will cover the technical design of creating the Project Financial Planning application, which features and functionalities were used and maximized, and the benefits and challenges of implementing the Project Financial Planning application. Additionally, this session will discuss application customization, including the adding of two custom dimensions and integrating the application with another Planning application.

It has long been accepted that classically designed dimensional models provide the foundations for effective Business Intelligence applications. But what about those cases in which the facts and their related dimensions are not, in fact, the answers? Introducing the Reverse Star Schema, a critical pillar of business-driven Business Intelligence applications. This session will run through the whats, whys, and whens of Reverse Star Schemas, highlight real-world case studies at one of the nation's top-tier health systems, demonstrate OBIEE implementation techniques, and prepare you for architecting the complex and sophisticated Business Intelligence applications of the future.

This session will focus on the various Financial Reporting tools from Oracle (FR, DM, FRCS [new], Smart View, OFMA) and help explain the role for each and the benefit they provide. Tips and tricks will also be worked into each discussion.

This session shows how to customize Fusion Applications, including multiple techniques for customization. It demonstrates runtime customization using the composers and design time using JDeveloper. The session will also teach when to use each of the methods.

Automating your Hyperion processes can make working with Hyperion Enterprise Performance Management environments much easier. Many people automate their Essbase calculations, dataloads, and backups. This session will review that topic and go far beyond it.

Amazon Web Services has offered the Relational Database Service (RDS) as part of their cloud offering since 2011. RDS provides easy to deploy, on-demand database-as-a-service for MySQL, Oracle, and SQL Server. When you compare it to essentially any other method of hosting and licensing Oracle, RDS seems to have a variety of really appealing qualities. The question you might have is: "Is it better for me than EC2, managed hosting or self-hosting?" Since no solution is perfect for every deployment, it is helpful to explore the factors that can help you decide if RDS/Oracle is a better fit your needs than other hosting approaches.

You've discovered the many ways that APEX_DEBUG, Logger, and P_TRACE can help you troubleshoot and improve your APEX application in your development and test environments. Now that you are reaping the benefits of improved software quality, you want to take it to the next level and diagnose problems in your running production system. But your production environment is run-time only and debugging is not active. How do you use these features to the fullest with the least risk to the running production system?
In this presentation, you will learn to build an APEX application to monitor, debug, and trace your user's sessions in production. You will learn to create a UI to safely enable, disable, and control the debug characteristics of the application and the sessions and to fully utilize the captured logs.
This presentation will include a demonstration of our own APEX Monitor application. You will see how your error messages and custom instrumentation can be controlled and examined in real time.

The cloud enables rapid development and deployment by eliminating costs and constraints around hardware while also offering global scale. Microsoft and Oracle have partnered to enable Oracle
customers wanting to embrace the significant benefits of cloud to run Oracle software including Java, WebLogic, Oracle, Oracle Web Server, and Oracle Linux in a certified and supported manner on Azure. In this session, learn how to build and deploy Oracle solutions on Azure.

As Oracle has ceased support for the Add-In and is set on Smart View, the biggest challenge does not normally come from IT, but rather the functional end users. The questions are usually these: Do we *have* to switch to Smart View? Will my spreadsheets need to be updated? Will it be harder to get data? Are you SURE we have to migrate? This session will review change management for the functional set of users to make their transition easier for them, as well as for IT. These lessons are derived from actual change management engagements and include what worked and what didn't so that the right mix of training can be presented to the end users.