Check out the presentations listed below.



Data Train: ALL ABOARD! Essbase Drill, OBI, and Big Data
Gary Adashek , General Electric
Topic: BI & Reporting - Subtopic: OBIEE

Oracle Business Intelligence (OBI) is a powerful toolkit for users to drive analysis, reporting, dashboards, and more. But what if there is not a native adapter for the data set you are interested in exploring, federating, and stitching together in OBI? And what if you also wanted to enable Essbase Studio Drill-Through reports to this Big Data? In this presentation, I will provide a solution that includes, Big Data (Pivotal Greenplum), OBI, and Essbase Studio Drill-Through reporting.

This presentation will take a detailed look into the architecture and development that enabled the successful execution of this solution. It will give a step-by-step walk-through of Essbase Studio Drill-Through reports, both Relational and URL types as well as the setup of OBI Subject Areas used to enable the federation of data to a non-Oracle Big Data source.

The benefits that users have received from this work are:
• OBI Subject Areas
• Essbase Studio: Drill-Through report types
• The financial data visibility from General Ledger to Journals to Sub-Ledgers
• Data drill-ability plus data threading via OBIEE integrated with Greenplum Big Data

Back to Top
Look Inside the Locking Mechanism
Liron Amitzi , DBAces
Topic: Database - Subtopic: Other Database

Locking issues have always been an interesting topic. This is one of the most important features that maintain the integrity of our database.

Why do we need the locking mechanism? What locking modes and types are there? What does Oracle lock during DML and DDL operations? How are constraints and indexes affected by and affecting locks? These are some of the questions this session handles. It also includes live demos for some advanced and interesting scenarios and shows how to query relevant data dictionary views.

Back to Top
Black Belt Techniques for FDMEE Admins and Developers
Francisco Amores , Infratects
Topic: EPM Data Integration - Subtopic: Data management/integration

Willing to take your application to the next level?

FDMEE is a product that can be easily customized to meet any requirement, regardless of its complexity. You may know what you want to do but can't find the right approach.

What about adding a creativeness layer on top of your FDMEE knowledge? The solution may be closer than you think, either using standard functionality or scripting.

In this session, we will cover some nice techniques, tips, and tricks that will give you a helping hand to get the most out of FDMEE.

Using locations for admin purposes, enhancing batch management with custom scripts, or using lookup dimensions and SQL map scripts to define standard multi-dim maps based on target dimensions are just some of the techniques we will talk about.

Don't miss this session, regardless of your level, if you want to see how standard functionality can turn into simple and powerful solutions.

Back to Top
Exalytics-Compatible: Automate Your Linux Backups
Bernard Ash , EPM Clarity
Topic: Essbase - Subtopic: Administration

Let's automate and schedule the backup of our large Essbase Linux deployments – including Exalytics. Leveraging LCM is great, but we should really back up more such as file system backups, MAXL parallel data exports, and our Essbase partition definitions that cannot currently be backed up using MAXL or LCM.

Back to Top
Is Your EPM Implementation Falling Behind? The Top 11 Signs
Joe Aultman , interRel Consulting
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

In the EPM world, there is a constant need to keep moving forward to better and better practices. Applications and processes that used to be sufficient become outdated and stale. There are many reasons implementations at different companies may begin to lag, and environments that were once cutting-edge become antiquated. Come to this session to find out how to recognize when you are falling behind so you can take action. Find out how to make certain your EPM and BI practices are up to today's standards so you can keep the competition at bay.

Back to Top
Don't Worry, You Can Still Get Geeky with Planning Cloud
Joe Aultman , interRel Consulting
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

As with all of their cloud products, Oracle wants EPBCS to be friendly to users and administrators in the business community, reducing the level of technical expertise required to implement and maintain the application. Techies everywhere are left to wonder what role is left for them. This session provides the answer. From new techniques for creating custom functions to tweaking the user interface to automating processes and data flows, you'll see there is still plenty for the geeky among us to do.

Back to Top
APEX 5.1: The Smaller New Features You Can't Afford to Ignore
Dietmar Aust , Opal-Consulting
Topic: Application Express - Subtopic: New Release

With every new release of Oracle APEX, everybody talks about the major (so-called marquee) features such as Interactive Grids, Master/Detail/Detail, the new Charting Engine, and the enhancements to the Page Designer.

But aside from that, typically over 100 smaller enhancements have been added to the product that make our lives as APEX developers a lot easier and are really valuable to learn about; typically they are not talked about that much.

These features have been analyzed by talking with the APEX team and also by comparing the differences in the data model and APIs between version 5.1 and 5.0.

These smaller features include the new Proxy Authentication (with ORDS), the change in the architecture (moving to a JSON-based page rendering/submission that removes certain restrictions such as the number of items per page), javascript apis for notifications (apex.message), improvements in the modal dialogs, the javascript apis for the interactive grid, and many more.

Back to Top
Beginner Session
Dietmar Aust , Opal-Consulting
Topic: Application Express - Subtopic: Other Application Express

Beginner session per Francis M

Back to Top
Integrating Raspberry Pi Sensors with Data Visualization
Justin Baker , Oracle Corporation
Topic: Data Visualization & Advanced Analytics - Subtopic: Oracle Data Visualization

The introduction of IoT devices such as the Raspberry Pi and services such as IFTTT have disrupted whole industries overnight and spawned an army of machines gathering sensor data and home automation capabilities to better our lives for a fraction of the cost before. In this session, we will explore how integrating IoT device sensor data with Oracle Data Visualization and IFTTT can help us hold both Mother Nature and our ISPs accountable in this new disruptive landscape.

Back to Top
SQLcl: A Modern Command Line Interface to the Oracle Database
Galo Balda , State of Texas
Topic: Database - Subtopic: DB Tools

SQLcl is a Java-based command line interface that takes advantage of SQL Developer’s scripting engine to deliver a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and usability enhancements that have been missing for a long time. Come to this session to see a demo showing the new inline editor, query history, aliasing, result formatting, DDL generation, JavaScript support, and other exciting features that set SQLcl apart from its predecessor.

Back to Top
Close Manager: Your Interactive Project Manager
Catherine Baldasty , Global Business Intelligence, LLC
Co-presenter(s): Laura Potts, Global Business Intelligence, LLC
Topic: Financial Close - Subtopic: Financial Close Management (FCM, ARM, SDM)

Are you sick and tired of maintaining your close through post-it notes and individual checklists? Don’t miss your delivery to senior management because you don’t know about a bottleneck in your close process. Meet Close Manager, your interactive project manager. Watch as we eliminate those bottlenecks by creating schedules with email notifications where progress and completion can be managed from a central dashboard. Let us show you how to make FCM rival all other project tools combined.

Back to Top
Campfire Stories: Tips for Making Life Easier for the Financial Close Administrator
Christopher Barbieri , Finit Solutions
Topic: Financial Close - Subtopic: Other Financial Close

Life for the financial close administrator can be pretty rough at times. As they say, “necessity is the mother of invention," and so we invite you to gather around, pull up a seat and listen to true stories from folks like you as they share tips and inventions that make their lives easier. Stories cover a range of home-made utilities, macros, tips for using Notepad++, novel ideas with custom member lists, dashboards in Smart View, interesting uses for WriteToFile, and more. We hope the tips from this Deep Dive session will inspire you and make your life easier too!

Back to Top
Backstage Pass: Lesser-Known Features for Easier HFM Management
Christopher Barbieri , Finit Solutions
Topic: Financial Close - Subtopic: HFM

Oracle ACE Chris Barbieri takes you backstage to work with some lesser-known HFM administrator features. We’ll investigate the Insights module, review common System Messages, and make use of the Admin mode while performing application updates. We’ll discuss a few of HFM’s system settings to control HFM’s behavior and explore the Module Configuration. Finally, we’ll cover Shared Services logs and HFM’s data audit log for tracking user activity and data changes. Please note that although some of these features are particular to 11.1.2.4, many of them apply to earlier versions.

Back to Top
What Would Happen If I Did ... in HFM? Greatest Hits and Disasters
Christopher Barbieri , Finit Solutions
Topic: Financial Close - Subtopic: HFM

Ever wonder what would happen if you changed the currency on an entity? Or switched an account to be IsCalculated? Or renamed an account? Have you made metadata changes and loaded the file without the check integrity flag? Oracle ACE Chris Barbieri revisits these and other HFM topics, taking a Mythbusters approach to defining the myths, setting up the tests, and explaining what happens "under the hood" so you can more deeply understand what would happen if I did ... in HFM.

This is a compilation of popular topics from three "What Would Happen..." presentations and is geared toward HFM administrators and power users, though all are welcome.

Back to Top
AMC's EPM M&A Factory
Wayne Bates , AMC Theatres
Co-presenter(s): Chad Hatcher, AMC Theatres
Topic: EPM Business Content - Subtopic: Case Studies

In 4Q 2016, AMC Theatres will close two acquisitions, Carmike Cinemas and Odeon Cinemas. The acquisitions will more than double the number of theatres we manage making AMC the largest exhibitor in the United States and the world. Attend this session and learn how we deployed HFM, FDMEE, DRM, DRG and Planning to streamline consolidations around the world to satisfy financial reporting, data governance, and compliance requirements. M&A is a key strategy for AMC. We expect the acquisitions to continue. We will share what we've learned and how we'll approach our next one.

Back to Top
Hybrid Essbase in the Real World: A Production Example with Maintenance-Free Currency Conversion
Greg Beaton , TGG
Co-presenter(s): Nikhil Virmani, ATOS
Topic: Essbase - Subtopic: Essbase-related technologies

What’s Hybrid Essbase all about? What can it do, and what can’t it do? What do I need to know to both implement and use it? Should I use it? Learn how we turned a poorly performing ASO cube into a speedy Hybrid cube, adding ease of use with access to the BSO calculator while retaining fast dynamic aggregations.

Learn the advantages and disadvantages of the new Hybrid Essbase Engine from a company that has been using it in production for almost a full year. Both the Essbase Architect and Client Administrator will be on hand to discuss how Hybrid Essbase performs in the real world.

We will discuss hybrid cube design and our evolution of getting there. Learn about our 16-dimension cube with maintenance-free custom currency conversions using the BSO Calculator that aggregates instantaneously. We will touch on the benefits and pitfalls of using Hybrid and discuss our lessons learned. If you are thinking of going Hybrid, this session will reveal some of the secrets you need to know.

Back to Top
Looking After the Pennies: Unlocking the Detail Behind the Data
Philip Benz , Peloton Group
Co-presenter(s): Paul Hurley, Cumberland Farms
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Drill through capabilities unlock endless opportunities for analysis to the lowest grain of detail. Clients have been clamoring for this capability ever since its introduction into PBCS. Come see how Cumberland Farms is able to use drill through capabilities to perform more robust analysis than ever before.

Back to Top
The HFM Value Dimension in Four Easy Concepts
Keith Berry , The Hackett Group
Topic: Financial Close - Subtopic: HFM

If the standard explanations of the value dimension leave you confused, this session is for you.

The value dimension makes perfect sense once you understand the underlying operation of the HFM consolidation engine. We'll break down that information into four basic concepts, each of which explains an (otherwise perplexing) aspect of the value dimension. We'll skip the abstract diagrams and learn about these concepts with pictures of dogs, dice, and other everyday things. You'll walk out of the presentation with a complete understanding of the value dimension and a deeper appreciation of how things really work in HFM.

Back to Top
Understanding HFM System Tables
Keith Berry , The Hackett Group
Topic: Financial Close - Subtopic: HFM

The HFM repository is not designed to be accessed directly, so there is little official documentation on how it works. This presentation will try to shed some light on the inner workings of the HFM database.

In the first part of the session, we'll cover the basics of the HFM repository and the architecture of the primary table sets for storing data, journals, and metadata. In the second part of the session, we will go through a cookbook of useful queries for troubleshooting errors, extracting hierarchies, and analyzing audit data.

The presentation is for HFM administrators/developers and integration specialists who use HFM as their data source. Some knowledge of relational databases will be helpful, but the material will be useful to anyone looking for a greater understanding of how HFM works.

Back to Top
Diagnosis Close: How Vertex Pharma Uses Planning, Essbase, and OBIEE to Close the Books
Thomas Blakeley , Performance Architects
Co-presenter(s): Michael Bender, Vertex Pharmaceuticals
Topic: Planning - Subtopic: Design

Planning isn't just for budgets anymore!

Hear how Vertex Pharmaceuticals used Planning, ASO native Essbase Cubes, and OBIEE to assist with revenue accounting and the tracking of adjustments such as fee calculations and revenue recognition in a single place. Utilizing Hyperion Planning, ASO Essbase, and OBIEE, accounting users are able to review invoicing and sales data fed directly from third-party logistics companies located around the world before adjusting revenue dates, inputting fees, and making custom entries – all through Planning. After working through the Revenue Task List, users can initiate data warehouse jobs directly from Planning Task Lists that push data to a reporting application and OBIEE for review across additional dimensions and currencies.

This all follows a workflow built using Task Lists that guide users through the revenue accounting process. This entire process supports the final revenue numbers booked directly into EBS and also supports revenue analytics for the entire organization.

So, come to our session!

Hear about an end-to-end solution involving more that just one Oracle EPM and BI product – and hear about a solution that actually integrates them.

Hear about how OBIEE can report directly on data found within Planning and Essbase.

Hear about a Planning cube with seven dimensions getting transformed into an ASO Essbase application with 16 dimensions – and an OBIEE model with even more columns for reporting.

Hear how end users are able to get access to summary revenue numbers and then drill down to the detail if they feel the need. Hear the process by which we made it happen – from stakeholder meetings at the beginning through to our production rollout at the end.

Finally, don't just hear it from the consultant but also hear from the customer, as we both share our tips and tricks and what went well.

Back to Top
Elevating Your Workforce Planning Solution to the Cloud
Nicholas Blazosky , TopDown Consulting
Co-presenter(s): Ludovic De Paz, TopDown Consulting
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Thinking about elevating your organization’s Workforce Planning Solution? Want to see a detailed demo of the capabilities of the latest version of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) SWP (Strategic Workforce Planning) and Workforce planning modules? What has changed since the days of deployment in on-premise, and how can you be leveraging the enhanced functionality for your organization? Learn the differences between an on-premise deployment and strategies for getting you to the cloud in no time. The demo will have a unique San Antonio twist to get you in the spirit of being in the heart of South Texas. Join seasoned WFP architects and Kscope speakers Ludovic De Paz and San Antonio native Nicholas Blazosky for this informative deep dive into the newly enhanced world of Workforce. 

Back to Top
Shootout at the Public Cloud Corral: Oracle vs. Amazon vs. Google vs. Microsoft
John Booth , METAVERO
Topic: EPM Infrastructure - Subtopic: Cloud and Hybrid Infrastructure

How do these Infrastructure as a Service offerings stack up in terms of features,
price, and performance? We will set up an all-in-one Hyperion environment including Planning and HFM on four major public cloud providers and discuss ease of use, management, and how a Hybrid cloud environment integrates with your on-premise systems.

Back to Top
Essbase Dashboard Smackdown!
John Booth , METAVERO
Topic: Essbase - Subtopic: Essbase-related technologies

Confused about which solution to pursue for Essbase visualization? We compare Web Analysis vs. Tableau vs. Oracle BI vs. other contenders in performance, prettiness, and power. Which tools make sense to embrace?

Back to Top
Programming (Flexible) Automation to Use Processing Cubes (and Other Automation Tricks)
William Bradstreet , Bradstreet Business Services
Topic: Essbase - Subtopic: Other Essbase

Essbase must be automated, but most Essbase automation consists of a MaxL script within a .cmd/.sh file. But that’s crude, inconsistent, and a maintenance nightmare. A better approach is a parameter-driven automation framework that dynamically spawns batch streams, applies the same processes consistently, and – because the actual code base is small – centralizes maintenance. As a bonus, this ease of development streamlines the migration from development to quality to production. Join Bill Bradstreet as he describes, demonstrates, and dives into a programming methodology and the code behind it to show how you can bring the power and flexibility of this approach to your system today.

Back to Top
Why IoT and Big Data Need Data Relationship Management
Greg Briscoe , Razza Solutions
Topic: EPM Business Content - Subtopic: Other EPM Business Content

The Internet of Things (IoT) is expected to offer advanced connectivity of many different kinds of devices, systems, and services that go well beyond just machine-to-machine (M2M) communications. IoT covers a variety of communication protocols, industry domains, and business applications. The interconnection of these devices and other smart objects is expected to make an impact in automation and integration for almost all types of business. Both the private and public sector will benefit from the IoT, and we should see further enabling of more advanced decision-making applications.

In this session, we will learn how Oracle's Data Relationship Management can help you transform and report on the large volume and velocity of data that is streaming through the IoT into the enterprise. This is big data, and we will help you understand how and why Data Relationship Management is a critical part of making data collected from IoT useful.

Back to Top
Have You Sampled the Packaged Apps?
Paul Broughton , APEX Evangelists
Topic: Application Express - Subtopic: Other Application Express

APEX 5.1 has over 35 packaged applications, with many showing the very latest APEX enhancements. Many of these may be new to developers, and this presentation will discuss and demonstrate some these in use such as the Interactive Grid and Jet Charts. This presentation will dive into a number of packaged applications, looking for some of the most innovative and powerful features. It will demonstrate the basics such as simply installing and managing the packaged applications.

After demonstrating some of these unique features, the presentation will build real-life examples into custom APEX applications.

Back to Top
Data Streaming and Analytic Microservices
Stewart Bryson , Red Pill Analytics
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

While traditional data warehouses excel at sourcing data from enterprise applications, they usually fail at handling the volume, velocity, and variety of data for modern analytics applications relying on big and fast data. Instead of modeling these data sources into a system that doesn't fit, let's apply a new software design pattern to analytics: microservices. Microservices are small, independent applications – building blocks that provide only a distinct subset of functionality – that can be stacked together to build an end-to-end platform.

In this presentation, we'll explore using Apache Kafka and the Confluent Platform 3.0 as the data streaming hub for ingesting data bound for downstream analytic applications: an enterprise data warehouse, a Hadoop cluster for batch processing, and lightweight, purpose-built microservices in the cloud or on-premises. Experience the next generation of analytic platforms.

Back to Top
From Bogeys to Birdies: All You Need Is Drivers
Ryan Burghauser , SC&H Group
Co-presenter(s): Nick Scott, SC&H Group
Topic: Planning - Subtopic: Optimization

When a Fortune 500 hospitality company wanted improved forecasting and budgeting accuracy, it turned to a customizable driver-based approach. The hard part was coming up with a model that suited a 2,400-person user base. We had to tap into the creativity bank to allow users the ability to update their calculation methods on demand and already have the related drivers populated in the application. The reliance upon drivers shifted users away from focusing on the end revenue and expense dollar figures and turned the attention toward how did we get there.

Back to Top
A DRM Journey: A N00b's Perspective
Kris Calabro , JCI
Co-presenter(s): Natalie Delemar, Ernst & Young
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Not all that long ago, DRM was a mystery: No one really could agree on what the acronym DRM spelled out – was it Data Relationship Management or maybe Dimension Relational Manager or maybe something else – or understand how the tool worked or even appreciate DRM's role in the EPM ecosystem. Today we know what DRM means (Data Relationship Management); have mastered (sort of) its features, functions, and intricacies; and can truly understand the value it brings in managing metadata across an Oracle EPM implementation's many tools and applications. Join Tyco EPM administrators as they review the transformative role of DRM, the challenges faced and solutions derived, and why every new Tyco application has DRM at its core.

Back to Top
Going to the Grid: What the APEX 5.1 Interactive Grid Means for You and Your End Users
Karen Cannell , TH Technology
Topic: Application Express - Subtopic: New Release

The long-awaited APEX 5.1 Interactive Grid region is here – but what does it mean to you and your end users? Need some practical guidance on when, why, and how to adopt the Interactive Grid region type? This session is for those who have seen the introductory demonstrations, are looking to upgrade to APEX 5.1, and need some advice. Does the Interactive Grid replace Interactive Reports? No more Tabular Forms? This session answers practical functional and technical questions raised by this new region type:

• When and why should I upgrade existing regions to Interactive Grid?
• Is there an upgrade wizard?
• What features will I gain; what features will I lose?
• What about customizations – will they upgrade?
• How does an editable Interactive Grid compare to my existing tabular form?
• Which features must still be manually written? Do I still need to write all that collection logic?
• How can I customize appearance?
• How can I add dynamic actions?
• Can I extend the Interactive Grid functionality?
• Will my end users like it? What about data entry users?
This session compares and contrasts Interactive Grids with the Interactive Reports and tabular forms we are familiar with. We will pay particular attention to maintaining or replacing features and common customizations in existing applications: checkboxes, 32K limits, cascading select lists, row-level validations, interactions between columns, and navigation between fields. How does the Interactive Grid region measure up? Should you upgrade all your Interactive Reports and tabular forms now?

Attend and find out.

Back to Top
Track-a-Watt: Modify a Power Usage Tracker to Log Your Power Usage in a Database
Blaine Carter , Oracle Corporation
Topic: Database - Subtopic: DB Tools

If you're like me, you use way too much power and you’re not quite sure where. Tracking your power usage is a great start, but analyzing the data is often easiest when it's in a database. Having to type it in by hand would be a pain; let's void a warranty instead!

Back to Top
On-Prem to EPM Cloud (Hybrid) and Cloud-Only-Based Integration Solutions
Michael Casey , Oracle Corporation
Topic: EPM Data Integration - Subtopic: Data management/integration

This session will explain the integration options for EPM cloud services, when source data resides on-premise or in the cloud. Examples of hybrid integration will be shown where data from on-prem sources such as an ERP or data warehouse can be loaded to the cloud, drilled from the cloud back to on-prem, and extracted from the cloud for use in other on-prem applications. In addition, solutions to move data between EPM Cloud services and between the Fusion GL Cloud and EPM services will be explained. Details related to current features and product roadmap will also be provided.

Back to Top
Securing Oracle APEX: Cross-Site Scripting
Nathan Catlow , Recx Ltd
Topic: Application Express - Subtopic: Other Application Express

Understanding the areas in Oracle APEX that typically result in security problems is essential to building robust solutions. This talk will take an in-depth look at cross-site scripting, undoubtedly the most prolific problem facing APEX applications today. We will be demonstrating the security impact of insecure applications as well as required fixes based on real-world examples.

The power of cross-site scripting attacks are regularly underestimated. In this session, we will demonstrate complex cross-site scripting attacks against APEX applications and use API calls and item settings to ensure the data within your APEX applications remains secure.

Back to Top
Hyperion Disaster Recovery: Prepared for Sharknado or Whatever
John Ceynar , Halliburton
Topic: EPM Infrastructure - Subtopic: Other EPM Infrastructure

Hyperion applications are often a critical component of a company’s closing and reporting process and needs to be quickly recovered in the event of a disaster. I’ll review options for disaster recovery and talk about restoring specific Hyperion components and shortcuts to be up and running faster.

Back to Top
Cloudy with a Chance of PBCS: Tips and Tricks for Migrating On-Premise Oracle Hyperion Planning to Oracle Planning and Budgeting Cloud Service (PBCS)
Mohan Chanila , Performance Architects
Co-presenter(s): Chuck Persky, Performance Architects
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Many organizations have made the switch from an on-premise Oracle Hyperion Planning solution to Oracle Planning and Budgeting Cloud Service (PBCS). This move allows them to take advantage of the benefits that exist in an Oracle SaaS model and some of the newer features available in PBCS. However, many other organizations, while very interested, are hesitant to make this leap, in fear of the unknown and the potential process involved in migrating to this model. In this session, you will learn from industry experts about a variety of considerations, tips, and methodologies utilized in planning and executing this type of change. Specifically, this session will explore the dynamics of this migration through real-life examples, including the steps for assessing the current application(s), decisions surrounding a "lift and shift" versus a "rebuild" approach, the process for executing the migration, and how to acclimate system administrators and users to a PBCS (cloud) methodology and interface. Additionally, this session will explore the facets of data integration and security; how these capabilities may be the same or different than the current on-premise model; and how to build a strategy to successfully create these capabilities in PBCS. Please join us in navigating from the ground to the cloud.

Back to Top
Public Sector Financial Reporting Is a Breeze as a Government Agency Takes a Walk in the Cloud with PBCS and EPRCS
Jay Chapman , Vertical Edge Consulting Group
Topic: BI & Reporting - Subtopic: Financial Reporting

By now, we know all about the wonders of Oracle's Enterprise Performance Reporting Cloud Services and Planning and Budgeting Cloud Services. But have you seen how they are both utilized in the public sector? Join us to learn how Bell County went from Excel spreadsheets to successfully creating their comprehensive annual financial report by using Oracle PBCS and EPRCS. Along with the case study, the session will also include best practices for integrating EPRCS and review the latest features from the most recent update.

Back to Top
How to Successfully Set Up an HFM Environment for a New Spinoff Company
Ray Chontos , Finit Solutions
Co-presenter(s): Kathleen Marschak, Adient
Topic: Financial Close - Subtopic: HFM

Spinoffs are a common practice, as companies continually adapt to new and different markets. In 2016, Johnson Controls – a company with one of the largest and most complex HFM environments in the world – spun off a $17B portion of its business into a new, independent company. Learn how that newborn company, Adient, successfully designed and deployed HFM applications to meet revised reporting requirements, and satisfy a new CFO and over 1,300 HFM users. This session will walk through the critical actions and lessons learned as the JCI HFM team members transformed their systems and themselves into Adient and helped this huge and hectic spinoff to roll out as smoothly as a stroll down the River Walk.

Back to Top
Explaining the Explain Plan: Interpreting Execution Plans for SQL Statements
Maria Colgan , Oracle Corporation
Topic: Database - Subtopic: DB Dev

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task, even for the most experienced DBA or developer. This session examines the different aspects of an execution plan, from selectivity to parallel execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan.

Back to Top
The Future of Database
Maria Colgan , Oracle Corporation
Topic: Database - Subtopic: DBA

Database architectures are fundamentally changing due to new technologies and new requirements. Organizations must understand and embrace these transformations to thrive in the future. This has never been more evident than with Oracle Database 12c, which has been the most rapidly adopted release in over a decade. This session provides a technical introduction to what's new in Oracle Database 12c and explains how you can embrace each transformation while preserving your existing investments.

Back to Top
Empowering Management Reporting via Oracle Essbase
Dave Collins , The Hackett Group
Topic: Essbase - Subtopic: Design

Microsoft XL remains the leading business tool for analysis, management reporting, and even ETL! Why? Well, XL is easy and everyone knows how to use it – or do they? In today's ever-changing world, speed-of-thought analytics ensure success. Data modeling via OLAP is certainly one way to empower users. During this session, you will see how easy it is for business users to model, update, and perform analyses with XL and more formalized reporting tools. You will also learn the best-practice approach for enabling both self-service and structured reporting.

Back to Top
Advanced Calculation Techniques: Going Beyond the Calc Dim
Topic: Essbase - Subtopic: Calculation

Join us as we take a deep dive into some of the ways the Essbase calculation engine can be used to solve complex business problems, all derived from real-life examples learned from the school of hard knocks. Techniques include combining spreadsheets and calc scripts to compute variances for hundreds of member combinations, designing recursive calculations to analyze a product’s components, and building a structure that allows user input to any level of a hierarchy. We’ll review the different methods of writing allocations, ways to optimize your parallel calculations, and block creation techniques and calculation features you are told “never to use” but might want to use anyway. This presentation is intended for intermediate Essbase developers, but all are welcome.

Back to Top
Velcro and FDMEE: One Data Management Solution for EPM Cloud and On-Prem Systems
Doug Correa , Peloton Group
Co-presenter(s): Michael True, Velcro Group Corp.
Topic: EPM Data Integration - Subtopic: Data management/integration

When Velcro embarked on its EPM journey, it elected a hybrid approach, using Oracle’s cloud and on-premises applications PBCS and HFM.

Next, Velcro needed a data management solution that could support integrations to both cloud and on-prem EPM applications, pull data directly from ERP systems, and easily transfer data between EPM apps. Velcro chose FDMEE 11.1.2.4.

This customer success story will focus on how Velcro used FDMEE’s advanced features to simplify and enhance its EPM planning and reporting processes

Back to Top
Fast, Effective, and Successful HTP Implementation at Wilsonart
Julien Coudrette , Grant Thornton
Co-presenter(s): Vinay Nagareddy, Wilsonart International
Topic: Financial Close - Subtopic: Other Financial Close

While most finance functions are equipped with Financial consolidation and reporting systems, many tax departments are still relegated to Excel silos, struggling with manual processes and disconnected from the information flows.

In 2016, Wilsonart successfully implemented Hyperion Tax Provision, in partnership with Grant Thornton. The implementation answered the specific needs for automation and reporting of the tax department, and integrates with a broader state-of-the-art Finance Systems architecture with direct feeds from the multiple ERPs and HFM.

Wilsonart can prepare its tax provision confidently and is now well-positioned to handle future growth. This session will present why and how Wilsonart implemented HTP and the benefits attained after a year-end and a few quarter closes.

Back to Top
I've Got an MDX Script for That
Gary Crisci , General Electric
Topic: Essbase - Subtopic: MDX

With the release of Essbase 11.1.2.4.010, it is now possible to get clean MDX output from a MaxL script. This opens many doors and possibilities for developers and power users, and makes knowing how to write a solid MDX script a must-have skill for Essbase professionals.

In this session, EPM Principal Technologist and Oracle ACE Gary Crisci will discuss the fundamentals of writing MDX scripts. He will introduce the new delimited output options and discuss different ways to leverage this new feature. Gary will show attendees how they can use their MDX scripts to create advanced reports for users and how to format data for ingestion to other systems. Gary will also discuss how to use the Query & Load (Q&L) method to leverage MDX scripts as an alternative to ASO calc scripts. Don’t miss this informative session from a noted MDX expert.

Back to Top
Cloud2Cloud – IoT and EPM: Connecting GE’s Predix Industrial Internet Cloud Platform to Oracle’s Planning and Budgeting Cloud Service (PBCS)
Gary Crisci , General Electric
Co-presenter(s): Shyam Nath, General Electric
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

The Internet of Things (IoT), also known as the Industrial Internet, is changing the way industries work. By combining machine-to-machine (M2M) communication, industrial big data analytics, technology, cybersecurity, and automation, it’s driving new levels of efficiency and productivity.

What if you could predict events before they happened? By connecting machines, gaining operational visibility, and leveraging analytics, you can drive operations to their fullest potential and predict what will happen before it occurs.

GE’s Predix platform is a cloud-based solution that can capture industrial data. Now that you have this valuable information, how do you get it in the hands of the people who need it and in a tool that allows them to use the information to make better decisions?

In this presentation, Gary Crisci, Principal Data & Information Architect, Shyam Nath, Partner Account Director, and Venkat Kailasam, Senior Data & Information Architect, will walk you through the Internet of things (IoT). We will illustrate how we capture industrial data from sensors using GE’s Asset Performance Management SaaS cloud solution to determine leading indicators of when large maintenance events are likely to be due and what the nature of the maintenance required will be. Lastly, we will demonstrate how to transfer the data into an Oracle PBCS cloud application for Planning and Budgeting purposes.

Come learn about the next great frontier in information technology and how we are leveraging EPM and IoT to drive better business decisions. 

Back to Top
#LetsWreckThisTogether APEX Talks
Martin D'Souza , Insum
Topic: Application Express - Subtopic: Detail Plunge

Just in case you have not received enough inspiring content by the end of the week, the #LetsWreckThisTogether APEX Talks is back. At last year's Kscope, this exciting new format was a success.

Instead of long, in-depth "deep dives" on a single topic. The APEX track of the conference will close with Lightning Talks presented by some of the best and well-known speakers and personalities in the APEX world.

The exact lineup will be announced closer to the event.

Back to Top
Explore the APEX APIs
Martin D'Souza , Insum
Topic: Application Express - Subtopic: Other Application Express

Most developers new to APEX aren’t aware that APEX comes with a plethora of very powerful APIs for both PL/SQL and JavaScript. This presentation will highlight some of these APIs and explain how and when to use them to speed up and simplify developing your APEX applications. New 5.1 APIs will also be discussed.

Back to Top
Open-Source PL/SQL Utility Tools for Oracle
Martin D'Souza , Insum
Topic: Database - Subtopic: DB Dev

OOS Utils is a free open-source PL/SQL tool set for common utility functionality that developers use. Its goal is to prevent developers from having to rewrite the same code over and over again.

This presentation will highlight some of the great features of OOS Utils and showcase some future plans for the project. All audience types (DBAs, PL/SQL and APEX developers, and Development Managers) are encouraged to attend, as all will see immediate benefits for themselves or their teams to use.

Back to Top
Configuring EPBCS for Operational Planning Requirements
Manish Daga , Oracle Corporation
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

This session will talk about the challenges/requirements for Operational Planning and how you can configure EPBCS to address these challenges/requirements.

Back to Top
DRG: Creating Workflows in DRM
Steven Davis , TopDown Consulting
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Data governance continues to be a big topic. Regardless of company size, at some point a growing organization decides to implement workflow in order to capture the changes you need to make to the master data. This is where DRG comes in. In this session, Steven Davis, DRM and DRG expert, will show you how to create collaborative workflows in DRG. He will look at workflow models, requests, paths, tags, worklists, tasks, models, filters, and users. He will show you how to:
• Create models and tasks
• Build workflow objects
• Auto number your new accounts and create validations on the workflow
• Assign security to the users and hierarchies
• Separate duties and do conditional workflows
• Filter nodes
• And more
The session will include real-world examples as well as tips, tricks, and best practices for working collaboratively with DRG to make sure all users have the necessary change management and data quality remediation workflows to effectively do their jobs. NOTE: Attendees should have a good understanding of DRM. They should understand what workflow is and how it is used.

Back to Top
Getting Your Grips on Excel Chaos
Niels de Bruijn , MT AG
Topic: Application Express - Subtopic: Real World

If historically grown Excel mess in your company sounds familiar to you, then this session is for you. Based on real-world projects, learn how APEX can save end users a lot of time, how the migration is done, and what the strengths/weaknesses of APEX are, as opposed to Excel.

Back to Top
This Is How We Do It
Niels de Bruijn , MT AG
Topic: Application Express - Subtopic: Real World

Different kinds of APEX projects lead to different implementation techniques. Let us classify the project types we had in the past and how we dealt with them, not only from an implementation standpoint but also in how we interacted with our customer.

Back to Top
Extreme Calc Manager
Ludovic De Paz , TopDown Consulting
Co-presenter(s): Ron Moore, TopDown Consulting
Topic: Planning - Subtopic: Optimization

Calc Manager is at the center of Oracle’s EPM suite. It’s the place to develop logic for Essbase, HFM, and Planning on-premise or in the cloud. It’s chock full of advanced features, and it’s quite a task to master all of them. That’s where we come in. Join Ludovic De Paz, TopDown Consulting Senior Manager, and Ron Moore, TopDown Consulting Solutions Architect, for a deep dive into some of the more advanced features of Calc Manager.

We will focus on features that save time and/or allow developers to do things they otherwise couldn’t do and explore:
• How to take advantage of Calc Manager’s modular nature to develop rules and rule sets quickly and benefit from reusability
• All types of variables and some advanced variable tricks
• How to troubleshoot using the debugger, error messages, and logs (especially with the cloud)
• How to use Custom Defined Templates to adapt your rules to different outlines and applications
• How to use Custom Defined Functions

This session promises to satisfy the most geeky of you, and with several real-life stories and demos you will be able to take your Business Rules to the next level.

Back to Top
Data Warehouse 2.0: Master Techniques for EPM Guys (Powered by ODI)
Co-presenter(s): Ricardo Zoldan Giampaoli, Sr, TeraCorp
Topic: EPM Data Integration - Subtopic: Other EPM Data Integration

EPM environments are generally supported by a Data Warehouse; however, we often see that those DWs are not optimized for the EPM tools. During the years, we have witnessed that modeling a DW thinking about the EPM tools may greatly increase the overall architecture performance.

The most common situation found in several projects is that the people that develops the data warehouse does not have a great knowledge about EPM tools and vice-versa. This may create a big gap between those two concepts which may severally impact performance.

This session will show a lot of techniques to model the right Data Warehouse for EPM tools. We will discuss how to improve performance using partitioned tables, create hierarchical queries with “Connect by Prior”, the correct way to use Multi-Period tables for block data load using Pivot/Unpivot and more. And if you want to go ever further, we will show you how to leverage all those techniques using ODI, which will create the perfect mix to perform any process between your DW and EPM environments.

Back to Top
Discover a Brave New World of Key Metric Analytics: Unlocking the Power of Planning and Reporting Through ASO
Brian Deegan , Peloton Group
Topic: Planning - Subtopic: Other Planning

Industry-leading organizations analyze key metrics on a daily basis to assess company performance. For many organizations, reporting these key performance indicators can be time-consuming, require manually aggregating data from multiple sources, and possess the real concern of data accuracy. By unlocking the power of ASO, companies now have dynamic access to their company’s key metrics that were previously challenging to analyze. Critical financial planning processes such as daily sales reporting and workforce expense analysis are some of the specific examples that will be demonstrated to show how these ASO reporting solutions were integrated with the planning process to provide a wealth of analytics. In this presentation, we will provide examples of the innovative ways companies have leveraged the capabilities of ASO to directly support their financial planning processes, increase reporting performance, and provide greater insights into their important operational metrics.

Back to Top
Trends and Hot Topics in Finance for the EPM Professional
Natalie Delemar , Ernst & Young
Topic: EPM Business Content - Subtopic: Budgeting and Planning Processes

According to CFO Magazine, “As much as technology influences the CFO role today, it may define the job in five years.” The office of the CFO has been accused of lagging behind other functional areas in leveraging technology and innovation in their operations. This session will focus on the trends and innovations specifically in FP&A and how technology can be an enabler to your client or company becoming a leading finance organization. Hot topics in FP&A will be covered including drivers, predictive analytics/machine learning, role-based reporting, visualizations, and zero-based budgeting.

Back to Top
Office Depot's Journey to Smart View
Dean DeRenzo , Office Depot, Inc.
Co-presenter(s): Chris Leighton, Office Depot
Topic: BI & Reporting - Subtopic: SmartView

Like the road to Hana in beautiful Maui, our journey at Office Depot to Smart View was full of twists and turns and a little “car sickness” but in the end it was all worth it for the benefits of Smart View. Join us for this presentation where we will take you on a Smart View migration trek, sharing tips and tricks for migrating to Smart View, pitfalls to look out for, and change management recommendations to increase user adoption. We’ll demo how Office Depot is using Smart View and all the advantages of Smart View. If you are still in the Essbase Excel Add-in world (and we know there are still some of you out there!), don’t miss this important presentation to help you through your migration to Smart View.

Back to Top
Architecture Live: Designing an Analytics Platform for the Big Data Era
Jean-Pierre Dijcks , Oracle Corporation
Co-presenter(s): Stewart Bryson, Red Pill Analytics
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

Don't miss the Architecture Live experience! In this interactive session, you'll witness two industry experts digitally illustrating data-driven architectures live, with input and feedback from the audience.

Kafka, Lambda, and Streaming Analytics will be all covered. We’ll tell you what these words mean and more importantly how they affect the choices we make building an enterprise architecture. With the Oracle Information Management Reference Architecture as the backdrop, we'll clarify and delineate the different components involved in delivering big data, fast data, and all the gray area in between. The Architecture Live experience will be fun and different, and we'll all learn something along the way.

Back to Top
Alexa! How Do You Work with Oracle REST Data Services?
Jonathan Dixon , Cloud Nueva
Topic: Database - Subtopic: Other Database

At first glance, Artificial Intelligence (AI) may seem beyond the reach of the citizen ORDS developer. With companies such as Amazon, Google, and Apple providing the interface (aka Alexa, OK Google, and Siri), however, this is no longer the case. In this session, I will demonstrate how you can use Oracle REST Data Services (ORDS) as the gateway to and the Oracle Database as the engine behind Alexa skills that will impress your customers. Alexa! How many orders were placed in the past hour? Alexa! Are there any stuck transactions in ERP Cloud? Alexa! It's time to make ORDS and the Oracle Database cool!

Back to Top
Managing Node.js Instances with Oracle APEX
Kai Donato , MT AG
Topic: Application Express - Subtopic: Integration

You want to monitor and manage your Node.js instances using a tool you are already familiar with? One of the most famous frameworks for controlling Node.js instances will be shown integrated in Oracle Application Express. I will show you how to create, manage, and monitor your Node.js instances from an Oracle APEX application.

Back to Top
Professional JavaScript Error: Logging for Oracle APEX
Kai Donato , MT AG
Topic: Application Express - Subtopic: Integration

Are you searching for the missing piece to perform a perfect start for developing with JavaScript in Oracle APEX? This is the right session for you.

You might be familiar with the built-in debugging features in Oracle APEX and searching for a way to debug JavaScript in a similar way. I will show you how I'm setting up my environment and how I enabled my applications to report all errors to the database instead of just printing it in the local browser console.

With this approach, we are able to create additional metrics for loading times and even specific function execution times. The best part of it: We are saving them to the database and show it in an additional analytics application in Oracle APEX! Attend this session to be best prepared for any JavaScript-related work in Oracle APEX.

Back to Top
The Benefits and Simplicity of Oracle Cloud Infrastructure: IaaS
Julian Dontcheff , Accenture Enkitec Group
Topic: Database - Subtopic: Design

IaaS is the fastest-growing area of public cloud computing. Oracle Cloud infrastructure as a service with built-in security and high availability offers elastic compute, networking, and storage to help any company quickly reach both value and productivity out of the business. The presentation covers the benefits of Oracle IaaS over Amazon and Azure, and we show how fast and easy it is to set up IaaS services in the Oracle Public Cloud.

Back to Top
Supplementing the Close Process at UHS
Geordan Drummond , Edgewater Ranzal
Co-presenter(s): Dan Noon, United Health Services
Topic: Financial Close - Subtopic: Financial Close Management (FCM, ARM, SDM)

Oracle’s Supplemental Data Manager (SDM) module is designed to capture supplemental information in a structured process. Join us for a discussion on how UHS was able to replace a long list of Excel-based schedules with SDM and automate the data population to make the process more efficient. UHS was able to accommodate schedules used both at the beginning of the close process in order to formulate and validate accruals as well as at the end of the close process for reporting purposes.

Back to Top
Expanding Your Data-Driven Story: The Next Chapter
Mike Durran , Oracle Corporation
Co-presenter(s): Stewart Bryson, Red Pill Analytics
Topic: Data Visualization & Advanced Analytics - Subtopic: Oracle Data Visualization

Oracle Data Visualization (DV) makes it easy to get insight from your data. This stunningly visual and intuitive product enables you to access, blend, and wrangle a variety of sources – including spreadsheets, databases, and applications – and tell the story of your data. In this session, learn about the power of data storytelling and the latest capabilities of Oracle DV (including details of product roadmap) to create compelling analytic narratives, including how you can rapidly apply advanced analytic techniques to gain insights previously only accessible to advanced users. Learn about how Oracle DV has been used in real-life scenarios to gain insight and improve business performance.

Back to Top
Fluctuating Exchange Rates Causing Heartburn in the Planning Process?
Cindy Eichner , Finit Solutions
Topic: Planning - Subtopic: Design

Exchange rates movement can significantly impact budgets and forecasts. Let’s explore currency translation in Hyperion Planning, including out-of-the-box multicurrency applications, custom currency translation options, and different ways to quantify and analyze the impact of exchange rate movement during the budgeting and forecasting processes. We will examine several solutions being used in production environments and examine why and how they were built to provide for a positive user experience while minimizing administration complexity. Leave this session knowing about other design options available for currency translation and quantifying the impact of exchange rates movement in Hyperion Planning applications.

Back to Top
Minimizing Hyperion Planning and PBCS Administration Tasks by Design
Cindy Eichner , Finit Solutions
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Is your Planning administrator taking an inordinate amount of time to switch from one planning cycle to another? Are there just too many forms in your application? Do users have to wait for a process to be run to complete their tasks? Learn about different ways to reduce the time needed to administer applications, including Valid Intersections, form and business rule design with substitution variables, Smart Push, and other time-saving design options. Leave this session knowing how to implement these options in Hyperion Planning and PBCS applications.

Back to Top
Things Every Oracle DBA Needs to Know About the Hadoop Ecosystem
Zohar Elkayam , Brillix-DBAces
Topic: Data Warehousing & Big Data - Subtopic: Other

Big data is one of the biggest buzzwords in today's market. Terms such as Hadoop, HDFS, YARN, Sqoop, and non-structured data have been scaring DBAs since 2010, but where does the DBA team really fit in?

In this session, we will discuss everything database administrators and database developers need to know about big data. We will demystify the Hadoop ecosystem and explore the different components. We will learn how HDFS and MapReduce are changing the data world and where traditional databases fit into the grand scheme of things. We will also talk about why DBAs are the perfect candidates to transition into big data and Hadoop professionals and experts.

Back to Top
Exploring Advanced SQL Techniques Using Analytic Functions
Zohar Elkayam , Brillix-DBAces
Topic: Database - Subtopic: DB Dev

Even though DBAs and developers are writing SQL queries every day, it seems that advanced SQL techniques such as multidimension aggregation and analytic functions still remain relatively unknown. In this session, we will explore some of the common real-world usages for analytic function and understand how to take advantage of this great and useful tool. We will deep dive into ranking based on values and groups, understand aggregation of multiple dimensions without a group by, see how to do inter-row calculations, and much more.

Together, we will see how we can unleash the power of analytics using Oracle 11g best practices and Oracle 12c new features.

Back to Top
Analytic Views: A New Type of Database View for BI and Data Warehousing
William Endress , Oracle Corporation
Topic: Data Warehousing & Big Data - Subtopic: Data Modeling

Analytic views are a new type of view in Oracle Database 12c Release 2 that organize data for simplified access via SQL, extend data sets with aggregate data and measure calculations, and provide a rich metadata layer to support BI applications. In this session, learn how analytic views embed joins and aggregation rules, and measure calculations and navigation paths into a single view that is queried with very simple SQL. Use cases include simplifying access to data star schema, Oracle Big Data SQL, and JavaScript Object Notation and as an alternative to exporting data for the analysis in spreadsheets.

This session will be of particular interest to data warehouse architectures and developers and Business Intelligence application developers.

Back to Top
Back to the Future: EPMA to Classic Migration with HFM
Eric Erikson , PQR Company
Topic: Financial Close - Subtopic: HFM Foundation Components

It is "Back to the Future" time at Kscope17. EPMA used to be the future for EPM metadata maintenance. But what if you're now implementing DRM or want to migrate the EPM environment onto Exalytics? Were shared dimensions and data synchronization ever used? This presentation walks through the steps of migrating an HFM EPMA application to Classic – the new future.

Back to Top
Performant Faceted Search Navigation in APEX with Oracle JET and PL/SQL Table Pipelines
Erik Espinoza , Viscosity North America
Co-presenter(s): Jason Canada, Viscosity North America
Topic: Application Express - Subtopic: Real World

Faceted navigation is arguably the most significant search innovation of the past decade. Leveraged by retail sites including Amazon, Home Depot, and Zappos, faceted search allows users to quickly narrow a massive result set by giving them guides (the facets) of the major groups of their results. In this session, we discuss both thick and thin ways of doing this, from enterprise applications such as Oracle Endeca to simple methods using PL/SQL pipelined functions. We show you a retail use case and PL/SQL faceted database search, APEX application, and Oracle JET extensions.

Back to Top
Life on a Loop: Close Look at Oracle ADF Page Lifecycle
Eugene Fedorenko , eProseed NL
Topic: Database - Subtopic: ADF and MAF

This session focuses on the fundamental basis of Oracle Application Development Framework (Oracle ADF) and takes a deep dive into Oracle ADF page lifecycle. Come finally understand the difference between "prepare model" and "render model." Learn what happens behind the scenes when a typical Oracle ADF page is requested from a browser. Hear how Oracle ADF extends standard JSF lifecycle and see what working horses the framework uses for that. The session provides a sample application to explain deeply every single phase of the lifecycle. Learn how to extend and customize Oracle ADF lifecycle in your application.

Back to Top
Run a Successful Development Project in the Cloud with Oracle Developer Cloud Services
Eugene Fedorenko , eProseed NL
Topic: Database - Subtopic: ADF and MAF

Got a project and a team of Oracle Application Development Framework (Oracle ADF) developers? Struggling to put together lots of things such as source control management, issue tracking, continuous integration, and Wiki collaboration? Come see how Oracle Developer Cloud Service helps cope with all that, basing on real-life experience. Learn how to develop, deploy, and collaborate with Platform as a Service (PaaS) development environment for the enterprise. Hear how to make the right decisions and how to organize the process, ensuring completion of the project on schedule and within budget.

Back to Top
Did You Know Your Local Grocer Uses Essbase?
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

Kroger is scaling Oracle Hyperion Essbase to 25,000 users and putting timely data in the hands of the tactical resources in thousands of stores. Stores can drill through to invoices, write back their labor estimates, and manage allocation factors that are critical to corporate through the Dodeca interface.

Back to Top
Change Impact Analysis with 12.2 PL/Scope
Steven Feuerstein , Oracle Corporation
Topic: Database - Subtopic: DB Dev

PL/Scope, first introduced in 11.1, offers a powerful code analysis tool, baked right into PL/SQL. With it, you can answer questions such as, "Where is this variable modified in my code?" "Which packages invoke a specific overloading of a function?" and "Show me all my unused declarations." Cool stuff. But prior to 12.2, SQL statements were not a part of that analysis. Now in 12.2, PL/Scope also gathers information about static SQL statements and where dynamic SQL is executed in your code. As a result, you can now use PL/Scope to perform comprehensive, detailed analysis of the impact of planned changes to your code base. In this session, Steven Feuerstein introduces attendees to PL/Scope, explores 12.2 enhancements, and provides scripts everyone can use to leverage PL/Scope in their dev environment.

Back to Top
Optimizing PL/SQL for Performance and Maintainabiliity
Steven Feuerstein , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle
Topic: Database - Subtopic: DB Dev

After fully leveraging SQL in your Oracle Database applications, it’s time to completely utilize PL/SQL to implement business rules, create APIs on top of your data structures, and implement key processes within the database. Usually when developers think about optimization, they focus on performance, and this session does, too. But it’s also critical to think about how to write code today so that tomorrow and years from now, future developers will be able to adapt that code to changing user requirements and database features. In this session, PL/SQL experts, including Bryn Llewellyn and Steven Feuerstein, will present their ideas on writing optimal PL/SQL but focus mainly on answering questions from the audience.

Back to Top
Oracle Dev Gym PL/SQL Workout: Oracle Database 12c
Steven Feuerstein , Oracle Corporation
Topic: Database - Subtopic: DB Dev

The best way to learn is to actively engage/exercise with the technology. In this session, attendees will participate in an Oracle Dev Gym workout: a series of multiple-choice quizzes that test your knowledge of PL/SQL features in Oracle Database 12c Releases 1 and 2. Steven will then review each quiz and give out prizes for best performance. It'll be a fun and different way to learn about PL/SQL!

Back to Top
Updatable Views to Secure Your Database and Make Your Developers Happy
John Flack , Synectics for Management Decisions, Inc.
Topic: Database - Subtopic: DB Dev

Learn about the advantages of putting updatable views between your applications and your tables. They can simplify development, enforce business rules, and provide extra security. And I will show you how to write INSTEAD OF triggers that make it all possible.

Back to Top
Jumpstarting Your Cost Allocations with Profitability and Cost Management Cloud Service (PCMCS)
Courtney Foster , interRel Consulting
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Come learn how Oracle Profitability and Cost Management Cloud Service gives you a clear and definitive look into your business health. One of Oracle’s newest cloud services takes its sister on-premises product, HPCM (Management Ledger applications), and launches it into the cloud with new and improved features. PCMCS provides a complete graphical interface to simplify the build and execution of complicated allocation rules all in the common EPM Cloud SUI (no scripting required!). Some beloved HPCM features come over, such as the traceability interface and rules balancing report, along with new pre-built dashboards. PCMCS sits entirely on top of Essbase and supports any costing methodology. There is no black box with PCMCS, as this cloud solution allows users to get an inside look at the drivers of costs as they “audit” the profitability of their organization. Learn how PCMCS can help you allocate expenses and get a better understanding of profit and costs at any level in your organization in less than two months.

Back to Top
Understanding EPM Cloud Infrastructure: What's New?
Bill Fox , Oracle Corporation
Topic: EPM Infrastructure - Subtopic: Cloud and Hybrid Infrastructure

New to EPM Cloud and want to know the ins and outs of managing your service? Then this is the session for you. Topics include service provisioning, backup and restore, security and user management, and service maintenance. This is the one-stop destination to orient you with everything you need to know about the operational aspects of working with EPM Cloud.

Back to Top
Reduce European Flight Delay: Real-Time ODI, OBIEE, and D3
Jerome Francoisse , Rittman Mead
Topic: BI & Reporting - Subtopic: OBIEE

Eurocontrol is the European Organisation for the Safety of Air Navigation and works with 41 member states. An accurate view of the real-time traffic is needed in order to support its goal to reduce the average delay per flight in European airspace. Air traffic managers now have access to a new tool to efficiently visualize where problems could occur through the day and apply regulations where needed. In this session, we will first see how its data is refreshed every few minutes using web services integrated in Oracle Data Integrator. Then we will look at the tool itself, powered by Oracle Business Intelligence Enterprise Edition, and some advanced visualization build in D3 to follow an aircraft through all its flights of the day.

Back to Top
Oracle R Enterprise and Data Visualization: Combining Their Power Leads to New Possibilities
Holger Friedrich , sumIT AG
Topic: Data Visualization & Advanced Analytics - Subtopic: Other

In advanced analytics, the R language with its different distributions became the de facto standard in recent years. In visualization, tools such as Oracle Data Visualization, QlikView, and Tableau for data exploration and flexible analyses are spreading rapidly. However, using data viz tools interactively on top of advanced analytics such as R is often hard because either they lack integration or the performance of R installations is just not good enough for interactive analyses or computation of massive data sets on a regular, e.g. nightly, or even an ad hoc basis. This problem can be solved by combining the use of Oracle Data Visualization (Data Viz) and Oracle R Enterprise (ORE). While ORE can run directly on large database servers, making full use of their massive computational power and parallel execution of R code, Data Viz offers immediate access to analytic results and can string them together with all sorts of other data available for exploration and further analysis. This talk explains the concept and advantages of using ORE and Data Viz in combination. Live demonstrations will illustrate the solution. Attend to get inspirations for solutions to your own business challenges and projects.

Back to Top
HFM Performance Optimization: 10 Things That Can Save Your Application
Michael Fuori , General Electric
Topic: Financial Close - Subtopic: HFM

Application running slower than you think it should? Afraid the application will slow over time? Not sure if it’s an application problem or environment issue? Then join this session to hear about the HFM 11.1.2 performance optimization efforts of General Electric. See how GE has optimized one of the largest (16) dimension HFM applications and environments known to Oracle. We would tell you more, but then we would spoil the ending. Join us to see how it all turned out.

Back to Top
HFM Rules Automation: UDs and Triggers Gone Wild
Michael Fuori , General Electric
Topic: Financial Close - Subtopic: HFM

Ever think you would see the day that an HFM rule file could be so dynamic that it virtually eliminated the need for maintenance? Well, at General Electric we have put UD fields on steroids and enabled triggers to achieve just that.

Back to Top
Using VBA to Enhance the Smart View Expereince
Daniel Gagnon , Huron Consulting Group
Topic: Essbase - Subtopic: Other Essbase

Have you ever taken a look at the Smart View developers guide and seen all of the VBA functions that are available to you? They are endless, and the power they pack can be lost behind the sometimes-complex syntax that is required. Come spend an hour learning what they do, how they can benefit you, and possibly even how to accomplish tasks otherwise out of reach.

Back to Top
Essbase Cloud – How You Do It (Live Demos) and Expanded Q&A
Tim German , Qubix
Co-presenter(s): Cameron Lackpour, ARC EPM
Topic: Essbase - Subtopic: Other Essbase

You won’t want to miss this opportunity to see Oracle Essbase Cloud Service up close and personal. Cameron Lackpour and Tim German will expand on their Essbase Cloud session, demonstrating how to accomplish a variety of real world tasks and use-cases in Essbase Cloud Service. An Oracle representative will be on hand to weigh in on Q&A discussions.

Back to Top
Essbase CDFs Demystified: Pulling Back the Curtain and Opening a World of Possibilities
Robert Gideon , interRel Consulting
Topic: Essbase - Subtopic: Calculation

Unique challenges often arise during Essbase and Planning projects that require thinking outside of the box, or the calculator engine, as the case may be. Essbase Custom Defined Functions (CDFs) enhance the calculation functions included with Essbase. Essbase CDFs unleash the power of Java and open a world of possibilities. This session will demystify CDFs, show how to deploy them, and demonstrate how they can be used if the need arises.

Back to Top
APEX for Beginners
Dimitri Gielis , APEX R&D
Topic: Application Express - Subtopic: Other Application Express

If you've heard about APEX but didn't play with it yet, or only played with it for a couple of weeks, this session is for you. My goal is to save you at least a month of searching and finding your way to build great APEX applications. I'll share how to get started, where the APEX sweet spot is, and common pitfalls you should avoid.

Back to Top
OMG! JavaScript Straight from the Oracle Database
Dimitri Gielis , APEX R&D
Topic: Application Express - Subtopic: Integration

When APEX and the core database features were not enough, I started to investigate how to run JavaScript straight from the database. My results were baffling – and I want to share them with you. I'll explain how you can do it yourself and show many live demos where this new technique is useful.

Back to Top
Accelerating Testing Using Data Virtualization
Tim Gorman , Delphix
Topic: Database - Subtopic: Other Database

How much testing do you perform in your BI/DW environments? Do you even have a test environment? Do you test in production?

The biggest problem with testing in BI and DW environments is the size and velocity of data. Databases and applications have grown enormous and complex. "Storage is cheap" is simply not true. Need proof? Ask for 10 TB to provision a new test environment.

Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes or even petabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, if ever, and both code quality and data quality suffer.

Data virtualization is the solution. Using thin-provisioning technologies, virtual databases and file systems only consume space from changed blocks, so it is possible to provision virtual terabytes for only a few actual megabytes. Coders and testers have full and independent read-write environments provided quickly in which to develop and test, improving code quality. Learn about the technical details behind this solution.

When I first heard about data virtualization, it sounded far-fetched, just a trick. Instead, it is the perfect solution to the perfect storm of more data quickly. Every IT shop will need to know how to provision test environments faster using less storage. It's not a matter of "if," but "when."

Back to Top
Barriers to Oracle Database In IaaS Cloud
Tim Gorman , Delphix
Topic: Database - Subtopic: DevOps/Agile

IaaS cloud vendors such as AWS prefer that everyone migrate to the cloud, but what often happens is that non-production migrates for cost reasons but production stays on-premises. This phased path to the cloud can leave IT with a split personality: production on-premises on legacy proprietary UNIX platforms, non-production in the cloud on commodity Linux platforms.

Because the security risk on non-production systems is much higher than production, there is a requirement to mask personally identifiable information or confidential data before it is copied to non-production. Data virtualization employs thin cloning, snapshots, and network-attached data presentation, reducing cloning from hours or days to minutes. But there is more: Your legacy UNIX (i.e. AIX, Solaris, HP-UX) databases aren't going anywhere off-premises because the cloud is based on Intel (i.e. Linux, Windows). So what to do?

In this session, learn how data virtualization and data masking make "split-brain IT" not just possible but desirable.

Back to Top
Top Five Cool Features in Oracle SQL Developer Data Modeler
Kent Graziano , Snowflake Computing
Topic: Database - Subtopic: DB Dev

Oracle SQL Developer Data Modeler is an industrial-strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years, I have found quite a few features in the tool that I rely on to make me more efficient in developing my models. I will demonstrate at least five of these features, tips, and tricks including using the metadata export tool.

Back to Top
Report Automation Techniques from Essbase and Hyperion Financial Reports with VBA and Smart View
Jennifer Guzik , Hudson Advisors
Topic: BI & Reporting - Subtopic: SmartView

Financial reporting packages sometimes need to be updated with current data multiple times per day during parts of the accounting close process. When your package covers hundreds of entities, streamlining and automating this process as much as possible is a high priority. In this session, we will discuss why we chose to use Excel and Smart View as our reporting platform to bring in Essbase data via HFR and direct Essbase queries and some tips on how we used VBA to make the process run with one click.

Back to Top
Mastering MDX for Analytics and Reporting
Jennifer Hanks , Key Performance Ideas
Topic: BI & Reporting - Subtopic: Other BI and Reporting

MDX is often used in ASO cube member formulas, but did you know you can also use MDX to write reports and Smart View queries? Did you know that these reports and queries can be written against both BSO and ASO cubes? MDX can seem daunting, but with a basic understanding of syntax and functions, MDX is not that difficult. This session will give you what you need to get started writing MDX reports and queries that can supplement your reporting and add a new tool to your reporting tool set.

Back to Top
Analytic Views in Oracle Database 12.2: The Virtual Cube
Kim Hansen , Trivadis Danmark A/S
Topic: Database - Subtopic: Other Database

Traditionally to model and analyze your data with dimensions and hierarchies, either you copy your data to a data warehouse and from there to a dimensional cube, or you have to write quite a lot of rather advanced code and SQL to emulate the same directly on your relational data.

With analytic views (introduced in Oracle Database version 12.2), you declaratively define the dimensions and hierarchies similar to creating a cube, but it is only stored as a metadata layer on top of your tables; it is a multidimensional *view* of your relational data. The SQL language has been expanded to allow a simpler query syntax on the analytic views to utilize these metadata and automatically use advanced analytic functions to give you dimensional analysis on real-time data. As SQL is used below the covers, performance can be tuned using query rewrite with materialized views or In-Memory options or any other option you would normally use for SQL tuning.

This session will show code examples covering a lot of the syntax you have for creating and using analytic views.

Back to Top
ASO Plan Type: To Seek Out New Integrations with ODI
Michael Hansen , Leidos
Co-presenter(s): Trina Nguyen, Leidos, Inc
Topic: EPM Data Integration - Subtopic: Other EPM Data Integration

Be prepared to be beamed up! In this session, you will embark on a voyage that an enterprise took utilizing ODI as its warp core to improve data integrity and efficiency, and reduce the cost of ownership of their EPM Planning and Essbase solution. There will be a brief overview of the ODI use case and how ODI was instrumental in achieving a self-service ASO Plan Type Solution. Discover how Leidos creatively utilized ODI for more than just metadata and data integration, including assisting with procedure calculations, dynamically generating business rules, launching calculations, building alt hierarchies from forms, data validations, and much more.

Back to Top
ASO Plan Type: The Final Frontier
Michael Hansen , Leidos
Co-presenter(s): Trina Nguyen, Leidos, Inc.
Topic: Planning - Subtopic: Other Planning

Seat backs in an upright position and buckle up! In this session, you will embark on a voyage from academic theory to a real-world deployment of an ASO Plan Type Solution. There will be a brief overview of use case and how a self-service approach for Planning led Leidos to select an ASO Plan Type Solution. Discover how Leidos tackled the challenges of an ASO Plan Type, enabling users to do all their planning directly in an ASO cube. Learn how Leidos overcame the obstacle of an Essbase data connection and finally satisfy the Vulcan in you with tips to take calculations to warp speed. ASO Planning can be an exciting new frontier for an enterprise in the real world.

Back to Top
Docker for Dummies
Roel Hartman , APEX Consulting
Topic: Application Express - Subtopic: Real World

You might (or might not) have heard of Docker, but you have no idea what it is and why you should care. But if you are a Database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon.

In this session, you'll learn what Docker is and how you can benefit from it in your daily work.

Back to Top
Make Your APEX Applications Fly Using JET Components
Roel Hartman , APEX Consulting
Topic: Application Express - Subtopic: Integration

At Oracle OpenWorld 2015, Oracle introduced JET: JavaScript Extension Toolkit. APEX 5.1 ships with JET and uses it to create the good-looking charts declaratively. But if you know JET a bit better, you can tune the look and feel of the charts even more. And apart from the exposed charts, there are more components in JET you can use in your APEX application. This session will show you how to do that and walk through a way to create plugins for JET components.

Back to Top
Hacking Hyperion: A White-Hat Approach to Securing Your Instance
Jon Harvey , eCapital Advisors
Co-presenter(s): Casey Ratliff, eCapital Advisors
Topic: EPM Infrastructure - Subtopic: Security

Because of its nature as a financial analysis system, Hyperion tends to house a company’s most sensitive information (and a lot of it!). In spite of this, security is rarely a focus of many Hyperion implementations. In most areas of the suite, Hyperion is pretty good at securing itself. However, in a few glaring instances, there are default settings that leave you exposed. But don’t panic – an ounce of prevention is worth a pound of cure!

Join eCapital Advisors’ Jon Harvey and Casey Ratliff as they decrypt, disassemble, and walk through some of the back doors of the Hyperion infrastructure and how to secure them in your environment. Come learn about these exploits before your auditors do!

Back to Top
Know What Your Code Is Doing; Know What It's Done: How to Instrument Your Code Easily and Effectively
Sabine Heimsath , its-people GmbH
Topic: Application Express - Subtopic: Detail Plunge

Do you measure how your code is performing? Do you have the right info at hand when your program fails? Can you monitor your program while running?

This session is all about instrumenting your PL/SQL code, be it inside an APEX application or in a pure PL/SQL environment. What are the alternatives to the very common hand-knitted or organically grown solutions? We are going to look at a few open-source frameworks and analyze which requirements they can cover and what you might have to add yourself. After this session, you will know what to look for when choosing the right framework to enhance your project.

Back to Top
Six Reasons Why You Will Get Addicted to SQLcl Scripting
Sabine Heimsath , its-people GmbH
Co-presenter(s): Robert Marz, its-people GmbH
Topic: Database - Subtopic: DB Tools

SQLcl is ready to replace the reliable but somewhat outdated SQL*Plus as the new command line interface of the database. The most exciting new feature of SQLcl is scripting: Batch scripts can now be written in languages such as JavaScript, Python, or Perl. This means a veritable cornucopia of options, many of which are not obvious at first sight.

After a brief introduction to SQLcl, we will show many real-world examples that demonstrate the new possibilities. All examples are available for download to allow for further tests and exploration. This presentation provides many in-depth live demos.

Back to Top
Build Your Own Infographics Using the Data Visualization SDK
Antony Heljula , Peak Indicators Ltd
Topic: Data Visualization & Advanced Analytics - Subtopic: Oracle Data Visualization

Oracle Data Visualization has already made a huge impact with its excellent visualization and storyboarding features. This session will demonstrate how to take these capabilities one step further by using the Data Visualization SDK. The SDK provides the tools for developing your own custom visuals within Oracle Data Visualization, enabling you to deliver sophisticated infographics that can tell your stories in new and exciting ways!

Back to Top
Unbiased Comparison: Evaluating All Deployment Options for Hyperion EPM – SaaS vs. IaaS vs. On-Prem
Eric Helmer , Mercury Technology Group
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

Today, the word "cloud" is everywhere, and it's causing a lot of confusion. Software as a Service (SaaS), Infrastructure as a Service (IaaS), and Platform as a Service (PaaS) are completely different solutions but are all considered "cloud."

This session will compare and contrast the different available options Oracle customers have to deploy Oracle EPM. It will break down all Oracle's cloud offerings, IaaS, third-party hosting, traditional on-premise deployments including Exalytics, and hybrid approaches.

This session will read between all marketing lines and discuss what’s possible and what’s a bit overstated. It will cover differences in functionality, data integration, security, flexibility, and scalability. Finally, we will evaluate the differences in costs, including hardware, software licensing, and ongoing maintenance.

If you are looking to make a decision on how best to deploy, upgrade, or outsource Oracle EPM this is a don’t miss session.

Back to Top
Best Practices of the Design and Delivery of Master Data from DRM to Downstream Applications for Large Implementations
Kate Helmer , Huron Consulting Group
Co-presenter(s): Joe Davis, Huron Consulting Group
Topic: EPM Data Integration - Subtopic: Metadata management/integration

Minimize maintenance and make delivering master data to your customers a breeze with the right design and methodology. Consuming master data from Oracle Data Relationship Management can be a convoluted mess of flat files (yuck!), tables, and technologies in a large enterprise; simplify and standardize by utilizing these design tips to creating a master data repository that can deliver and scale with ease. Join Joe Davis and Kate Helmer as they detail design considerations of master data repositories, the pros and cons of the methodology, and how to standardize the technical integrations to downstream systems.

Back to Top
Design Your Databases Using Oracle SQL Developer Data Modeler
Heli Helskyaho , Miracle Finland Oy
Topic: Database - Subtopic: Design

Oracle SQL Developer Data Modeler is one of the leading database design tools in the market. The amount of data is growing, and everybody is starting to understand the value of good-quality data for their business. The only way to have good-quality data and to understand your data is to design your databases. To be able to design them, you need a tool; paper and pen are not enough anymore. What is database designing, and how do you design databases using Oracle SQL Developer Data Modeler?

Back to Top
How to Design a Database? Let's Start with the Logical Model
Heli Helskyaho , Miracle Finland Oy
Topic: Database - Subtopic: Design

What is database designing, and how do you design a relational database? What is a logical design, and why do I need to create one? What is NF3 and BCNF? Why would I care about all the theory, and what is it, by the way? During this session, you will get answers to these questions plus about 100 more.

Back to Top
Advanced Data Visualization Techniques Using Oracle BI Cloud Service (BICS): A Cal State Pilot Case Study
Viet Hoang , California State University, Los Angeles
Co-presenter(s): Kirby Lunger, Performance Architects
Topic: Data Visualization & Advanced Analytics - Subtopic: Other

Join California State University (Cal State) to learn about how Cal State developed a pilot Oracle BI Cloud Service (BICS) solution with multiple subject areas across the institution so its team can use advanced data visualization techniques to better analyze and report on college data. During this session, we will demonstrate several visualization techniques you can employ in your own organization to find that “needle in a haystack” to address your own burning business questions. We will also discuss data integration techniques for both proprietary and third-party data sources as well as how to organize for success, how to get a pilot project funded, and next steps for this initiative.

Back to Top
Hybrid Cloud: A Solution for a Business Problem
Paul Hoch , TopDown Consulting
Co-presenter(s): Steve Davis, TopDown Consulting
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

Moving EPM applications to the cloud is the most significant market direction to date. The reality is that finance and IT teams don’t move as fast as the applications, which means companies need a solution that accommodates a mix of on-premise and cloud EPM applications (Hybrid Cloud). That solution is Hybrid Cloud.

A Hybrid Cloud implementation is not without its challenges, and because of this, companies find themselves asking, “What is the right the right approach, and how do I make sure all my applications are seamlessly integrated?” In this session, Paul Hoch and Steve Davis, TopDown Consulting Principal Architects, will answer this question. They will discuss:

• How cloud offers compelling value to EPM owners – e.g. beyond the obvious economic benefits
• How to successfully do a Hybrid implementation – i.e. strategy for companies to combine on-premise and cloud-based EPM systems
• Review implementation considerations to ensure a powerful “hybrid” deployment
• Integration and how it is critical to success
• Common pitfalls and how to avoid them
• Common scenarios where there is synergy for a “hybrid” deployment
• Real-world examples of companies that are using a Hybrid approach – what’s working and what isn’t
• And more

This session is useful for anyone considering a Hybrid approach or those already with a Hybrid approach.

Back to Top
Current Trends and Best Practices for Improving User Adoption and Productivity for EPM and BI
D.J. Hoelscher , Oracle Corporation
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

In this session, we will cover the current trends in learning and best practices for user training, including similarities as well as differences between on-premise and cloud users. We will also discuss how to overcome potential challenges and associated risks with user adoption. In addition, the session will explore approaches to accelerating the development and deployment of effective User Training by leveraging available development tools or guided learning approaches.
• User training best practices
• Cloud user adoption best practices
• User adoption challenges and risks
• End user training options
• Explore approaches to accelerate development and deployment of training

Back to Top
Plugin Your APEX Widgets
Menno Hoogendijk , Qualogy
Topic: Application Express - Subtopic: Detail Plunge

APEX 5.1 includes a lot of jQuery widgets and plugins under the hood. Because the development team uses them to create our beloved components as the Interactive Report and Interactive Grid, why not use the technique ourselves?

This session will demonstrate why widgets and plugins are so powerful. Did you know they can be exposed as APEX plugins to reuse them declarative? We'll explore how some of the existing widgets work in order to build our own, step by step.

Back to Top
Powerful JavaScript Skills for Every APEX Developer
Menno Hoogendijk , Qualogy
Topic: Application Express - Subtopic: Other Application Express

Are you a developer looking for steady JavaScript skills? We all have to deal with the same issues sooner or later. Knowing about the most common features will help you solve issues and create advanced applications.

We'll go over a lot of topics live: fundamentals, bad practices, their improvements, and new features. The result? End up with professional, organized code.

This session is intended for beginner and intermediate developers. Join my talk and get a better understanding about the ever-changing JavaScript landscape.

Back to Top
A Lesson Your Teacher Never Taught You: Automated Account Reconciliations
Joy Hsu , The Hackett Group
Co-presenter(s): Charles J. Zorbach, Laureate Education
Topic: Financial Close - Subtopic: Financial Close Management (FCM, ARM, SDM)

To implement world-class financial close process and best practices, Laureate International Universities transformed from a manual reconciliation process to an integrated and automated process, using Oracle Account Reconciliation Management (ARM). The solution rolled out to six shared service centers (SSC), including the US, Chile, Europe, Mexico and Brazil. The solution automated data load with PeopleSoft GL and Subledgers to improve accuracy and accelerate the reconciliation process. Overall, automated reconciliations grew up to 50%. Automation enforces standardization across the reconciliation process and improves quality and accuracy of financial data.

Back to Top
Essbase and Crystal Ball: Adding Risk-Related Data to a Financial Model
Philip Hulsebosch , Trexco b.v.
Topic: Essbase - Subtopic: Essbase-related technologies

In real estate development, risk assessment and risk management are key elements for the financial model of a project. Common financial models only let you do a best-case, worst-case, and most likely scenario. They lack information on the probability of occurrence of this most likely scenario. Also, information on the variance within this most likely scenario is often missing. This results in decisions based on inadequate information.

In this case study, we will show an Essbase model and how to add risk-related information. In a matter of hours, we were able to extend the existing Essbase model with Oracle Crystal Ball statistical functionality and generate this important information.

This case study is about drilling a geothermal energy well, and the green energy produced will be delivered to nearby apartments, houses, and small businesses. The risk-influencing factors were energy price, interest rate, and maintenance costs. The case study can serve as a kind of blueprint on how risk-related information can be added to a project plan.

Back to Top
How to Use APEX to Build and Manage Automated Browser Tests
Simon Hunt , MOD
Topic: Application Express - Subtopic: Other Application Express

In this session, delegates will learn how to use APEX itself to build maintainable browser-based automation scripts for fast, consistent, repeatable testing of APEX applications. All the products demonstrated are available through open-source projects, and there is no need for any specialist programming skills other than APEX. Also covered is the ability to call the automation scripts programmatically and run them on a load testing environment or as part of an automated build process (AKA Continuous Integration). The techniques shown will help developers become more Agile in their development and greatly improve the overall quality of their applications.

Back to Top
GE’s EPM Shared Service Cattle Drive
Paul Husak , General Electric
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

See how GE organically built one of the largest EPM Shared Services teams. Long before building our Exalytics/Exadata PaaS supporting 500+ applications, our team had much to round up. Follow the journey west, dreaming under the stars of an EPM sky, building a vision, rustling businesses, corralling Oracle and multiple consultant teams, building platforms and processes, and growing to meet demand.

Join Paul Husak through the forming, storming, norming, and performing of EPM Shared Services for one of the world’s largest company’s. He will share the risks and rewards associated with building a center of excellence, from building and all-star team, dealing with multiple vendors, establishing processes, and absorbing new technology while keeping an eye on the Oracle Cloud.

Technologies highlighted include HFM, Planning, Essbase, CM, ARM, FDMEE, ODI, DRM, Automic, Accelatis, Exalytics, and Exadata.

Back to Top
Essbase on Exalytics: It’s Magical If You Chant the Spells Right
Adrian Istani , Ingersoll Rand
Topic: Essbase - Subtopic: Exalytics

Essbase on Exalytics may/may not automatically translate better stability or performance without additional tweaking; in our case it did not. Find out about our experience with Exalytics X3-4 since we acquired it in early 2015, moving from a much smaller Windows Intel box to now rock-solid implementation with Exalytics.

Back to Top
OMG! Identifying and Refactoring Common SQL Performance Anti-Patterns
Jeff Jacobs , Jeffrey Jacobs & Associates
Topic: Database - Subtopic: DB Dev

Most presentations on SQL performance assume that the query developer is highly experienced in SQL and Oracle and focus on tracing and other techniques. Sadly, in today's world, knowledge of SQL and Oracle are not highly valued, and many SQL performance problems are the result of inexperience, misguidance, "heard it/read it somewhere," and various sources of misinformation. This presentation will address common "anti-patterns" in database design and SQL query writing that have been encountered over the years and how to fix them without tracing, changing init.ora parameters, or techniques requiring DBA-level privileges. It is focused on techniques that are typically available to developers. This presentation received a 2015 SELECT Journal Editor’s Choice Award.

Back to Top
A Real-World Implementation of FCCS: Lessons Learned and Mistakes You Do Not Want to Repeat
Mike Janik , New Flyer Industries Canada ULC
Co-presenter(s): Edward Roske, interRel Consulting
Topic: Financial Close - Subtopic: Financial Close in the Cloud

One month after the Oracle Financial Consolidation and Close Cloud Service (FCCS) product was released, we found ourselves deep in the thick of implementing a solution and there was no roadmap to follow. To begin with, we quickly discovered that HFM and FCCS are as similar as two completely dissimilar things could be, as was implementing FCCS vs HFM. We then found out that while there were many prebuilt things that existed in FCCS that didn't exist in HFM, things we felt surely must exist (specific forms, reports, and calculations) weren't there at all. How did we work around what was missing? How did we take advantage of what was there? How can you learn from our journey of exploration (so you can be a lot smarter in your journey)? While there's far more than an hour's worth of lessons, we'll make sure we cover the big ones before the session is over.

Back to Top
Reconciliations Made Easy in the Cloud at New Flyer
Mike Janik , New Flyer Industries Canada ULC
Co-presenter(s): Glenn Schwartzberg, interRel Consulting
Topic: Financial Close - Subtopic: Financial Close in the Cloud

The most significant time-consuming (and boring) step in closing your books is verifying that the data ties: Does the total from the AP subledger equal the accounts payable line in the GL, does the journal entry detail match the account balances, and does the general ledger foot to what’s in FCCS or HFM? Oracle EPM's solution to quick reconciliation of data? Account Reconciliation Cloud Services (which also has an on-premise version if you want to kick it old-school). This technology will not only speed up your manual reconciliations by helping you find the discrepancies; in most cases, it will do it automatically. Come learn how New Flyer Industries Canada ULC reduced its close cycle (and got a large dose of sanity back) with Oracle Account Reconciliation Cloud Service.

Back to Top
Do You Want an Extra Custom Dimension with That?
Dennis Jensen , FLSmidth A/S
Topic: Financial Close - Subtopic: HFM

Why should you consider having more than four custom dimensions in your HFM application? At FLSmidth, we found that we could solve some major reporting pains while also making the application more simple and intuitive.

The presentation will cover areas such as:
• Which reporting dimensions we use
• The problems with having multiple reporting dimensions on one custom dimension
• Why it matters on which custom dimension you place your reporting dimensions, when you have more than four custom dimensions
• The benefits of the DataSource dimension
• Concerns about negative influence on performance
• Be careful not to make data input from users too complex or cumbersome
• Changing metadata and rules
• How to use FDMEE to convert the historical data

Back to Top
Tools for Rules
Dennis Jensen , FLSmidth A/S
Topic: Financial Close - Subtopic: HFM

Tips and tricks for how to make your task as an HFM rule programmer just a little easier:
• Create your own powerpack for Notepad++, adding formatting capabilities such as expand/collapse blocks of code, background coloring, etc.
• How to measure time for running your rules calculations
• How to use UDs and member lists to create custom lists for your rules programming and make your rules maintenance more simple
• Open data unit, your best friend for limiting data processed by your rules code
• Use variables!
• Create on/off switches that can be updated in a data form to enable activation/deactivation of validations, etc. without changing rules
• Use writeToFile for your debugging

Back to Top
The PBCS REST API Demystified
Jason Jones , Applied OLAP, Inc.
Co-presenter(s): Jon Harvey, eCapital Advisors
Topic: EPM Data Integration - Subtopic: Cloud Integration

Oracle's Planning and Budgeting Cloud Service (PBCS) offers a REST API, but how does it work and what can it do? This presentation for administrators and developers will give an approachable overview of how the API works, what its capabilities are, and how it can be practically used in automation and data integration scenarios.

Back to Top
Event-Driven Applications Using Custom JS Events
Tyson Jouglet , SkillBuilders
Topic: Application Express - Subtopic: Real World

Have you ever wanted to have the same dynamic action fire for different events, if the user clicks a button or if she presses enter? Out of the box, it appears that APEX cannot handle this situation. There is a very simple solution using custom events and event emitters in JavaScript.

Back to Top
Update from Development
Joel Kallman , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

summary to come

Back to Top
Hacking FCCS to Create a Custom Consolidation Engine
Pritpal Kalsi , SC&H Group
Topic: Financial Close - Subtopic: Financial Close in the Cloud

We’ve all heard it 1,000 times before: FCCS is NOT HFM in the cloud. But can you hack it to make it HFM in the cloud? Don’t worry, Oracle; we are not hacking your software, but we will show you how to use out-of-the-box tools that are part of FCCS to make it your own unique consolidation engine. In this demonstration, you will learn tips and tricks that we have used with our FCCS clients to make applications more flexible, dynamic, and customizable than you ever thought possible. We will also cover the latest and greatest functionality up to and including the June 2017 FCCS release.

Back to Top
King/Queen of CDFs Has Arrived
Celvin Kattookaran , Intekgrate
Topic: Essbase - Subtopic: Calculation

The king or the queen of CDFs has arrived. This session talks about the latest CDF offering from Calc Manager, which can be used to write CDFs from Calculation scripts itself. What if you want to execute a SQL procedure from Calc script? What if you want to run a select statement?

All that and beyond is now possible with @CalcMgrGroovyString and @CalcMgrGroovyNumber functions. This session will include sample codes for all the topics covered above.

Back to Top
Ready, Aim, Fire: The Lowdown on Smart View's Features for Reporting
Justin Kern , Vertical Edge Consulting Group
Co-presenter(s): John Taylor, Vertical Edge Consulting Group
Topic: BI & Reporting - Subtopic: SmartView

Are you good at hitting the refresh button on a template that someone else created, but you need to know how to build data retrievals using the Hyperion Smart View Office Add-In? Are you aware of all the alternatives for querying data and know which is best for each type of report? This session will cover the different methods available for retrieving data against Essbase, Planning, and HFM data sources and the benefits/drawbacks of each one. You will leave feeling confident and competent to start building all different types of data retrievals on your own.

Back to Top
Web Reporting Studio Will Have Your Saddles Blazin’: Learn the Usage of This Tool Across Several Cloud Products
Justin Kern , Vertical Edge Consulting Group
Co-presenter(s): John Taylor, Vertical Edge Consulting Group
Topic: BI & Reporting - Subtopic: Financial Reporting

Web Reporting Studio is an online tool for developing and editing financial reports for your EPM applications in place of the traditional Financial Reporting Studio installed client. It works across several of the cloud products and allows for everything to be done in a web browser without having to deal with all of the local computer installation problems. Using Web Reporting Studio has a different look and feel than the traditional Financial Reporting Studio. In this session, we will cover the details on using Web Reporting Studio so you can get ahead with your reporting.

Back to Top
PDB Me, ASAP! Oracle Database 12cR2 Multitenant Workshop
Charles Kim , Viscosity North America
Co-presenter(s): Jim Czuprynski, OnX Enterprise Solutions
Topic: Database - Subtopic: DB Dev

Oracle Database 12cR2 has dramatically revamped the range of Multitenant features, including faster PDB cloning with virtually no downtime, tighter resource control at the PDB level, ILM Automatic Data Optimization (ADO) policies for PDBs using Heat Maps, and even FLASHBACK recovery for individual PDBs. This 2-hour workshop explores the latest features of 12cR2 Multitenant and provides attendees with practical, hands-on experience as well as numerous code examples that they can immediately leverage when deploying, upgrading to, and migrating to CDBs and PDBs.

Back to Top
Give MAF a REST: Using REST/JSON Services in MAF
John King , King Training Resources
Topic: Database - Subtopic: ADF and MAF

Oracle’s Mobile Application Framework (MAF) builds web applications quickly and easily that port to iOS and Android devices without target-specific customization. MAF applications may use data from Java POJO’s, the local SQLite database, SOAP/XML Web Services, REST/XML Web Services, and REST/JSON Web Services. This presentation shows attendees how to create MAF applications based upon REST/JSON Web Services. The combination of REST and JSON has become the standard mechanism for communicating with mobile applications; MAF developers attending this session will learn how to use them.

Back to Top
The THINGS Are Here! Using Oracle IoT Cloud Service
John King , King Training Resources
Topic: Database - Subtopic: DB Dev

First, the Internet connected us. Then we added computers and network connections to machines and things. Today, many “things” (computers, sensors, devices, appliances, cars, phones, etc.) are connected to the Internet, to our applications, and to each other. The Internet of Things is exploding, and you need to be prepared for it. In this session, you will learn how the Internet of Things is changing our lives. Every day, more use cases appear where we harness the tremendous flow of data coming from “edge” devices to enable better business decisions. Oracle’s Internet Of Things Cloud Service is an instrumental part of this new world. This session will introduce you to IoT and Oracle’s Internet Of Things Cloud Service.

Back to Top
APEX Generator: The Clone Wars
Moritz Klein , MT AG
Topic: Application Express - Subtopic: Real World

Want to see how you can build 120 fully functional APEX pages in under five minutes? Just rebuild them if the data model changed in the same time? Then this session is for you! See the APEX Generator in action and learn how to use the Data Dictionary and APEX Views to automate APEX page creation.

Back to Top
Using R for Data Profiling
Michelle Kolbe , Red Pill Analytics
Topic: BI & Reporting - Subtopic: Other BI and Reporting

The benefits of knowing your data before embarking on a BI project are endless. Sure, you can buy a tool to help with this, or you could use R, an open-source tool. This session will dig into methods for using R to connect to your data source to see visual and tabular analyses of your data set. You'll learn how to find missing data, outliers, and unexpected values. If you don’t know R or you are wanting to learn more functions within R, you’ll benefit from this session.

Back to Top
I've Looked at Cloud from Both Sides Now: Developer Cloud Service or Not?
Peter Koletzke , Quovera
Topic: Database - Subtopic: DevOps/Agile

If, like this presenter, you are a developer or IT professional who has been wary of cloud computing since first hearing about it, your objections to it probably run along the lines of price, complexity, loss of control over your development environment, security, and just good old stubbornness to change. Alternatively or additionally, if you work in an Oracle-oriented shop, the tendency may be to rely on Oracle's products, but your shop is waiting for Oracle's cloud products to mature before jumping in (flying up).

Whatever your opinion about cloud computing in general, and Oracle's competency in cloud products specifically, Oracle Developer Cloud Service is worthy of examination now. Oracle Developer Cloud Service is a Platform as a Service (PaaS) product that provides a complete development environment for creation of applications in any discipline (for example, APEX, ADF, JET, MAX, ABCS, or Forms).

On the "Up" side, this presentation explains this service and how you can use it as an out-of-the-box solution for the full life-cycle of an application, or for integrating some of your own components into the service.

On the "Down" side, the presentation discusses why you may not want to use this service, and, if you do decide to use it, what to avoid when configuring and using the product.

The session closes with an example of setting up Oracle Developer Cloud Service to supply a full application life cycle that includes version control, code reviews, build integration, issue tracking, and deployment phases. You may be pleasantly surprised at what you learn about this product.

Back to Top
Thick Database is Alive: Leveraging the Oracle Database SQL and PL/SQL to Simplify Any User Interface Application Development
Peter Koletzke , Quovera
Topic: Database - Subtopic: DB Dev

Whether you develop applications for an Oracle database in APEX, ADF, MAF, JET, MAX, ABCS, or any other development framework or programming language, the development approach known as "thick database" can provide benefits in productivity, code reusability, and ease of application maintenance. This approach to development evolved from discussions in ODTUG channels over ten years ago.

The thick database approach consists of centralizing most application logic in the database, which greatly simplifies the user interface work. It also shields the application somewhat from UI technology changes, so if an application framework needs to be changed, the amount of code to rewrite is much less than with business logic in the application.

This presentation explains the benefits, principles of, and guidelines for using this approach. It discusses how business rules logic can be centralized and standardized so that application updates due to business changes are much easier. It also describes different levels at which you can use the thick database principles: extreme, modified, and conservative, and how to decide which level to use. It also explains how you would decide which business rules should be implemented in the user interface even if they are also written in the database.

The session also suggests a simple system you can create to track business rules as one part of thick database development as well as a starting point for creating test plans. The session then shows examples of the main SQL and PL/SQL code components you might use to implement thick database principles: table APIs, complex views with INSTEAD OF triggers, and business rules procedures.

Back to Top
A Real-World Comparison of the NoPlsql and Thick Database Paradigms – Part 2
Toon Koppelaars , Oracle Corporation
Co-presenter(s): Bryn Llewellyn, Oracle Corporation
Topic: Database - Subtopic: DB Dev

This is a two-part session.

In our second session, we turn to the Thick Database paradigm, rehearse the reasons for its superiority, and explain that it implies more than just allowing database calls to invoke only PL/SQL subprograms. We formalize a layered code classification scheme which leads to optimal understandability and maintainability of both your PL/SQL and your SQL code -- which properties bring the maximum probability of correct behavior. We will convince participants that adopting the Thick Database Paradigm guarantees the avoidance of the awful problems brought by the NoPlsql paradigm and establishes the database tier as a reliable central service provider in the application landscape. We will debunk the myth that “moving business logic out of the data tier and into the middle tier” improves scalability.

Back to Top
FIU-180 Day Rapid Path Implementation of OBIA 11.1.1.10 -HR Analytics On-A-Budget
Peter Koutroubis , ERP Analysts
Co-presenter(s): Jai Gangwani, ERP Analysts
Topic: BI & Reporting - Subtopic: OBIEE

Case Study: Florida International University (FIU) Utilizing Oracle Business Intelligence Applications (OBIA) Human Resource Analytics (HRA) 11.1.1.9.2; A 180 Rapid Path Implementation of OBIA-HR Analytics On-A-Budget

Back to Top
Transitioning from OBIEE On-Premise to BI Cloud Services
Peter Koutroubis , ERP Analysts
Co-presenter(s): Jai Gangwani, ERP Analysts
Topic: BI & Reporting - Subtopic: OBIEE

Transitioning from OBIEE on-premise to BI Cloud Services.

Back to Top
If You Build It, They Will Come: Transforming Our Close Process with Dashboard Reporting
Teresa Kress , Summit Materials
Co-presenter(s): Tiffany Briseno, Summit Materials
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

Have you always dreamed of a dashboard reporting tool that had the slickest charts, graphs and trend lines to visualize your company’s data? In your dream, was your executive team (yes even your CFO and CEO) using this tool on their tablets or mobile devices with ease, drilling and clicking through regions and business units without bugging you for answers? Were your analysts using this tool to input commentary explaining deviations, not in Excel but directly in this web-based tool? In this dream, were you hailed as a hero with confetti reigning down on you for actually making mobile dashboard reporting work at your company? Does this sound too good to be true? Come listen to how a couple accountants made this happen at Summit Materials in less than a few months’ time. No, really. Don’t believe us come listen to how we mobile-enabled our HFM and Essbase data with CXO-Cockpit.

Back to Top
What's New and Coming in Planning
Prasad Kulkarni , Oracle Corporation
Topic: Planning - Subtopic: Other Planning

In this session you will hear Oracle's strategy for on-premise offering in the Planning domain.

Back to Top
Essbase Cloud is Here. Now What?
Cameron Lackpour , ARC EPM
Co-presenter(s): Tim German, Qubix
Topic: Essbase - Subtopic: Other Essbase

Essbase Cloud is finally among us. But what does that really mean? How does it fit into our existing EPM environments? What does Essbase Cloud actually do that’s better than before? What paths are not taken? In short, does Essbase Cloud live up to its promise? Join Tim German and Cameron Lackpour as they explore and explain Essbase Cloud’s’: architecture, functionality, use cases, cost, and performance. This comprehensive review of the essence of Essbase in the cloud gives you the answers and direction you need to go forward with Essbase now and in the future.

Back to Top
Build Once, Run Anywhere with Oracle Analytics Cloud
Alan Lee , Oracle Corporation
Topic: BI & Reporting - Subtopic: Financial Reporting

Oracle Analytics offers a complete choice of deployment. Oracle Analytics can support full Cloud, all on-prem or hybrid architectures that allow customers to quickly shift as needed. In this session, learn the various architectural options for Oracle Analytics and how customers are taking advantage of these options to meet business requirements.

Back to Top
Oracle Analytics Cloud - A Comprehensive Overview
Alan Lee , Oracle Corporation
Topic: BI & Reporting - Subtopic: Other BI and Reporting

The new Oracle Analytics Cloud provides a comprehensive collection of analytic capabilities to address requirements from the line of business user to the workgroup to the enterprise. Analytics Cloud support use cases such as self-service data analysis, scenario based analysis, data collaboration, and enterprise business intelligence. Learn how you can benefit from Oracle Analytics Cloud today and our plans for the future.

Back to Top
Mastering Universal Theme with Corporate Design from Union Investment
Oliver Lemm , MT AG
Topic: Application Express - Subtopic: Real World

You want to migrate to APEX 5 and the Universal Theme but, until today, you've only seen a few trivial presentations? Furthermore, you want to integrate your's or your customer's Corporate Design? In this presentation, you will get a bunch of knowledge which will help you to migrate to the Universal Theme. The APEX Application FondsProfiler was created in 2011 with APEX 4.1 and Theme 22.
The first step to the Universal Theme is to choose which old templates should be mapped to which templates from the Universal Theme. Then you have to make the choice between keeping the subscription to the Universal Theme and trying to make the design changes only with CSS, jQuery and some copied templates. Or you release the subscription and making changes easier now, but resulting in problems later when going to Universal Theme 1.x.
Another problem in many migrated applications is the big space between your items and the grid layout from the Universal Theme. You will get solutions how to arrange your items near to each other and still using Universal Theme templates.
Mastering design changes with theme roller, be aware of problems like !, important in your and theme roller's CSS. Having customized Tooltips, locking mechanism, or want to color your input fields based on the user's right - these questions will be answered in this presentation.
This presentation will be far more detailed than every other migration presentation you've heard before.

Back to Top
Uncover the Truth
Oliver Lemm , MT AG
Topic: Application Express - Subtopic: Real World

Got an old APEX Application to migrate or extend? Struggling by not knowing how complex the application is and which pages are full of customized code?
Furthermore, you might not know how the pages are related? Join this presentation to get fast answers for your most important questions. It will be presented how to identify which templates have been changed, how much CSS, JavaScript Code, and PL/SQL Code is hidden in your application pages. Even a tree view for the page navigation can be created automatically to understand how your pages are related.
With this information you can understand the application very fast and it’s much easier to make an effort analysis bringing new features to your application.

Back to Top
Analyst Seeks Analysis Tool: An Introduction
Steve Liebermensch , Mensch Consulting
Topic: Essbase - Subtopic: Other Essbase

An introduction to Essbase, you could consider this an Essbase 101 session. In this presentation attendees will learn about the why's and how's of Essbase including very basic design concepts, navigating a couple of the common user interfaces, as well as some the basics for query and reporting.

Back to Top
Taking Your Hyperion Culture from Good to Great!
Steve Light , TransUnion
Co-presenter(s): Robert Kocur, TransUnion
Topic: Planning - Subtopic: Other Planning

Financial planning for a billion dollar companies like TransUnion can feel like a daunting task, but Hyperion provides businesses the right tools to be successful. Hyperion can make it significantly easier to be good at planning, but you really need the right team and culture to be great! Fortunately for TransUnion, the new Global Hyperion Solutions Team and the Hyperion Community of Interest are on the job. Hyperion, as a tool, has been part of TransUnion since 2010 and has proven to be very successful with over 200 Finance and Accounting associates utilizing 19 applications across a truly global organization. The environment has grown to include Hyperion Planning (BSO & ASO), Essbase (BSO & ASO), Workforce Planning, Capex, PFP, Hyperion Strategic Finance, FDM, and Financial Reports. The applications quickly evolved from a few departmental tools to a set of strategic world-wide applications that support all aspects of the business in the US, Canada, Latin America, Africa, India, and Asia. For years, the system was maintained via some heroic individual efforts and a rotating stable of consultants, but in 2016 TransUnion decided to create a dedicated Hyperion team and the Hyperion CoI. This support is a demonstration of the dedication TransUnion has to making sure our end users on the finance team have the best experience possible. In just a few short months, we’ve moved from good to great, and we’re just getting started!

Back to Top
The Importance of User Groups
Debra Lilley , Certus Solutions
Topic: Database - Subtopic: Other Database

In the modern, digital world in which we now live, what is the value of a user group? Can we not get the content from Google, YouTube or Oracle direct? A group of passionate user group leaders will discuss where they think the user group delivers additional value: the networking, the learning, the sharing of stories and challenges, and most of all the fun.

Back to Top
Oracle Analytics - Advanced Data Visualization with Essbase
Philippe Lions , Oracle Corporation
Topic: Essbase - Subtopic: Other Essbase

Explore the possibilities of Oracle Analytics with Essbase and Data Visualization. The session will cover everything starting with the basic connectivity capabilities to more interesting and advanced options using the Oracle Analytics APIs.

Back to Top
PBCS & BICS Better Together: Why, When & How
Lily Liu , interRel Consulting
Topic: BI & Reporting - Subtopic: OBIEE

Oracle has powerful planning and forecasting solutions in the Cloud with PBCS along with easy to use visualizations and dashboarding in the Cloud with BICS. While PBCS has its own dashboarding capabilities, there is still a compelling use case for combining PBCS and BICS into a best practice solution. Join us for this session where we will share with you the “Why” on use cases for PBCS and BICS, the “When” of when it makes sense to combine and what stage of the implementation process, and the “How” of how to actually integrate data between the two solutions. We’ll demo examples of the integrations start to finish and show you the power of BICS on top of PBCS and other data sets from an end user perspective. You’ll leave this session with the tools in your tool belt to implement PBCS & BICS together!

Back to Top
A Real-World Comparison of the NoPlsql and Thick Database Paradigms – Part 1
Bryn Llewellyn , Oracle Corporation
Co-presenter(s): Toon Koppelaars, Oracle Corp
Topic: Database - Subtopic: DB Dev

The NoPlsql paradigm starts with an object oriented domain model in the middle tier. This leads naturally to treating the database as a bag of tables, so that primitive SQL statements express its API. The Thick Database paradigm starts with the design of the relational model. This leads naturally to allowing client-side code only to call PL/SQL subprograms, so that all SQL is done from PL/SQL. These two paradigms are mutually incompatible.

This is a two-part session.

In our first session, we show, based on real-world use cases, how the NoPlsql paradigm brings problems with correctness, security, and performance, and we note that projects that adopt the NoPlsql paradigm use most of their resources on developing plumbing code rather than code that implements actual business functionality. These problems are just the tip of the iceberg and we explain how the NoPlsql paradigm also brings maintenance nightmares.

Back to Top
A Holistic Approach to Database Security
Robert Lockard , Oraclewizard
Topic: Database - Subtopic: DBA

For years we have been locking down the software to protect information. This presentation puts the focus where it belongs: identifying, protecting, and selecting the correct tools to protect your data.
Starting with a brief history of security breaches and the impact to both companies and consumers, the presenter will move through a methodology of identifying sensitive information, creating a risk matrix, and which tools are available to mitigate information leaks.

Back to Top
Rehosting Your On-Premises Hyperion EPM Solution on Amazon Web Services: The Compass Group Story
Jiten Majithia , Infratects
Co-presenter(s): Athanasios Antzoulatos, Compass Group PLC
Topic: EPM Infrastructure - Subtopic: Cloud and Hybrid Infrastructure

Compass Group PLC made a strategic decision to host its internal operational systems on Amazon Web Services (AWS). Through this strategic IT decision, Compass Group PLC partnered with Infratects Consulting to upgrade their HFM Financial Reporting platform to v11.1.2.4 and re-host from an internal, on-premises solution to Amazon Web Services, delivering a new/improved Finance System serving a user-base across 40 countries.

What are some of the conversation and challenges you are facing when thinking of moving your EPM platform to the Cloud? Attend this presentation to hear about some of the key decisions, risks, and business/technology challenges we faced on this journey.

Agenda:
• Basics about on-premises vs. Cloud Implementations for EPM
• History of Compass Group PLC’s decision to move to the Cloud
• Key business & technology drivers for moving their EPM platforms to Amazon Web Services.
• Architecture delivered for the solution
• Challenges faced and lessons learned during Implementation

Back to Top
The EPM Clouds are Rolling in Fast! Is It Really Worth Upgrading My On-Prem System Now?
Joe Malewicki , iArch Solutions
Topic: EPM Infrastructure - Subtopic: Installs and Upgrades

So it’s here. The storm has been brewing and it looks like this time, we might actually see some weather. Yes folks, Oracle is full tilt on the Cloud! Better late than never right? Well – maybe yes, but don’t put up those hurricane shutters just yet.

The reality is yes; everything is headed to the cloud. At some point we’re all going to be wearing our rain jackets and have our umbrellas open as we “sing in the rain” of Cloud based EPM applications. However, this session isn’t about “tomorrow.” It’s about TODAY.

Today you have a fully baked, production running EPM/Hyperion system. You’ve got Essbase cubes crunching data, Financial Management Consolidations firing off daily, Planning web forms being updated every week and finally tons of users with a local version of Excel 2010 on Windows 7 complaining daily “Smart View is too slow!” You’ve got IT and Risk Management stating Microsoft has cut off the version of SQL Server and Windows 4 years ago yet Hyperion is still lingering along on these unsupported platforms. Why? Because you can’t run your business WITHOUT Hyperion.

In this session we’ll help you address and develop a plan with minimal to NO downtime to get your “on-prem” Hyperion installation up to the latest and greatest available from Oracle. We’ll help you decide what makes the most sense for an upgrade path. On-prem hardware, virtualizing, hosted environments, or shared resources. Discussions on 3rd party hosting providers and yes, discussions on Oracle’s Cloud versions of their EPM software stack and how all relates to an upgrade.

We’ll take the mystery out of the upgrade process for the software itself. Discuss the version paths and how to ensure you can get the latest platform support that your organization is comfortable with while still maintaining full support model from Oracle.

You’ll see a LIVE demonstration of “BEFORE” and “AFTER Upgrade” real world EPM application performance and system functionality.

Finally we will discuss just how inexpensive an on-prem upgrade can actually be. The cost and time savings alone should make you head back to the office and start planning the project.

So please join us for this educational and informative session and let’s get you up to where you should be today!

And remember – someone’s “cloud” is just someone else’s “computer.”

Back to Top
How to Get the Most Out of Essbase in the Cloud
John Maloney , TopDown Consulting
Co-presenter(s): Paul Hoch, TopDown Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Essbase in the Cloud has been eagerly anticipated and now that it is finally here we will explore how Essbase in the Cloud can replace, enhance or serve the same role as your current on-premise Essbase environment. This session is a thorough look at Essbase in the Cloud, including a look at the differences between on-premise Essbase and the Cloud offering, what you’re getting and what you’re giving up, best practices for working with Essbase in the Cloud, particularly if you are running a Hybrid EPM Solution, plus tips and tricks for how to make the most of Essbase in the Cloud. This session will also include a review of features like calculations, currency conversions, sandboxes, and other key things you need to know to get started. It will also include real-world examples. You will leave with a solid understanding on how to work with Essbase in the Cloud so that you can start taking advantage of all it has to offer.

Back to Top
What's Cooking with Oracle Smart View for Office?
Al Marciante , Oracle Corporation
Topic: BI & Reporting - Subtopic: SmartView

It was 15 years ago that the challenge of combining the various Hyperion addins for Microsoft Excel into a single common addin was first showcased at the Hyperion Solutions R&D area. This concept was the beginnings of Oracle Smart View for Office that has since expanded to integrate across the Office Suite and become the single addin for our cloud and on-premises EPM, OBIEE/BICS, and Financials Cloud. With each update of Smart View, we deliver powerful new features and functionality to our users, and despite continued innovations in our browser-based interfaces, it remains one of the most used interfaces to our apps. Come to this session to see what new developments are in process, learn new tips and tricks, and network with others in this interactive session.

Back to Top
Your Data Speaks with Enterprise Performance Reporting Cloud
Al Marciante , Oracle Corporation
Topic: BI & Reporting - Subtopic: Other BI and Reporting

Looking at grids and charts only tells part of the story, and often times an incorrect one. Increasingly, we are being asked to explain the “who, when, where, how, and why” to “what” the data is. Giving accurate business commentary to your stakeholders, be they internal or external to your organization, is important. Giving inaccurate or misleading narrative can not only negatively impact a company’s stock price and reputation, but also result in missed opportunities and misallocation of resources. Executing successfully on strategy is understanding where you began, where you are currently at and how to get to the end game, and being able to communicate that effectively to all your stakeholders. To do so requires having your subject matter experts/knowledge workers engaged throughout the reporting cycle, rebalancing their time from hunting and reformatting data to producing quality narrative, having powerful collaboration for the report cycle participants, and strong version/auditing controls. This session will show how to revolutionize your reporting capabilities with:
- Cross Cloud reporting access and integration to narrative reporting documents
- Flexible report phases that provide authoring, approving, reviewing and sign-off with automated notifications and cycle management
- Reference doclet framework that supports data integration from nearly any source with automatic updates to subscribed content
- Automation of key metric data and explanations via a robust variable framework supporting integrity in reporting via values, directional words, static text, etc.

Back to Top
Wrangle & Lasso EPM Data Using Java API
Enrique Marron , General Electric
Co-presenter(s): Abed Bokaie, GE
Topic: BI & Reporting - Subtopic: Other BI and Reporting

Oracle Hyperion EPM modules access data in many different ways, as well as being co-dependent. Some of these dependencies are a Windows operating system, Microsoft Office, a web browser, and various desktop clients. But what we will share is a solution that removes us from that equation completely.
In this presentation, we will take everyone off of the ranch to share a solution that unlocks all users from today’s boundaries of EPM data retrieval and ad hoc analysis.
This unique solution will allow all users alike to still remain true to the core functionality of their EPM data, tools, and utilities that they most likely use today to perform retrievals: a grid-like presentation-style (i.e. row and column format User Interface - UI.) This presentation will take a glimpse into the developed code that leverages the commonly exposed EPM Java APIs.
The benefits users could receive from this work are:
• Essbase Java API
• Operating System Agnostic exposure to EPM Data
• Easy ad hoc analytic data retrieval ability
• User Interface & User Experience in a desired and familiar format
• Common core ad hoc options

Back to Top
IT Made Me Virtualize Essbase and Performance Sucks: Making Essbase Fast In Any Environment
Brian Marshall , US-Analytics
Topic: Essbase - Subtopic: Optimization

We can’t all have an Exalytics box for our Essbase environment. In fact, if you haven’t made it to the Cloud, then you are most likely already on a virtualized environment or being "encouraged” heavily to go to a virtualized environment. This presentation will focus on making sure that your transition is as smooth as possible. We'll discuss specific settings in the virtual environment, the operating system, and Essbase to get the most out of your server. We'll also compare specific benchmarks around different hardware configurations related to CPU, Memory, and Storage. Attendees will receive the new EssBench application for standardized benchmarks to see how your system stacks up. This application is deployable to any Planning server to test various aspects of your server’s performance to identify areas for improvement.

Back to Top
Oracle Data Visualization for the Finance Analyst
Kevin McGinley , Red Pill Analytics
Co-presenter(s): Tim German, Qubix
Topic: Data Visualization & Advanced Analytics - Subtopic: Oracle Data Visualization

Many analysts within Finance are used to manipulating spreadsheets and waiting for enhancements to Essbase cubes to produce reports that need to be shared with their management or peers. This session will demonstrate how all analysts within Finance can get immediate value from Oracle Data Visualization (DV) and decrease their reliance on overly complex spreadsheets. From its ability to connect to many different kinds of data sources, wrangle multiple data sources into a usable format, and visualize insights that would be otherwise hard to see in a table, Oracle DV provides analysts an extra layer of functionality they can easily learn and use without IT intervention.

Back to Top
True Power of Oracle’s Enterprise Planning Suite Unleashed at POET
Ryan Meester , Edgewater Ranzal
Co-presenter(s): Lezlee Herdina, POET
Topic: Planning - Subtopic: Other Planning

To quote Lezlee Herdina, Director of FP&A at POET, “POET’s mission is to live in a world with natural balance. Where we no longer take from the earth, but rather use its enormous ability to regenerate. We will use this tool (Hyperion) to model strategic opportunities to achieve that goal.”

POET, a leading biofuel company specializing in the production of ethanol and ethanol co-products, needed a platform to support its performance management initiatives and ultimately the company mission, which required generating fully integrated Income Statement, Balance Sheet, and Cash Flow projections over a 5 year planning horizon. It needed a system that could provide short-term detailed operational budgeting capabilities for various aspects of the business (i.e. SG&A, Capital Planning, Project Planning) while also delivering a flexible solution to allow for higher level long-range planning. In search of these overall process improvements and efficiencies related to the budgeting and long-range planning processes, POET turned to Oracle and Ranzal to deliver a best in-class solution using Oracle’s suite of EPM applications. During this session Lezlee Herdina and Ryan Meester, Director at Edgewater Ranzal, will guide the audience through the process in which POET and Ranzal worked together, using the “Right tool for the right job” mantra, to unleash the true power of Oracle’s Enterprise Planning suite including Oracle Hyperion Strategic Finance, Hyperion Planning (Including Workforce, Capital and Project Financial Planning!), Essbase, and Financial Data Management Enterprise Edition.

Back to Top
A Story about Data: Anything, everywhere with everyone
Matt Milella , Oracle Corporation
Topic: BI & Reporting - Subtopic: Other BI and Reporting

Summary to come

Back to Top
Thinking Clearly about Testing Performance
Cary Millsap , Cintra Software and Services
Topic: Database - Subtopic: Testing

Testing for functional correctness is generally a matter of specifying the right output for a given input and then using a tool that check whether your code produced the output you specified. Testing performance, though, is a lot harder, even conceptually. You can use a tool to check whether a given function "runs in D seconds or less," but there's more to it than that, because realistic data volumes and loads matter so much. But you can prevent a lot of post-production performance problems without having to spend a gazillion dollars on "perfect" performance testing. In this session I'll help you learn how.

Back to Top
Extreme Essbase Calculations: New Frontiers in What-if, Goal-seeking and Sensitivity Analysis
Ron Moore , TopDown Consulting
Co-presenter(s): Ludovic DePaz, TopDown Consulting
Topic: Essbase - Subtopic: Calculation

Doing what-if isn’t new. As long as I can remember everyone talked about it and the goal-seeking functionality using LOOP has been around for decades. But do most of our calculations use causal drivers or are they “type it in and agg it up” type databases? And how much "what-if-ing" can you really do if the database takes an hour to aggregate?

Today more and more companies are using driver-based designs and recent improvements such as Hybrid Aggregation, new calculation functions, and bigger hardware mean that there are new possibilities. Profit opportunities don’t usually follow simple linear patterns. Well-designed driver-based models capture complex patterns and help identify risks and opportunities that would otherwise be missed. Goal-seeking can significantly reduce the time it takes to set and distribute targets. Sensitivity analysis can help set priorities by identifying the most important drivers. It can also help compare a range of options to identify sweet spots.

First we will examine the business logic behind some useful what-if calculations that help uncover financial dynamics that make a difference in business results. Then we will examine the outline and business rule considerations and options. Then we will dig into the code.
We will show examples of outlines and business rule code for:
• Pushing down top-side budget adjustments
• Driver based what-if calculations
• Goal-seeking for target setting
• Prioritization and range comparison with sensitivity analysis

Last we will show some examples of using these techniques in real-world applications.

Back to Top
Case Study: How Suez Slashed Cycle Times and Improved Service Levels with Hybrid Aggregation
Ron Moore , TopDown Consulting
Co-presenter(s): Brian Brockway, Suez
Topic: Planning - Subtopic: Optimization

Suez owns and operates 16 water and waste utilities and operates 90 municipal water and waste water systems. They had a very large Planning cube and aggregations could take three hours or more. They had to choose carefully which aggregations they did and when. Administration was arduous. This put severe limits on what Suez could do to improve service levels to users.

Suez partnered with TopDown Consulting to optimize the application. TopDown performed a series of tests on more than a dozen optimization techniques. The results provided two good options. FixParralel could reduce aggregation times to about 20 minutes. And even though Suez was on 11.1.2.3.500, the application appeared to be a good candidate for Hybrid Aggregation which would eliminate the aggregation.

In this session Brian Brockway, Manager - IT Applications and Support at Suez and Ron Moore, Solution Architect at TopDown Consulting will describe:
• the tests performed to identify the best optimization options
• the steps to determine if the cube was a candidate for Hybrid Aggregation
• the trade-offs between FixParallel and Hybrid Aggregation and how Suez decided which option to pursue
• the step by step process (including code samples) of converting the cube to hybrid, including cross-dimensional operators, time balances, MDX WITH clauses, and other challenges
• how Suez addressed the effects of some of Hybrid’s disadvantages

Finally, we will describe how Hybrid transformed service levels for users and list the benefits of the conversion.

Back to Top
Creating an APEX Theme for Non-Designers
Vincent Morneau , Insum
Topic: Application Express - Subtopic: Integration

The fastest way to produce a beautiful application is by using APEX 5’s Universal Theme. The fastest way to customize that look and feel is by using Theme Roller. In a matter of hours you can have a unique design using built-in options only. But sometimes that simply won’t fit your client needs.

Not everyone can be a designer, write CSS, or is able to recognize a good design. That being said, I think every APEX developer has the skills to look at any online design and integrate it into APEX.

Integrating a theme is mostly about understanding how to properly copy/paste code in the designated sections of APEX and replacing the hard-coded content with APEX substitution strings.

This session will explain how you can use bits and pieces of an online design to create your own beautiful application. You should be able to ask your client to choose his/her preferred design through an online store and make your application look exactly like it.

Back to Top
Modern JavaScript in APEX: What to tTake and What to Leave
Vincent Morneau , Insum
Topic: Application Express - Subtopic: Detail Plunge

By now, JavaScript is inevitable for all APEX developers.

The rising popularity of JavaScript didn’t make everyone happy. There has rarely been a language that changes so much over time, making it hard to keep up with all the new tools and frameworks that emerge every now and then. This causes most APEX developers to stick to basic JavaScript functionalities.

This session will appeal to intermediate and advanced developers who wants to learn more about modern JavaScript but don’t know where to start.

Among a lot of extraneous tools and frameworks, there has been a few highly adopted standards. We will be exploring the usefulness of MVC Frameworks such as Angular and it’s alternatives like React. We will see how to write cleaner code with namespacing and promises. We will talk about using upcoming JavaScript features with ES6 and Babel and we will look into modularizing code with Browserify.

This session is a go-around what’s available in JavaScript today and knowing what’s useful (or not) as an APEX developer.

Back to Top
Introduction to ADF: Building an Application in 60 Minutes.
Jamie Morrison , Peak Indicators Ltd.
Topic: Database - Subtopic: ADF and MAF

Discover how to create a basic browser based application using the latest version of JDeveloper 12c and Application Development Framework (ADF).

In the session we will start with a blank canvas from which we will build up a working HR application using core technologies and functionality, we will compile it, then deploy it to our Weblogic server where we can see it in action. During the session we will dip in to aspects such as creating data capture forms, skinning, and creating custom menu options.

Back to Top
A Case Study: Implementing EPBCS at Children’s Health Colorado
Bill Mowle , Children's Hospital Colorado
Co-presenter(s): Tracy McMullen, interRel Consulting
Topic: EPM Business Content - Subtopic: Budgeting and Planning Processes

Join us for this informative session where we will review our implementation of Enterprise Planning and Budgeting Cloud Service (EPBCS). Learn how we implemented the pre-built Financials framework of EPBCS in just weeks, implementing driver, and trend-based forecasting for the entire hospital along with initiative planning. We’ll demo our solution, show you what we used out of the box and what we customized, and share lessons learned when implementing EPBCS. We’ll also share how we integrated EPBCS Cloud data with on-premise Essbase and OBIEE. Don’t miss the success story of the first ever EPBCS implementation!

Back to Top
Logging or Nologging: That is the question!
Topic: Database - Subtopic: DBA

The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever," or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?
Redo generation is a vital part of the Oracle recovery mechanism. Without it, an instance will not recover when it crashes and will not start in a consistent state. Excessive redo generation is the result of excessive work on the database. This presentation covers the subject of reducing redo generation using LOGGING and NOLOGGING options, the differences between them, how it happens, how to reduce it, and when to use. Also, you will find examples and tips regarding each one of them.

Back to Top
Tips and Best Practices for DBAs
Topic: Database - Subtopic: DBA

A vibrant session with “Real Tips” for real world daily database problems a DBA could find. Here you will learn how to improve your productivity, how to solve some real DBA problems, and also learn several tips to help you to become a successful DBA. This session is based on some of the most frequent questions I’m asked on my blog and during my presentations. (Version 3 of this presentation.)

Back to Top
Finding the Forest Among the Trees - Designing and Implementing an Analytic System
Michael Nader , Huron Consulting Group
Topic: EPM Business Content - Subtopic: EPM/BI Strategies

Business Intelligence is about three things – analysis, access, and visibility. Increasingly, business analysts are demanding insight into ever-more detailed data. A well designed BI system should not just tell you what happened, but why it happened. It should help you find the needle in the haystack.

This session presents both a case study and tips and tricks around implementing an analytic system and strategy. During the session participants will see live demonstrations of prototype environment as well as discuss design principles and implementation processes.

Back to Top
Solving the Labyrinth – Advanced Essbase Reporting with OBIEE
Michael Nader , Huron Consulting Group
Topic: Essbase - Subtopic: Design

The Oracle Business Intelligence Foundation Suite contains two world-class modeling and reporting engines – Essbase and the Oracle BI Server. Integrating the two engines has, over the years, been complex. Often, the Essbase user community feels like they are losing capability. The reality is very much to the contrary; OBIEE provides opportunities for greater analysis.

This session provides two client case studies and tips and tricks for reporting on Essbase with Oracle Business Intelligence. This session contains live demonstrations of RPD modeling techniques for working with Essbase models, reporting tricks for dynamic filtering of Essbase reports, and leveraging advanced OBIEE capabilities for asymmetric reporting. In addition, the session provides recommendations for Essbase design to support the OBIEE reporting environment.

Back to Top
Enhance Your Cloud Application with EPM Automate and REST APIs
Noah Neal , Key Performance Ideas, Inc.
Co-presenter(s): Steven Wang, Key Performance Ideas, Inc.
Topic: EPM Infrastructure - Subtopic: Cloud and Hybrid Infrastructure

Interested in reducing the time spent in your data loading processes? The EPM Automate utility and REST APIs can help you do just that and much more within the context of Oracle Cloud! Learn how these tools work and can be used for automating processes to save time in day-to-day business activities. These processes include data and metadata import and export, business rule launches, application backup and restore, retrieval of data management process detail logs, and much more. Also learn how EPM Automate and REST APIs can be integrated with scripts to perform a number of different tasks outside of Planning. We’ll be discussing multiple sub-topics to help you get started and optimize automation processes, including:
*EPM Automate vs REST API highlights
*Scripting and syntax
*Email notifications
*Logging & Error Handling
*Nuances
*Maintenance Minimization
*More!
Find out more about how these powerful tools can allow your business to save time and enhance processes!

Back to Top
Eliminating the Eliminations Problem in Essbase
Martin Neuliep , General Electric
Topic: Essbase - Subtopic: Calculation

For as long as there has been Essbase, people building financial applications have wanted to perform intercompany elimination calculations. Unlike HFM, Essbase up to now has not had this capability built in. So what to do, especially if eliminations are a key part of your reporting or planning requirements? Various approaches have been taken over the years and interestingly, there may be no one ideal solution even today.
This session will compare four techniques for calculating eliminations: three purely within Essbase and a fourth using an adjunct relational database. We’ll examine each according to these criteria, so you can choose an approach best suited to your needs:
- Ease of implementation
- Amount of ongoing maintenance required
- Flexibility
- Performance
Code samples will be provided.

Back to Top
Using Oracle R and OBIEE to Help Doctors Predict Areas with the Most Severe Health Problems
Cuong Nguyen Tien , Mindstream Analytics
Topic: Data Visualization & Advanced Analytics - Subtopic: R and Oracle Data Mining

In every field we fight scarcity and shortage. In our session we will talk about the shortage of doctors and healthcare providers. What can we do to help healthcare organizations pick efficiently the areas with specific health problems and invest their efforts there?

Back to Top
APEX and the Thick Database Paradigm
Anton Nielsen , C2 Consulting, Inc.
Co-presenter(s): Richard Soule, C2 Consulting, Inc.
Topic: Application Express - Subtopic: Detail Plunge

The "thick database" concept relies on encapsulating business logic into a pl/sql layer and isolating the presentation layer by providing access only to the pl/sql layer. Thick database benefits include improved adherence to business rules, enhanced security, and improved performance. This approach is often discussed in relationship to Java, Pearl and other mid-tier centric development tools. APEX applications reside in the database, but they benefit from the thick database paradigm as well. This presentation will provide best practices and real-world considerations for thick database implementation within the APEX development realm.

Back to Top
IoT, ORDS, APEX, and JET
Anton Nielsen , C2 Consulting, Inc.
Co-presenter(s): Hayden Hudson, C2 Consulting, Inc.
Topic: Application Express - Subtopic: New Release

Oracle REST Data Service (ORDS), Oracle Application Express (APEX), and Oracle JavaScript Extension Toolkit (JET) have disparate, sometimes overlapping, functionality. This session will review these products and focus on how they compliment the Internet of Things. Hands-on participants will build an IoT device that communicates with an Oracle Database via ORDS. Device data will be displayed via JET components and the device will be controlled by an APEX application. Participants will gain hands-on experience in ORDS, APEX, JET, and IoT hardware.

Back to Top
Creating Your First Database to Access with Oracle's DBaaS (DataBase as a Service)
Rich Niemiec , Rolta
Topic: Database - Subtopic: DBA

This presentation will show the steps to create a Database in the Oracle Cloud using Oracle's Database Cloud Service or DBaaS (DataBase as a Service). It will give the brief steps as well as showing how to use the free test service. We'll also see different methods for testing in the cloud as well as the different uses for the Cloud initially and eventually.

Back to Top
The Best 12c R1 & R2 Query Tuning New Features
Rich Niemiec , Rolta
Topic: Database - Subtopic: DB Dev

This presentation will look at which 12c new features should be investigated for query tuning. Most of the features that will be covered will be related to the developer & DBA. There will be simple examples to show the basic functionality of the new features:

- Using Invisible Columns
- Multiple Indexes on the same Column
- Adaptive Execution Plans
- Runaway Query Management
- Online Move Partition
- Partial Indexes for Partitioned Table
- Enhanced DDL Online
- Other 12c Query Tuning New Features
- Using Oracle In-Memory Database

Back to Top
Break the Shackles of Planning with Hybrid Essbase
Peter Nitschke , Mpower Solutions
Co-presenter(s): Cameron Lackpour, ARC EPM
Topic: Essbase - Subtopic: Design

Planning is Essbase, Essbase is Planning. This powerhouse multi-dimension database enables Planning but then shackles it with BSO’s long aggregation time and ASO’s poor procedural calculations. Hybrid Essbase breaks these architectural constraints by combining the calculation power of BSO with the aggregation performance of ASO and as a result fundamentally transforms how we design Planning applications.

Join Peter Nitschke and Cameron Lackpour as they demonstrate the value of Hybrid Essbase through its impact on real world Planning design. You’ll see multiple Plan Type applications collapsed into one, Plan Types literally small enough to fit on a USB stick, real world performance benefits, and calculation techniques that take best advantage of Hybrid while working around its current limitations. The best use case of Hybrid Essbase is Planning and if you’re a Planning practitioner you should be using Hybrid Essbase. To do that, you need to attend this session and bring our real world Hybrid Essbase experience to your application today.

Back to Top
Unlocking the Power of the APEX Plugin Architecture
Matt Nolan , FOEX GmbH
Topic: Application Express - Subtopic: Integration

In this session you will get an in-depth look into the APEX plugin architecture using a real world example where performance is critical and the techniques used to optimize performance.

We will explore the best practices when it comes to designing plugins, event usage, increasing code centralization, and decreasing maintenance while plugging the functionality gaps in your APEX applications.

Back to Top
Life After Forms: The Move to APEX
Alex Nuijten , allAPEX
Topic: Application Express - Subtopic: Real World

Companies struggle with the question: Should we move to APEX when the time has come to let go of Oracle Forms?
This session will tell the story of a migration project where the Oracle Forms application needed to be replaced with an APEX application. What could we have done better? What are the lessons learned? What was the best choice that we made during this project? Not from the books, but from experience.

Back to Top
Oracle 12c for Developers
Alex Nuijten , allAPEX
Topic: Database - Subtopic: DB Dev

Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you. You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases.

Back to Top
The Hybrid World – RDBMS + Hadoop
Kerry Osborne , Accenture Enkitec Group
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

The hybrid world is coming! There is no doubt that hadoop has established a foothold in traditional enterprises by now. On the other hand, the well-established RDBMS products are far from dead. One of the major problems with hadoop is that the native open source SQL engines are just not as capable as the traditional RDBMS engines. That’s understandable since the traditional RDBMS guys have a 20+ year head start. Oracle for example is the king of the hill with regards to complex transactional systems and has the most powerful SQL engine on the planet. What that means is that moving an application to hadoop generally requires a major effort to re-write the data access layer (i.e. the SQL). Nevertheless, the power and the scalability of the distributed hadoop architecture are undeniable. So why not use the best of both worlds? The combination of the two can create a platform that combines the best of both architectures. This presentation will discuss approaches for building just such a hybrid platform. This presentation includes a case study showing a hybrid architecture combining Oracle and hadoop in an innovative use case that shows ankle bracelet tracking data with a google map interface.

Back to Top
APEX Plugins That I Use in Every Project
Bartosz Ostrowski , Pretius
Topic: Application Express - Subtopic: Real World

Thanks to APEX architecture we - the developers - can create advanced and reusable components called plugins. Ingenuity and creativity of developers results in many free and handy plugins that save time, enhance application, and show that APEX is not just a collection of basic charts and reports.

During this presentation I will talk about APEX plugins that I use in big commercial projects. I will show how you can extend your application and add today's features that are listed in the APEX roadmap for tomorrow.

Back to Top
Adapting to Adaptive Plans on 12c
Mauro Pagano , Accenture Enkitec Group
Topic: Database - Subtopic: DB Dev

Did you notice that many navigation apps can suggest, in real time, to deviate from the initial route because of traffic or accidents?
It's pretty cool right? You wanted to take 5th, but there is an accident so your initial plan doesn't look so good anymore once you hit the road.
Oracle 12c can do the same, the optimizer can generate an execution plan (your route) keeping the door open for changes in case more data than expected is being processed (traffic / accident).
This is a great feature but it requires a little shift in the way we think about performance; we need to be more open to changes just like our nagivation app.
This session focuses on how this feature works, what it means for us, when it can help us, and most important how to look at execution plans that can change after they started their execution.

Back to Top
Full Table Scan: Friend or Foe?
Mauro Pagano , Accenture Enkitec Group
Topic: Database - Subtopic: DB Dev

"Full table scan is bad evil." How many times have you heard this claim? It's one of those myths in the Oracle performance world that never goes away.
It's only a myth and it's just plain wrong! Especially now with all the advancements in the software and not just Oracle.
How many times did you spend hours trying to avoid a full scan, just to find out performance wasn't that great once you get an index used?
This session focuses on why full scan has been demonized in the past, why this claim is false, why Oracle is smart enough to chose a full table scan when it's worth, and how to make sure that once Oracle choses it, the full scans runs at its best.

Back to Top
Modernizing Your DBA Scripts with the Oracle Scheduler
Simon Pane , Pythian
Topic: Database - Subtopic: DBA

As the Oracle Database evolves, so should the way DBAs monitor and manage it. And even though the Oracle Database Scheduler was introduced over a dozen years ago with Oracle 10g, almost all DBA environments still rely heavily on the Linux (UNIX) CRON for scheduling of database monitoring, management, or backup jobs.

But the Oracle Database Scheduler isn't just for developers and application logic. Instead, it should also be the primary scheduling tool for DBAs and DBA scripts; regardless of whether those scripts are SQL based, Linux shell scripts, or Windows command (batch) files.

This presentation convinces DBAs why the Oracle Database Scheduler should be their tool of choice by covering the profound functional and security benefits of using the Oracle Database Scheduler over OS scheduling tools. How to use and manage the Oracle Scheduler effectively, including concrete examples on how to use it with Linux (UNIX) shell scripts and Windows command files is detailed. Finally, exciting new 12c Scheduler enhancements are discussed and demonstrated.

So whether it's for monitoring jobs, management/maintenance jobs, or even a database backup jobs (RMAN or otherwise), it really is "time to schedule with the scheduler" and get rid of all of those old-school CRONs.

Back to Top
Oracle Database Automation: From Snowflake Instances to DBaaS
Simon Pane , Pythian
Topic: Database - Subtopic: DevOps/Agile

Ever wonder why you can spin-up an Oracle Database environment from a public cloud provider in mere minutes yet it takes days to provision and configure one internally?

Oracle database provisioning and management using DevOps style processes may seem like mixing oil and water, but it doesn't have to be that way. In fact, it's very possible without any additional at-cost tools. The resulting automation leads to "efficiency," "standardization," and "consistency" - pillars of scalability for effectively managing large database environments.

This presentation reviews how organizations can implement database deployment and management automation as an underpinning technology for a DBaaS using common DevOps tools such as Ansible to: prepare servers, deploy Oracle software, create databases, implement DR configurations, and customize databases with site specific requirements in a highly automated manner, regardless of whether the host servers are physically on premise or in the public cloud.

The results are databases that are easier to manage, as well as a greatly reduced service time for database provisioning requests. Literally taking the implementation time down from days to less than one hour end-to-end!

Back to Top
Introducing Dimension Management Cloud Services (DMCS)
Robin Peel , Oracle Corporation
Topic: EPM Business Content - Subtopic: Other EPM Business Content

Oracle's Dimension Management Cloud Services (DMCS) is due to be released later in 2017. DMCS is a new application that builds upon the rich legacy of Oracle Data Relationship Management (DRM) for managing dimensions, hierarchies and reference data. This learning session will show you the core capabilities of DMCS, explain its new approach to data stewardship and hierarchy management, and will show you the differences and similarities between DMCS and DRM.
Goals:
· Understand the new capabilities and user interface of DMCS, including request visualization, tailored application views, application adaptors, and the new, flexible versioning model.
· Understand the differences and similarities between DRM and DMCS.

Session outline:
· Short overview of the capabilities and architecture of DMCS.
· Live demo of dimension maintenance in DMCS.
· Compare and contrast DMCS with DRM.

Back to Top
Moving The University of Pennsylvania Hyperion Planning On-Prem to the PBCS Cloud: A Journey of Consolidation, Migration, and Enhancements
Chuck Persky , Performance Architects
Co-presenter(s): Belen Ortiz, Mindstream Analytics LLC
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

The University of Pennsylvania has been using On-Prem Hyperion Planning and Hyperion Essbase for more than 11 years to manage their financial planning and reporting. The original solution design necessitated multiple Planning and Essbase applications to address performance constraints back in 2005. While the solution has been successful in providing planning and reporting capabilities, the challenges of supporting the complexity of this solution have yielded several pain points to the system users.

This session details how The University of Pennsylvania was able to port their solution from 5 traditional On-Prem applications to a single PBCS application enabling real-time enterprise level reporting. This session shows the steps and the results of a system consolidation & migration, and details how new enhancements in PBCS functionality enabled a more integrated and efficient solution. We will also explore design trade offs that produced more real-time reporting for users during the day against initially longer processing times overnight and other lessons learned during the process.

Attendees of this presentation will learn about:
• Introduction of SmartPush the ’push-on-save’ functionality to instantly apply changes in data in the new planning application
• Detail EPM Automate data integration tool
• Enhanced ability to allow users to enter and report on “commentary”
• Expand the capabilities of the calculated forecast
• Lessons learned with migration of on-prem Hyperion Planning applications to the Oracle PBCS Cloud

?

Back to Top
jQuery Widgets in APEX
Tom Petrus , iAdvise
Topic: Application Express - Subtopic: Detail Plunge

In our everyday APEX life, we're using many items and regions, which have a lot of settings. What you may not have realized yet is that many of the implementations are done through jQuery widgets. Sometimes direct, sometimes inderect through a namespaced wrapper. At times, it's very interesting to know what's actually under the hood and how and why things happen. Maybe there are some things that can even be influenced or altered.
In this session, we'll be taking a look at some of the widgets which APEX implements, or in some cases, have been created by the APEX team. We'll see how they function and how they can be manipulated or expanded upon.

Back to Top
Building in Blocks
Adrian Png , Insum
Topic: Application Express - Subtopic: Real World

Communications is an integral tool for building communities. The team behind apex.world wanted an effective communication platform for members to interact, and were confronted with the decision to build or integrate. Find out how popular products like MailChimp and Slack were integrated with the apex.world portal. Learn about the challenges faced by the team and how they were solved with some help from the same community for which that the portal was built. Take home tips and tricks that you can use in your projects!

Back to Top
Capturing and Manipulating Images with APEX and More!
Adrian Png , Insum
Topic: Application Express - Subtopic: Real World

A picture is worth a thousand words. It is common to receive project requirements that include image capture, manipulation, or both. We can opt to manipulate captured images either on the client-side using JavaScript or server-side using Oracle Multimedia. This session will examine the various methods and approaches for implementing an image manipulation solution with APEX. We will also look at computer vision and how to integrate this cutting-edge technology in your applications to make users say, "WOW!"

Back to Top
Virtualization- To Infinity and Beyond!
Topic: Database - Subtopic: DBA

Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security?

This session builds on the impressive customer experience from Kellyn Pot’Vin-Gorman with years of architecting virtualized environments to show how to simply and securely migrate to the cloud. A full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the road-block to projects!

Back to Top
Why APEX is Important to Information Security in Oracle
Michael Potter , Oracle
Topic: Application Express - Subtopic: Other Application Express

This is not a discussion on how to make APEX secure, it’s an overview of how APEX has become integral to various Security focused groups at Oracle. From Incident handling, Security Architecture, to Investigations and forensics, and tracking the hardening of critical systems, even Physical Security uses APEX in the field. I aim to show why APEX has become the tool of choice for so many areas within the I.S space.

Back to Top
How to Best Manage Your Relationships…With Data: Building a Strong Foundation for PAREXEL Using Oracle Data Relationship Management Best Practices
Julia Radovani , Peloton Group
Co-presenter(s): David Harter, Peloton Group
Topic: EPM Data Integration - Subtopic: Metadata management/integration

With the wide-spread popularity of integrated enterprise systems, a need has emerged for data management technology that drives the timely synchronization and alignment of metadata and transactional data. Leading organizations are positioning purpose-built Oracle data management and integration technologies as strategic pillars for achieving analytical and reporting systems expansion.
This presentation will discuss how PAREXEL, a leading clinical research organization, leveraged Oracle Data Relationship Management (DRM) to achieve data alignment and automation efficiency across changing operational ERP and EPM systems. At PAREXEL, DRM was used to consolidate hierarchies, automate the alignment of common metadata structures in target EPM systems, and promote shared data stewardship across Finance and IT functions. Particularly for non-financial master data, DRM enabled critical Project-Client data remediation processes and Organizational modeling capabilities.
In this presentation we will share some industry best practices around data management when integrating Oracle DRM with Financial Data Quality Management, Hyperion Planning, Hyperion Financial Management, and Account Reconciliation Manager. Some of the topics include:
• Mastering financial and non-financial data sets in DRM (Chart of Accounts, Capital Assets, Project, Client).
• Consolidating maintenance of data mapping rules in DRM to guarantee referential integrity and alignment across ERP and EPM data sets.
• Rationalizing data specification errors and re-mediating data quality issues from external applications in DRM.

Back to Top
Four Seasons Hotels & Resorts – Solving the Dynamic Content and Calculation Quandary
David Rae , Iconomics Inc.
Co-presenter(s): Jenever Springer, Iconomics Inc.
Topic: BI & Reporting - Subtopic: Other BI and Reporting

The complexity of Four Seasons’ revenue calculation and reporting process had outgrown their homegrown Excel based solution and was becoming increasingly cumbersome, unable to quickly react to change while also ensuring they delivered timely and accurate reporting to their management.

Learn how Four Seasons leveraged Essbase and Dodeca's sophisticated development capabilities to simplify and streamline the on-going evolution of their revenue calculation and reporting workflow, while providing each hotel the ability to customize the content and calculations required to address their specific needs.

Back to Top
Finally Understand How APEX Works
Peter Raganitsch , FOEX GmbH
Topic: Application Express - Subtopic: Detail Plunge

I know, I know, you already used APEX and have built some fine applications. But do you really understand how APEX works and why it behaves as it does?

Have you ever just tried different things until finally something seemed to work, without actually understanding the what and the why?

Let me try to explain the basics of APEX: the foundation on that all fancy components (IR, Grid, Charts, ...) build up on.

After this session you should be able to understand all the important things: session state, communication, bad and good AJAX calls, and much more.

Back to Top
Let APEX Access Your Computer
Peter Raganitsch , FOEX GmbH
Topic: Application Express - Subtopic: Integration

Web applications are awesome, easy to access from anywhere, but also limited in what they can do. All of that happens for security reasons, of course, and that makes us accept that browser apps (like APEX) can't access any client resources like the filesystem, a printer, or a scanner.

Using the open source Electron project we can build a custom browser, to work around those limitations and extend our APEX applications to do what they need to do.

In this session we will look at what Electron is, how to set it up, and what possibilities there are.

There will also be some easy-to-use prebuilt examples for you to use after the session.

Back to Top
APEX 5.1 Advanced Universal Theme
Shakeeb Rahman , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

summary to come

Back to Top
Transitioning to Oracle Application Express 5 Universal Theme
Shakeeb Rahman , Oracle Corporation
Topic: Application Express - Subtopic: Real World

Oracle Application Express 5 introduces many new features that enable you to quickly build modern and beautiful HTML5 applications. The new Universal Theme implements current design trends and utilizing the new declarative template options, and puts powerful CSS3 techniques at your fingertips. In this session, you will walk through transitioning your existing application to the new Universal Theme. Using some of the packaged apps included with Oracle Application Express 4.2 as examples, we’ll demonstrate step-by-step how to transition these apps to Oracle Application Express 5.

Back to Top
Streaming #Election2016 with Oracle Data Integration
Michael Rainey , Gluent Inc
Topic: Data Warehousing & Big Data - Subtopic: Data Integration

Let’s take a look back at one of the more “interesting" election years in the history of the United States using data produced on that day. And not just any data, Twitter data using the #Election2016 hashtag. With so many different opinions being shared on social media, analysis of this data could provide insight into who might win the public vote. Working with open source technologies such as Logstash, Apache Kafka, and Spark Streaming, we can perform in-flight transformations to prepare the Twitter data for analysis. But what about relational data? Quite often we forget that products incubated in the Apache Foundation can also serve a purpose for “standard” relational databases, as well. Introducing Oracle GoldenGate and Oracle Data Integrator for Big Data. GoldenGate can extract relational data in real time and produce Kafka messages, ensuring relational data is a part of the enterprise data bus. These messages can then be ingested via ODI through a Spark Streaming process, integrated with additional data sources, such as other relational tables, flat files, etc, as needed, and finally published to one or more targets. Working through the setup, configuration and execution of the #Election2016 social media data experiment, this session will ensure attendees will walk away with a framework on which they can build their data streaming projects, combining relational data with big data and using a common, structured approach via the Oracle Data Integration product stack. And hopefully they take away some “interesting" insight into Election Day 2016 on social media.

Back to Top
Essbase Cloud Service: Architectural Evolution
Kumar Ramaiyer , Oracle Corporation
Topic: Essbase - Subtopic: Design

Essbase Cloud Service:  How did it come about?  What are its architectural foundations?  Why does that matter?

To think that EssCS is an evolution of the Essbase we've known and loved since 1992 is to vastly underestimate its power and importance. Moving to the cloud was an opportunity to completely remake Essbase from the ground up -- design, functionality, management, and hardware have all changed and for the better. Understanding the conceptual, architectural, and technical forces that drove this fundamental shift will enable you to extract the true value of this transformation in your current and new applications. 

Join Kumar Ramaiyer, Vice President of Development at Oracle, as he explains how the confluence of development innovations and Essbase resulted in a database unlike any you've seen before.

Back to Top
Oracle Analytics Cloud - Essbase New Capabilities
Kumar Ramaiyer , Oracle Corporation
Topic: Essbase - Subtopic: Essbase-related technologies

summary to come

Back to Top
How to Win Friends and Influence People … with an Integrated Planning-Based Forecast Process
Greg Ramirez , Pepperdine University
Co-presenter(s): Chase Ross, Pepperdine University
Topic: Planning - Subtopic: Other Planning

In this session, you will learn how Pepperdine University transformed an outdated forecast process into one that is forward-looking and engages all areas of the organization by leveraging Hyperion Planning. From a functional standpoint, we will explore the integration of data forms, business rules, and calculation scripts, and how results are delivered to organizational leadership through financial reports.

Back to Top
Fun with Financial Reporting
Michael Reed , Textron
Topic: BI & Reporting - Subtopic: Financial Reporting

Summary to come

Back to Top
Deploying REST Services at Scale
Kris Rice , Oracle Corporation
Topic: Database - Subtopic: Other Database

REST powers the Oracle Cloud. From how customers build and deploy REST services, to how the cloud itself is built. This session will cover how Oracle REST Data Services is deployed in the Oracle Public Cloud at scale. This includes auto configuration for adding capacity on demand, security, tiered architecture, and lots more.

Back to Top
REST Enabling the Oracle Database
Kris Rice , Oracle Corporation
Topic: Database - Subtopic: DB Dev

This session will demonstrate how quickly one can install and configure Oracle REST Data Services (ORDS) to provide/serve REST endpoints on both RESTful Services and Database Objects themselves.

A brief overview of REST concepts will be followed by a demo of ORDS being installed in less than 5 minutes.

Then a series of demos showing how easy it is to REST enable a table and use GET/POST/DELETE to provide a full CRUD API to your data, including complex scenarios involving complex data types like SDO_GEOMETRY and rich web applications that can take advantage of JSON.

REST is the new development paradigm and the Oracle Database is 100% ready with the addition of ORDS.

Back to Top
Deliver a Knockout with Your APEX Applications
Jorge Rimblas , Insum Solutions
Topic: Application Express - Subtopic: Integration

KnockoutJS provides two-way data binding between JavaScript and DOM elements and it's also the foundation for OracleJET. Whether you use OracleJET or not, KnockoutJS can deliver more pizzazz to your APEX pages. If you often feel your Dynamic Actions are getting too complex, or they are one line of code away from disaster, this session is for you. Come and get a short KnockoutJS tutorial and learn how to integrate it with APEX.

Back to Top
JavaScript and CSS for PL/SQL Developers
Jorge Rimblas , Insum Solutions
Topic: Application Express - Subtopic: Integration

If you have been working with the Oracle Database for a while, but still feel lost when working with JavaScript and CSS in your APEX applications, then this session is for you. Working with HTML, JavaScript, and CSS doesn't have to be hard. Learn about CSS selectors, what is the DOM and working with it, JavaScript functions, and even some jQuery. This session will provide you some tools to work better with web technologies.

Back to Top
EPBCS Workforce and Strategic Workforce Planning In Action
Mark Rinaldi , Oracle Corporation
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Learn how customers are leveraging EPBCS Workforce Planning and Strategic Workforce Planning to complete their Headcount Planning based on Supply and Demand Planning.

Back to Top
Understanding How a Tweet Goes Viral Using Oracle Big Data Spatial and Graph
Mark Rittman , Rittman
Topic: Data Visualization & Advanced Analytics - Subtopic: Other

A series of tweets I posted about my 11 hour struggle to make a cup of tea with my WiFi kettle ended-up going viral, got picked-up by the national and then international press, and led to thousands of retweets, comments and references in the media. In this session I'll use Oracle Big Data Graph and Spatial to understand what caused the breakout and the tweet going viral, who were the key influencers, and how the tweet spread over various countries in a matter of hours.

Back to Top
Making Smart Devices Even Smarter (Including iKettles) with Oracle Cloud and Oracle Big Data Discovery
Mark Rittman , Rittman
Topic: Data Warehousing & Big Data - Subtopic: Data Integration

My story about taking 11 hours to make a cup of tea with a WiFi kettle was a fun story that went viral around the world, but it was really a story about data, analytics, and the value in bringing these internet-connected devices together. In this session we'll look at how IoT devices can be connected together, their data streams combined and analyses in real-time, and insights gained via Oracle Big Data Discovery used to make these devices even smarter.

Back to Top
Browser Developer Tool Essentials for APEX Developers
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
Topic: Application Express - Subtopic: Detail Plunge

If you are an APEX developer, you do use a browser to create applications that do run in a browser. Thus the browser is one of your primary tools. When you are developing in SQL or PL/SQL, your IDE (SQL Developer, TOAD, PLSQL Developer, …) offer you lots of functionality to support your work and enhance productivity. But building web applications, development is not limited to database objects. Suddenly you need to work with HTML, CSS, and JavaScript. Although APEX is doing a great job in hiding this complexity with a declarative approach, the more you develop with APEX, the more you will get into these techniques. Suddenly, you will need your browser beyond it’s rendering capabilities, and indeed, modern browsers are more like an IDE nowadays.
Debugging, testing, performance tuning, these are just a few aspects that you can do with your browser. This presentation will go through the latest techniques and features that browsers have to offer for us (APEX) developers, things you should know and use.

Back to Top
Hitchhiker’s Guide to the Universal Theme
Christian Rokitta , rokit - themes4apex - APEX SmartPivot
Topic: Application Express - Subtopic: Other Application Express

When APEX 5.0 was released, it came with an entirely new theme: The Universal Theme. This theme impressively showcased several new features that where built into this new Application Express release: Themestyles, Template Options, Themeroller. These features, and how these are leveraged by the Universal Theme, made building a modern UI much easier and enhanced the User Experience of APEX applications. All an APEX developer must know is how to use these declarative features. So, let’s have a look at these in detail and the state of Universal Theme in APEX 5.1.

But with declarativity comes limitation, and for someone familiar with CSS, Themeroller is “Mostly Harmless." Using the Universal Theme as a standard, the “Answer to Life, Universe and Everything …”: 42, eventually all APEX applications will somewhat look similar. So, what about customizing Universal Theme to really fit your design needs? Well, it’s not that easy, but possible. I’ll show(case) some options.

Back to Top
Essbase Optimization from the Experts Panel Session
Edward Roske , interRel Consulting
Topic: Essbase - Subtopic: Optimization

BSO, ASO, hybrid, Essbase Cloud, Exalytics, virtual machines... with all these Essbase technologies, is there a standard for optimization anymore? In this panel, some of the top Essbase experts of today, tomorrow, and yesteryear will gather to share their wisdom and debate whose wisdom is more correct. Fireworks will definitely ensue as competing optimization tips fly around the room. Relationships may be strained, feelings may be hurt, and brains may be impacted, but rest assured that you will come away having learned that in the world of Essbase, while there is no right answer, there sure are a whole lot of wrong ones.

Back to Top
It's All About The Data: Oracle BI Cloud Service (BICS) Data Sync and Remote Data Connector
Doug Ross , Performance Architects
Topic: BI & Reporting - Subtopic: OBIEE

As more companies move their BI environments to the cloud, loading and accessing enterprise data will become as important as front-end visualizations. Oracle's BI Cloud Service (BICS) offers two options for those data requirements that go beyond simple data uploads: Data Sync and Remote Data Connector. This session will demonstrate how to use each tool and offer tips on improving data load and data query performance.

Back to Top
DevOpsify DBA tasks
Bjoern Rost , Pythian
Topic: Database - Subtopic: DevOps/Agile

Organizations are struggling to manage and standardize an ever increasing number of
database deployments. This presentation shows how scripting and automation tools can
be used to provision databases and to manage resources like users, tablespaces,
instance parameters, and settings in general.
With this setup one can manage a large range of systems from a very small set of
descriptive text based configuration files. More so, these configs are easily managed in a
revision control system like git enabling agile workflows for database change
management.

Back to Top
Oracle & Apache Kafka: Stories from the Message Bus Stop
Bjoern Rost , Pythian
Topic: Database - Subtopic: DB Tools

Apache Kafka is a massively scalable message queue that is being used at more and more places connecting more and more data sources. This presentation will introduce Kafka from the perspective of a mere mortal oracle DBA and share the experience of (and challenges with) getting events from the database to Kafka and possibly even back using different solutions and connectors.

Back to Top
Natural Language Voice Interface to the Oracle Database
Christoph Ruepprich , Accenture Enkitec Group
Topic: Application Express - Subtopic: Real World

Natural language voice interfaces have become quite popular, especially with mobile devices. Apple's Siri and Google's "OK Google" have come quite a long way, and are very good at interpreting the human language. A relatively new player on the marked is Amazon's Echo, a standalone speaker that accepts voice commands and questions, searches for answers on line, and answers back in a human voice.
The technology behind the Echo is Amazon's Alexa API. This API is available for developers to create their own natural voice interfaces.
We are going to explore how we can use the Alexa API to access an Oracle database to perform spoken inquiries like "How much does Miller earn?", "Who works in the research department?", or "Who earned the highest commission in sales?"
The results will not only be spoken back to the user, but can also be displayed in the Alexa mobile app as well as in APEX.
There will be a live demo of asking questions to an Amazon Echo device, and have it answer with data queried from the database.
A basic understanding of JavaScript and PL/SQL will be beneficial to the participants.

Back to Top
Leverage HFM APIs to Automate Part of Your HFM End of Month Process Without Scripting
Beatrice Sagroun , Grant Thornton LLP
Topic: Financial Close - Subtopic: HFM

What options exist to automate HFM processes? Some would say, "Well, just use HFM Taskflows" but there are some tasks you cannot do in it. So what happens when you need to automate something not available? Happily, Oracle provides an alternate tool to enable more flexible automation with less restriction on which tasks you can automate. This tool is called JHAT (Java HypCon API Tester), previously HAT. It is already located on the HFM server and uses HFM APIs. As an example, if you need consolidations to run in a specific order then need to extract data to an Essbase cube, this can be done using JHAT. During this session, we will discuss JHAT, how it works, where you can find it, examples of automations, and how you can use it with other EPM tools.

Back to Top
End to End Automation for Oracle PBCS Using EPM Automate
Amit Sahasrabudhe , ADI Strategies
Co-presenter(s): Sumit Deo, Huron Consulting Group
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

This one hour session on PBCS automation aims to cover all automation aspects that one would encounter in a PBCS implementation. We will discuss the different options available within PBCS to automate tasks such as data loading, running calculations, and archiving application artifacts. We will start the session with a brief overview of the EPM Automate utility that will be used to perform a majority of the automation tasks. Next, we will shift focus to Data Management (FDMEE) and learn how the EPM Automate utility can be used to automate tasks for Data Management like uploading a file to Inbox/Outbox folder of Data Management and running a rule to load data from Data Management to PBCS application. In the second half, we will discuss the automation aspects of the PBCS application to cover native data load processes being used and see how metadata can be updated and refreshed. We will also cover automating map reporting application processes. In the end, we will walk through automating the back-up process so that your PBCS application can be backed up daily to an archive folder. This one hour session will cover end to end automation including logging into PBCS, uploading files, running rules, uploading data and metadata files, refreshing metadata and finally automating backups. We will share some code examples with you so it can serve as a quick start for your PBCS automation.

Back to Top
12 Things Developers Will Love About Oracle Database 12c Release 2
Chris Saxon , Oracle Corporation
Topic: Database - Subtopic: DB Dev

Oracle Database 12c Release 2 is here!

The headline features are Sharding, Multitenant and Application Containers. But it's the improvements to SQL that make a real difference in your day-to-day life work with Oracle Database.

In this session Chris gives you an overview of the changes to SQL and PL/SQL that will help you build faster, more robust database applications.

If you're a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you!

Back to Top
SQL Magic!
Chris Saxon , Oracle Corporation
Topic: Database - Subtopic: DB Dev

In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL "magic tricks" including:

- Sawing the Query in Half: starting with a normal query, Chris will split it into smaller and smaller chunks that somehow all give the same result!
- Find the Card: After getting an audience member to choose a "card" (row) from a "deck" (table), Chris will find it by making it float to the top of the table.
- The Magically Changing Data Type: watch as a number changes to a date and back again!

But unlike real magicians, he'll show you how the tricks work. This will enable you to perform your own "SQL magic” and build better Oracle database applications.

This session is for developers and DBAs looking to expand their SQL skills. It highlights features that are new to 12c as well as little used existing options.

Back to Top
Ask the Experts - An Informal Panel for FDMEE Integrations
Anthony Scalese , Edgewater Ranzal
Co-presenter(s): Francisco Amores
Topic: EPM Data Integration - Subtopic: Data management/integration

Tired of trying to get your FDMEE questions answered in other panels that span all the EPM technologies? Perhaps you are considering an upgrade to FDMEE, maybe you have already upgraded and are missing key functionality, maybe you are trying to understand your options for cloud integration with FDMEE, or maybe you just want to learn more about what you can do with FDMEE.

In this session, two of the industry's foremost experts in data integration - Tony Scalese and Francisco Amores Torres - will host an interactive panel with the audience. Tony and Francisco will share their knowledge drawing on their vast experience implementing and upgrading FDMEE. This session is vital to anyone that wants to learn more about FDMEE.

Back to Top
FDMEE Scripting - Cloud and On-Premises - It Ain't Groovy, But It's My Bread and Butter
Anthony Scalese , Edgewater Ranzal
Topic: EPM Data Integration - Subtopic: Data management/integration

So you've made the transition to FDMEE and now you want more. FDMEE scripting is what empowers you to do more with the application. In this session, we will explore how to use FDMEE scripting to enhance and streamline your integrations. We'll explore how to use Jython and the various APIs within the EPM stack to take your application to the next level. Have a hybrid FDMEE cloud deployment? That's cool, let's look at Groovy and EPMAutomate and see how FDMEE can function as your automation hub.

This session will be most useful for those with a solid FDMEE foundation and some familiarity with scripting languages.

Back to Top
Testing the Various Feeds
Topic: EPM Business Content - Subtopic: Case Studies

This is a test session for the proofing of various feeds. This is only a test.

Back to Top
OBIEE Going Global! Getting Ready for More Than +140k Users
Co-presenter(s): Rodrigo Radtke de Souza, Dell
Topic: BI & Reporting - Subtopic: OBIEE

A standard Oracle Business Intelligence (OBIEE) reporting application can hold more or less 1200 users. This may be a reasonable number of users for the majority of the companies out there, but what happens when an IT leader like Dell decides to acquire another IT giant like EMC and all of their combined 140,000-plus users need to have access to an HR OBIEE instance? What does that setup looks like? What kind of architecture do we need to have to support those users in a fast and reliable way?

This session shows the complexity of Dell’s OBIEE environment, describing all processes and steps performed to create such environment, meeting the most varied needs from business demands and L2 support, always aiming to improve environment stability. This architecture relies on a range of different technologies to support that huge amount of end users such as LDAP & SSL, Kerberos, SSO, SSL, BigIP, Shared Folders using NAS, Weblogic running into a cluster within #4 application servers.
If the challenge was not hard enough already, all of this setup also needed to consider Dell’s legacy OBIEE upgrade from v11.1.1.6.9 to v11.1.1.7.160119, so we will explain what were the pain points, considerations and orchestration needed to do all of this in parallel.

Back to Top
America’s Next Top Model-er Feature
David Schleis , Insum Solutions
Topic: Database - Subtopic: DB Tools

Oracle SQL Developer Data Modeler (SDDM) is a remarkably useful tool, but despite all of the books, blogs, and presentations some of its most powerful functionality goes unused. Scripting within SDDM allows you to make modifications to your model, make sure that your models conform to your standards, and also create customized reports that can be used for import into other tools such as Jira.

This session is an introduction to the powerful scripting capabilities found in SDDM, and contains numerous examples of scripts and the SQLgr library that will help you capitalize on the wealth of information captured within your models.

Back to Top
Feelin’ Groovy – Scripting with SQLgr Hands on Lab
David Schleis , Insum Solutions
Topic: Database - Subtopic: DB Tools

SQL Developer Data Modeler (SDDM) and SQLcl both provide the ability to enhance their power through scripting. While the default scripting language is JavaScript, fortunately Groovy can also be used. Groovy is an incredibly powerful and versatile scripting language already a part of a number of Oracle tools. Groovy is easier to learn than JavaScript and allows you to do more with less code.

This presentation is an introduction to the Groovy language and the SQLgr libraries. Focus will be placed on Groovy features specifically in regards to their use in the scripting of SQLcl and SDDM. Knowledge of these features, along with the SQLgr libraries, will allow attendees to begin building their own scripts immediately when then they get back to work.

Back to Top
Tips and Tricks: Debugging a Broken Calc
Chris Schulze , The Hackett Group
Topic: Essbase - Subtopic: Calculation

Have you ever had a perfectly good calc script or calc manager rule fail to write the numbers you expected? This debugging guide will give you a reliable, reusable approach to resolve that pesky bug. You will walk out of this session with a simple list of things to try that will identify most of the bugs you’ll encounter. You’ll get done faster, and through the process, substantiate unit testing proof to satisfy your customer.

Back to Top
EssCS: The New Old Essbase
Glenn Schwartzberg , interRel Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Remember when Essbase could be installed from a floppy disk? You could get a cube up and running in a couple of days. Well, those days are back with the new Essbase Cloud Service (EssCS). Essbase in the cloud takes us back to simpler times where you can build an Essbase database with a simple Excel spreadsheet template. All you need is Excel and Essbase on the Cloud. Join us for the session where we will walk you through Essbase Cloud Service and how to build Essbase applications in the 21st century. Don't miss this chance to get to know (reacquainted with) the new-old Essbase.

Back to Top
High Performance APEX (Or Don't Keep the Users Waiting)
John Scott , APEX Evangelists
Topic: Application Express - Subtopic: Real World

Whether you need to support 10 users or 1000 users, its important to understand how your application performs. In this session, I will cover the entire stack performance and show how you can debug which area of your APEX application is causing the bottleneck.

Back to Top
Oracle APEX - NLP, AI, and Bot Integration
John Scott , APEX Evangelists
Topic: Application Express - Subtopic: Integration

Natural Language Processing (NLP), combined with AI, and Bots are hot topics right now. In this session we will cover exactly how you can integrate these technologies into your APEX applications to really make your APEX applications user friendly.

Back to Top
Data, Data Everywhere But Not a Metadata Dictionary to Read
Christian Screen , Datavail
Topic: BI & Reporting - Subtopic: OBIEE

Until recently, the use of a data dictionary or metadata dictionary in most organizations has been an understood value-add need but still an unfulfilled desire. If business users could understand where dashboard data was coming from and what the data columns actually mean, then more confidence, governance, and usage in the reporting system could be achieved. The undertaking of compiling a metadata dictionary across a potential slue of candidate data sources can seem daunting or as fluff for IT, but the business users know the importance of understanding the meaning of their data and data lineage. How can a better, more usable metadata dictionary be created for Oracle BI? How can a data dictionary be controlled or used to its utmost potential? Why do you need a data dictionary? And, Who will maintain it? This session provides clear innovative answers to these questions and more by taking the audience through creating an ideal metadata dictionary, showing best practices for maintaining it, and how to report accurately from it to support any reference or data governance concepts in your BI program.

Back to Top
I Know Why the On-Premise Oracle BI Applications Sings: Migrating OBIA to the Cloud
Christian Screen , Datavail
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

Cloud solutions continue to expand into the mainstream with obvious material value for businesses that have historically focused on their on-premise solutions. With all major concerns for security in the cloud addressed by bank grade encryption, integration by REST APIs and other supported interfaces, and a growing base of supported production customers, the concerns are turning to action. But there are still lingering questions on architectural best practices and the general approach to move from on premise to the cloud especially for multi-tiered solutions such as Oracle BI Applications. Questions are now less about concern and more about how to move forward. How much of the on-premise software architecture can be migrated to the cloud? And, how can it be done with best practices with the least risk and exposure? And, while getting it right the first time? This session discusses best practice architecture for migrating the Oracle BI Applications to the cloud. It focuses on the Oracle cloud platform and database services, with a nod to infrastructure services, to lay out the idea of the hybrid cloud, and variations of the new age cloud BI/DW architecture for your analytics environment to succeed while operating at the same reliability or better all the while benefiting from what the cloud offers best.

Back to Top
Introducing the Oracle Tax Reporting Cloud
Marc Seewald , Oracle Corporation
Topic: Financial Close - Subtopic: Financial Close in the Cloud

Corporate taxation continues to receive significant focus from regulators. Because of this there is an increasing need to connect tax reporting with financial and management reporting. The new Oracle Tax Reporting Cloud Service offers a single solution for all tax reporting requirements and keeps you connected with other ERP and EPM reporting processes. The solution automates such processes as the tax provision and Country by Country Reporting (required for the new OECD BEPS - Base Erosion and Profit Shifting initiative). This session will be very relevant for any existing Oracle ERP & EPM customers.

Back to Top
World-Class Marketing Planning with Oracle Cloud
Marc Seewald , Oracle Corporation
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

In this session, learn how combining Oracle Enterprise Planning Cloud for marketing financial planning with your current customer experience (CX) investment can help align your marketing and finance plans. The solution enables you to plan the financial impact of marketing campaigns, ensure that the actual marketing spend is aligned with the budget, and calculate the return on marketing investment. The solution gives marketing leaders confidence in driving their business forward because it integrates with your current CX system to provide a strategic and seamless marketing platform.

Back to Top
Creating Mobile Applications using Application Express 5
Marc Sewtz , Oracle Corporation
Topic: Application Express - Subtopic: New Release

Learn how you can declaratively build a compelling mobile application that uses some of the latest HTML 5 capabilities, with Application Express. No hand crafting or in-depth knowledge of JavaScript or AJAX is required. Instead bring your SQL knowledge and discover how quickly you can build Web-based mobile applications using the Oracle Application Express declarative framework.

Back to Top
Advances with Packaged Apps
Marc Sewtz , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

The packaged apps included in Oracle Application Express have grown to become popular business solutions in their own right. “Turn-key” productivity applications like P-Track, Customers Tracker and Opportunity Tracker are widely used by customers inside and outside Oracle. And the collection of Sample Apps is an indispensable tool to learn more about how to take full advantage of product features like the Universal Theme and the Interactive Grid. In this session we will showcase some of the most commonly used apps, highlight the coding standards and best practices that are used in packaged app development and demonstrate how you can unlock and fork these apps to review their implementation and add your own extensions.

Back to Top
APEX 5.1 Advanced Charts
Marc Sewtz , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

summary to come

Back to Top
APEX 5.2 Preliminary Features
Marc Sewtz , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

to come

Back to Top
How To Determine The Financial Cost Of Running A SQL Statement In The Cloud
Topic: Database - Subtopic: DBA

Poor performing SQL statements "cost" an organization in many ways. But assigning an actual dollar amount has been extremely difficult... until the cloud came along. Why? Because cloud customers are charged based on computing resource usage. And, Oracle keeps great statistics on SQL statement usage. So, why not just combine the two?

Imagine what you can now do. You can determine how much money each SQL statement costs per month. What is the costliest SQL statement in your entire application? You can even ask predictive type questions. For example, if I reduce a statement's buffer gets from 1M to 100K, how much money will the organization save each week or just during the month end close?

All these questions and many more can now be answered with precision. In this presentation I will show you how to answer these types of questions referencing standard AWR data.

Back to Top
Using ASH In Unusual And Helpful Ways
Topic: Database - Subtopic: DBA

Oracle Active Session History (ASH) data gives the Oracle DBAs an incredible performance activity data set. ASH analysis is based on looking at many "pictures" of active Oracle sessions. ASH analysis is usually focused on summarizing the session data or watching a session moment by moment.

It is common for DBAs to treat ASH data like time model data. It's easier to express performance in terms of time instead of samples and percentages. It's just natural. But if the DBA is not careful, these inferences lead to incorrect thinking and poor recommendations.

With this all in mind, there are, shall I say, less conventional yet powerful performance analysis applications using ASH data. In this presentation I focus on a few of these unusual ways to use ASH data, some of which provide insights and provide the DBA with analysis capabilities that AWR data does not provide.

The unusual uses presented are appropriately inferring Oracle wait event times, understanding SQL_ID plan change, and estimating SQL statement's wall time. And, because this is based on ASH data, this information is available during a specific time range. As you can see, ASH is even more amazing than you may have thought before!

Back to Top
Developing JavaScript Applications: The Oracle Offering
Shay Shmeltzer , Oracle Corporation
Topic: Database - Subtopic: DB Tools

JavaScript might be the most used development language out there today. In this session, we'll review Oracle's tools and framework for developing applications with JavaScript. We'll talk about the complete ecosystem Oracle has built around JavaScript discussing and demo-ing Oracle JET, Oracle Application Builder Cloud Service, Oracle Developer Cloud Service, and more. Learn about the architecture and the relationships between the various products and when they'll be useful for you.

Back to Top
SQL Tuning 101
Carlos Sierra , Accenture Enkitec Group
Topic: Database - Subtopic: DB Dev

SQL Tuning is a complex and intimidating area of knowledge, and it requires years of frequent practice to master it. Nevertheless, there are some concepts and practices that are fundamental to succeed. From basic understanding of the Cost-based Optimizer (CBO) and the Execution Plans, to more advance topics such as Plan Stability and the caveats of using SQL Profiles and SQL Plan Baselines, this session is full of advice and experience sharing. Learn what works and what doesn't when it comes to SQL Tuning.

Back to Top
Sunday SQL Tuning Workshop
Carlos Sierra , Accenture Enkitec Group
Co-presenter(s): Mauro Pagano, Accenture Enkitec Group
Topic: Database - Subtopic: Other Database

SQL Tuning is a Science. SQL Tuning is an Art. You may have heard both claims. SQL Tuning can indeed be a complex task requiring the use of some attributes of both brain hemispheres: Analytical Thinking and Creativity. If we want to enhance our SQL Tuning skills we may need then to take them both into consideration.

This 4-hour training session includes two aspects of SQL Tuning. It provides practical knowledge by diving into the "4 T's" of SQL Tuning: Techniques, Tips, Tricks and Tools; and it arouses our troubleshooting skills by using some case studies, guiding participants towards possible solutions. Analytical and Creative Thinking are both taken into consideration and practiced within a friendly environment where there is no such thing as a dumb question.

The targeted audience for this "Practical SQL Tuning" session is both Developers and DBAs, with a desire to increase their SQL Tuning skills within a dynamic and participate-rich environment. Open questions are welcomed; sharing knowledge and experience is encouraged and expected. Topics of interest are selected by participants at the beginning of the workshop, then immediately voted on. Content sequence of this workshop is driven by weight of topics voted on.

Back to Top
Understanding SQL Trace, TKPROF, and Execution Plan for Beginners
Carlos Sierra , Accenture Enkitec Group
Topic: Database - Subtopic: DB Tools

On this session participants will learn about producing a SQL Trace then a summary TKPROF report. A sample TKPROF is navigated with the audience, where the trivial and the not so trivial is exposed and explained. Execution Plans are also navigated and explained, so participants can later untangle complex Execution Plans and start diagnosing SQL performing badly.

Back to Top
Going Beyond Finance into Operations with Oracle's Planning and Budgeting Cloud Service (PBCS) at the Largest Oracle EPM Cloud Deployment to Date for Nearly 3,000 Users Worldwide
Luke Sinnen , SC&H Group
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

At the enterprise level, cloud computing is transforming operational effectiveness, creating strategic value, and helping today’s global businesses to gain a true competitive advantage. In this session, you will see how the largest Oracle Planning and Budgeting Cloud Service (PBCS) deployment to date changed how the organization manages it budgeting and forecasting capabilities. Specifically, this presentation will focus on how the PBCS application became a budgeting and forecasting tool that is intuitive, easy to use, scalable and fast on a modern technology (PBCS). Ultimately, this case study showcases how any large global organization can benefit from Oracle EPM Cloud solutions in ways that create long-term operational efficiencies and competitive advantage.

Back to Top
From APEX App to Apple App Store – Simple Steps for Successful Submission
Stephen Smith , CampaignShortCuts
Co-presenter(s): Roel Hartman, APEX Consulting
Topic: Application Express - Subtopic: Real World

Want to learn how to prepare your APEX app for successful submission to the Apple App Store? This session will show you how to program the needed requirements and navigate the process steps to publish your app in the App Store.

Back to Top
To the Cloud and Beyond!!
Kristi Smith , eCapital Advisors
Topic: BI & Reporting - Subtopic: OBIEE

As the number of companies entering the Cloudsphere continues to grow, the need for a step-by-step guide on how to begin your Oracle Business Intelligence Cloud Service (BICS) journey becomes increasingly more important. Even if you are contemplating purchasing BICS, this session will give you more details on what you get with BICS and how BICS works. After all, even Buzz Lightyear himself needed a little training before he became a space ranger hero. Before you can begin to capitalize on the benefits of the cloud, there are a series of steps you will need to walk through in order to get started with BICS. This session will outline what you get with your initial purchase, we will discuss the Data Loader and Data Sync Utility, as well as instructions on how to model your data and start building data visualizations. As with most superheroes and BI Consultants alike, time is of the essence, so come and learn how to quickly get up and running with BICS, so you can be on your way to saving the galaxy!

Back to Top
SQL Developer: Three Features You're Not Using But Should Be
Jeff Smith , Oracle Corporation
Topic: Database - Subtopic: DB Tools

You write SQL, get results.

You click around objects, get data to Excel.

You write PL/SQL, compile it and view your errors.

That describes what 80% of our users do in Oracle SQL Developer. This session will expose 3 features that will turbo-charge your experience with SQL Developer and the Database. This session aims to make you more productive and valuable to your Oracle Database development organization.

Learn how to take those 600 files you currently have all of your hand crafted SQL in and turn them into interactive reports.

Learn how to find stuff in your database by taking advantage of PL/Scope and our search feature.

Learn how to build your own screens - that's right, learn how to use a bit of basic XML and SQL to extend SQL Developer to do what you want it to do.

Back to Top
SQLcl & SQL Developer Tips & Tricks
Jeff Smith , Oracle Corporation
Topic: Database - Subtopic: DB Tools

Fewer keystrokes, fewer clicks = more code, more productivity, more fun.

This session concentrates on the power features that most users bypass when using Oracle SQL Developer and our new command line interface, SQLcl. Do you use all of the shortcuts available to you? After this talk, you'll know how to get what you want, as quickly as you want.

We're rebuilding this session from scratch. That's right, in 2017, this talk will be BRAND NEW. So if it's been awhile since you've seen it, come back and get caught up.

As always, our goal is for each attendee to pick up one to three techniques that will drastically impact their productivity and save them time when working with Oracle Database.

Back to Top
Agile/Scrum, a New Way to Manage Your Project Development and Delivery
Michael Smith , TopDown Consulting
Co-presenter(s): Steven Densford, Starbucks
Topic: EPM Business Content - Subtopic: Other EPM Business Content

Scrum, one form of Agile software development, has been used successfully at Starbucks on many projects. Scrum and Agile Software Development are topics that continue to be discussed but very few people can actually put their real world experiences on display like we can. This session will look at the process from the initial design discussions through the development of the product backlog and on into the bi-weekly sprints for development. The key roles will be discussed which include the Scrum Master, Product Owner, and team members (developers). Some tools will be discussed, as well. Our team has found ways to adapt our past experiences successfully into Scrum and make it successful. It's not all roses, we will also share our challenges with Scrum and how we have overcome them.

Back to Top
APEX 5.1 Advanced Interactive Grid
John Snyders , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

summary to come

Back to Top
Hands-On Training: Using the Cloud (or Oracle Virtual Box) to build a DBA practice environment
Richard Soule , C2 Consulting, Inc.
Topic: Database - Subtopic: DBA

For those who really want to learn the how and why of building an Oracle Database system from scratch, this is your session! Bring your own laptop, or use one of our hosted servers and we’ll walk through the complete installation and configuration of an Oracle Linux desktop, Oracle Grid Infrastructure with Oracle Restart and ASM including ACFS, Oracle Database 12c Multitenant, Oracle APEX, SQL/Developer and SQLcl and more. Best practices from building databases for real world deployments as well as from teaching Oracle Database Certification classes will be included throughout the session.

Back to Top
Cash Flow 2D vs. 3D – How to Make Your Data Stand Out
Matt Spencer , Finit Solutions
Topic: Financial Close - Subtopic: HFM

Come explore various approaches to everyone’s favorite financial – the Cash Flow Statement. Learn the difference between the two-dimensional (using 2 HFM dimensions) and three-dimensional (using 3 HFM dimensions for additional detail) approaches, different ways to tackle each, and which one may be a better fit for your business. A brief overview of the Statement of Cash Flows will be provided – no CPA certification required!

Back to Top
GET POST ORDS JSON: Web Services for APEX Decoded
Scott Spendolini , Sumner Technologies
Topic: Application Express - Subtopic: Real World

Web Services in the APEX world are becoming more and more popular. However, there is still a lot of confusion as to what they are and how they could benefit the APEX developer. After a review of the syntax and jargon associated with web services, this session will review and boil down web services to their basic components. It will then demonstrate how APEX developers can start to use these powerful components - both to send and receive data from other sites.

Back to Top
Secure Your APEX Applications with APEX-SERT
Scott Spendolini , Sumner Technologies
Topic: Application Express - Subtopic: Real World

Application security is at the forefront of IT and will remain there for a long time. Thus, it important to consider security on day one of your application’s development. APEX-SERT is an open-source tool built in APEX that is designed to help evaluate your APEX applications for potential security issues. Not only will it identify them, but it will also offer advice on how to remedy them. APEX-SERT also offers the ability to create and approve exceptions in the case of either a false positive or an issue that is mitigated outside of APEX.

Back to Top
APEX Localization
Topic: Application Express - Subtopic: Real World

Terms "translation" and "localization" are often used interchangeably, while the differences are quite significant. If we want to create professional international application we must not only care about language, but also about elements that appeal to regional or cultural preferences including text direction, formats, calendars etc.
During this presentation I will show:
- how localization process works
- how you can cover it in APEX using built-in features, plugins and open source projects like OraOpenSource and translate-apex.com
- how you can use good practice from video game industry to create international APEX applications

Back to Top
Building a Basic Demo Application using Oracle Application Express
Jason Straub , Oracle Corporation
Co-presenter(s): Patrick Wolf, Oracle Corporation
Topic: Application Express - Subtopic: Real World

This one “double” session (two-plus hours) is designed to take you through building a comprehensive application using Application Express. It 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.

Back to Top
Using the Developer Cloud Service with Exadata Express Cloud Service
Jason Straub , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

The Oracle Developer Cloud Service is a team development environment that includes automation for building software releases, and continuous integration during your development lifecycle. The Oracle Exadata Express Cloud Service is a full Oracle Database experience delivered as a managed cloud service running on Exadata and provisioned in minutes - all at an affordable entry-level price. This session will give an overview of each cloud service, and describe how the two services can be easily integrated together, to provide a very robust development platform.

Back to Top
Migrating to Essbase Cloud: Why, When, and How
Ronnie Tafoya , interRel Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Essbase is finally in the cloud! So should you consider migrating to the cloud? Join us for the session where we will introduce and demo Essbase cloud services. We will show you all the features and functions available in EssCS, show you what is the same between on prem and the cloud, and what is different. We will review how the steps to migrate your Essbase applications to the cloud and what roadblocks and pitfalls to look out for. We will then show you how to maintain your Espace applications in the cloud. - dimension builds, data integrations, automations, and more. Essbase in the cloud is not for everyone just yet – come to the session to learn when and why it would make sense for you.

Back to Top
Hyperion Financial Reporting will be an ACE IN THE HOLE with these tips and tricks
John Taylor , Vertical Edge Consulting Group
Topic: BI & Reporting - Subtopic: Financial Reporting

Financial Reporting Studio can be used to create all kinds of different reports. It works across most EPM Suite of products no matter if it on the cloud or on-premise. Even though it is widely used, it is not wisely used in many cases. Join this session to get tips, tricks, and warnings that will help you get the most out of your Financial Reporting Studio reports.

Back to Top
Do more with Data Pump: Tips and Techniques
Biju Thomas , OneNeck IT Solutions
Topic: Database - Subtopic: DBA

Datapump was introduced in Oracle Database 10g, and has evolved over the versions with various features and performance improvements to migrate data and objects. The legacy export (exp) / import (imp) utility is still maintained in all versions of database including 12c for backward compatibility, and to migrate legacy data to newer versions of database. In this session the speaker shows you how to extend datapump for your various data and object migration needs outside of copying a table or schema. You will learn to export public and private database link and synonyms, various object filtering and row filtering techniques, improving performance of data pump operations, migrate data without using any space for dump file, changing storage properties during export and import, and methods to verify the contents of export dump file.

Back to Top
HFM Admin’s Life Made Easier with EPM Maestro, WebSymphony, Admin Switches and Some Copying!
Paulo José Thrige , FLSmidth A/S
Topic: Financial Close - Subtopic: Other Financial Close

For several years FLSmidth has been using HFM for the Financial Consolidation and has been using tools and techniques to reduce the workload on recurrent manual procedures. This is done by re-use of scripts with EPMMaestro (third party tool) that include multiple tasks like copying, calculation, consolidation and process management – See how to build a script in a few minutes that does it all! For the users the addition of WebSymphony (web part of EPMMaestro) have given the users some features that HFM cannot do or is cumbersome to do.
In addition, we have reduced the need for frequent rules loads (due to business changes) by adding rules logic that are triggered by values in trigger accounts in order to turn on rules like Process Management Locks. The recent EPM upgrade from 11.1.2.1 to 11.1.2.4 also made it necessary to explore the new tools for migrating and copying HFM applications between different environments.

The presentation covers topics like:
• EPMMaestro
o What does it do and why should I bother?
o Adapting to the world of Java
o Scripting – Let’s get under the hood!
o Examples on recurrent Closing tasks run by EPMMaestro
• Websymphony
o Extending the HFM tools with nice features
o Run elevated tasks by regular users
o Transparency in your application
• Admin switches – Turn your rules on and off without having to load rules.
• Copy, copy, copy
o Import Application, Duplicate Application and HFMCopyApplication – How do they work and when to use them?
o Unorthodox application migration by DB Magic

Back to Top
What a Successful OBIEE 12c Upgrade Project Looks Like: Liberty Global - Customer Case Study
Francesco Tisiot , Rittman Mead
Topic: BI & Reporting - Subtopic: OBIEE

OBIEE 12c is the latest generation of Oracle's Enterprise analytics and reporting tool, bringing with it many powerful new features. Many users are still on earlier releases of OBIEE 11g or even 10g, and are looking to understand how they can move to OBIEE 12c to benefit from its new capabilities.
Liberty Global are a global telecommunications company, with a long history with OBIEE going back to 10g. They wanted to move to OBIEE 12c in order to use the new Advanced Analytics options, and used Rittman Mead to support them with the full scope of the upgrade.
In this presentation we will see what a highly successful OBIEE 12c migration looks like. We will cover clear details of all the steps required, and discuss some of the problems encountered. Regression testing is a crucial step in any upgrade and we will show how we did this efficiently and accurately with the provided Baseline Validation Tool. This presentation will assist all attendees who are considering, or in the process of, an OBIEE 12c upgrade.

Back to Top
Introduction to Java and the Essbase Java API
Tim Tow , Applied OLAP, Inc.
Topic: Essbase - Subtopic: Other Essbase

Many Essbase customers and partners have requirements that extend beyond the 'out-of-the-box' capabilities shipped with the product. Thankfully, Essbase is a platform that features a very robust Java API that provides nearly endless possibilities allowing customers the ability to leverage their Essbase investment. Attend this session to learn the basics of how to get started with the Java programming language and with the Essbase Java API.

Back to Top
Introduction to the EPM REST APIs
Jake Turrell , Turrell Consulting
Topic: EPM Data Integration - Subtopic: Cloud Integration

Oracle's EPM REST APIs allow developers to automate and integrate their environments using any programming language with an HTTP client library. This session will provide attendees with a tour of the EPM REST API landscape and will give developers concrete examples they can build upon themselves. Users will leave this session with an understanding of basic REST concepts and the confidence to develop their own REST API integrations for Planning, Migrations and Data Management.

Back to Top
Digital Transformation: Strategy for Moving from Legacy to Enterprise Mobility
Mia Urman , AuraPlayer
Topic: Database - Subtopic: ADF and MAF

As mobile becomes the primary means for accessing information, enterprises must find a way to accelerate mobilization. The Oracle Mobile Cloud is the missing ingredient to create mobile apps at the speed of your business and empower the front lines of your business with back office data. Oracle Mobile Cloud Service provides built-ins for push notifications, object storage, user management, analytics, and an API designer and catalog. But what should you do if your business is stuck with a mountain of Oracle Forms or EBS? How can you leverage your existing business logic while transforming the user experience to the digital world? In this session we will discuss how to begin your mobile journey; Including real life examples of customers who have been successful at it! This session will also include demos of how Oracle Mobile Cloud Service makes it possible for customers to mobile-enable their legacy systems.

Back to Top
Oracle Analytics Mobile - Disrupt the Enterprise (In a Good Way)
Jacques Vigeant , Oracle Corporation
Topic: BI & Reporting - Subtopic: Other BI and Reporting

As mobile technologies have been introduced, usage patterns have evolved beyond traditional roles and office hours. Mobile analytics have witnessed the security challenges of bringing your own device, the need to provide continuous access to corporate information, and a requirement to tailor role-based content to individual consumers. This session examines how Oracle Business Intelligence Mobile has addressed these expanding market challenges, including the innovative Day-by-Day app.

Back to Top
Take Control of Your HFM Environment
Henri Vilminko , Infratects
Topic: Financial Close - Subtopic: HFM

Which users have been active in HFM during the past year? How many concurrent users are accessing the system during busy periods? Why is the volume of HFM data growing so fast? What Financial Reporting reports are used most frequently? These are the kind of questions that Financial Management administrators often need to answer. In this session I will show you how to get answers to the aforementioned questions - and more - using tools that are available without additional cost.

Back to Top
What’s New, What’s Next: Oracle Planning and Budgeting Cloud Service
Shankar Viswanathan , Oracle Corporation
Co-presenter(s): Prasad Kulkarni, Oracle
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

Oracle Planning and Budgeting Cloud Service (PBCS) is one of Oracle’s broad selection of enterprise-grade cloud solutions delivered via software as a service. This session provides an overview of this solution and an update on new and planned functionality.

Back to Top
Starting with Oracle Data Science in the Cloud
Tim Vlamis , Vlamis Software Solutions
Co-presenter(s): Cathye Pendley, Vlamis Software Solutions
Topic: Data Visualization & Advanced Analytics - Subtopic: R and Oracle Data Mining

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 science and predictive analytics. We 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. We'll share excerpts from our 3-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. We’ll help you stand up instances in in the cloud, do data science projects on your data, show you how to use Oracle Data Mining and Oracle R, and help you pick the right starting point for your organization.

Back to Top
Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, a Pizza Box, a Raspberry PI, Apex, JET, and the Oracle IOT Cloud
Jerry Ward , Viscosity North America
Co-presenter(s): Paul Hicks, Kaminario
Topic: Application Express - Subtopic: Integration

In this session we “science the #$%!”* out of a Raspberry Pi 3, Apex and the Oracle Internet of Things Cloud (*ref. The Martian Film). The Automatic Dependent Surveillance–Broadcast (ADS-B) is a precise satellite-based surveillance system that broadcasts real-time weather and uses GPS technology to determine any aircraft's location, airspeed, other date, and relays that data to air traffic control, aircraft, and to us because we are listening! We log and store this data in the Oracle IOT Cloud, then use Apex to build a simple application to view this data in real time and report on it over time.

Back to Top
Data Stories: Predicting Asset Prices with Oracle Data Visualization Desktop, Data Collection, and R
Jerry Ward , Viscosity North America
Co-presenter(s): Kevin McNelis, Nutrabolt Life Sciences
Topic: Data Visualization & Advanced Analytics - Subtopic: R and Oracle Data Mining

Data has a story to tell, and if told correctly, data can predict the future. In this session we aim to predict the future value of any asset through storytelling. We illustrate this with an intriguing tale using a technique that you can apply to the purchase or sale of your next car, boat, home, or airplane. We use a popular business aircraft as an example to tell this story. You will learn how you can quickly and easily: scrape the data from a market website, use Oracle Data Visualization desktop to identify the price drivers of this market, and the final result into a simple R statement that will predicts the future!

Back to Top
Enterprise PBCS Enables Integrated Planning for the Merger of Citrix’s GoTo and LogMeIn
Matt Ward , Peloton Group
Topic: Planning - Subtopic: Cloud Technologies - PBCS & EPBCS focused

For many organizations, financial and business planning is a complex process facilitated by time consuming spreadsheet activities including preparation, data input, performing calculations, producing reports, and executing reviews. This process is repeated monthly, quarterly, and annually such that the effort consumed by the disparate offline processes, and ultimately the costs of these tasks, are compounded over time. And for organizations going through a merger these inefficiencies and costs are multiplied further, as planning processes are typically required for the combined entity in addition to the legacy standalone entities. But it does not have to be that way...
Oracle’s Enterprise PBCS solution provides a path for the rapid deployment of integrated planning business processes in the most common functional areas including Financials, Workforce, Capital, and Projects. Using the configurable features of these out-of-the-box capabilities, organizations are presented with an opportunity to dramatically reduce the effort and cycle time of planning processes, while doing so at lower overall cost.
The session will share the story of the merger of Citrix’s GoTo division with LogMeIn. Enterprise PBCS was implemented in just 10 weeks to facilitate combined planning and reporting for the new organization, leveraging all four business processes within the product suite. This session will be co-presented with Oracle Product Management.

Back to Top
We Make Energy Happen: Oracle EPM Client Success Story at Williams
David Wells , Williams
Co-presenter(s): Arijit Chanda, Williams
Topic: Essbase - Subtopic: Essbase-related technologies

After an enterprise-wide reorganization, the FP&A group was faced with growing business requirements, slow and outdated systems, missed deadlines, and frustrated users. Learn how Williams super-charged its EPM environment using Planning, Essbase ASO, and Dodeca to cut processing times from 4 hours to 15 minutes and increase data capacity by over 10 times. With the system bottlenecks removed, the Finance organization is not only meeting deadlines, but performing more comprehensive analyses and other projects neglected previously due to system restraints.

Back to Top
Accelerating Oracle BI Apps with Essbase 12c
John Whitaker , Huron Consulting Group
Topic: BI & Reporting - Subtopic: OBIEE

In this case study, see how the Essbase 12c features of Oracle BI Foundation Suite improve the performance of the Oracle Business Analytics Warehouse. Oracle BI Applications are designed to drill from highly aggregated reports down to the detailed records. Learn how to identify and prioritize the analytical use cases that will benefit from query acceleration. Specific attention will be paid to Financial, Human Resources, Time & Expense, and Project Analytics.

Back to Top
Handling Textual Data in Planning and Essbase: A Starbucks Case Study
Jordan Wilcox , TopDown Consulting
Co-presenter(s): Rhonda Brigham, Starbucks Coffee Company
Topic: Essbase - Subtopic: Essbase-related technologies

Handling text data in a Hyperion Planning application is relatively easy and straightforward. Planning metadata is stored in a relational database. This textual information is accessible via web forms, HFR, and Smart View out-of-the-box. On the other hand, managing and reporting on text data is not quite as simple in the Essbase technology. Essbase handles dates and smart lists but can’t handles freeform text values. The situation is further complicated by the fact that your smart lists need to be synchronized between Planning and Essbase for the data transfer to be accurate. In this session, Jordan Wilcox, TopDown Consulting, and Rhonda Brigham, Starbucks, will discuss how they used a creative approach to get text data in three different forms–smart lists, dates and freeform text data–to flow from Planning to Essbase. They will discuss the overall project goals, technologies, POCs, and the reason for choosing the solution they did, including design and results.

Back to Top
APEX 5.1 Other Advanced New Features
Patrick Wolf , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

summary to come

Back to Top
Introduction to APEX
Patrick Wolf , Oracle Corporation
Topic: Application Express - Subtopic: Other Application Express

Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is aimed squarely at those who’ve only ever heard of Application Express or are just starting out.

Back to Top
Essbase Does it, but Dodeca Makes It Easy! (The Sequel)
Stuart Yasukochi , St. Jude Medical, Inc.
Co-presenter(s): Doug Pearce, Analysis Team
Topic: Essbase - Subtopic: Essbase-related technologies

St. Jude Medical identified three key technical hurdles to converting their worldwide planning applications to a single ASO database. Learn how Currency Translation, Workforce, and Supporting Details’ complex functionality was achieved using core Essbase functionality with Dodeca’s versatility. Seamless integration between relational input views and Essbase provided for employee-level workforce planning and generalized supporting details inputs. Simple operations in BSO are not so simple in ASO such as currency conversion. Join us to learn how SJM was able to surmount these obstacles with increased efficiency and reduced complexity.

Back to Top
How To Succeed in Planning Without Really Trying: Practical Application of Past KScope Sessions
Tim Young , Walmart
Topic: Planning - Subtopic: Administration

As we attend sessions and webinars, we pick up some great ideas from our fellow ODTUGers. But often we end up with as many questions as answers. We see cool Planning utilities, but the syntax looks like gibberish. Error trapping is cool, but what good is it? Can I update my Planning outline without blowing up my application? Can I test my load file without actually touching the repository tables? What’s the point of being able to save an LCM Migration definition? Member formula development in Planning is cumbersome, can I speed it up? How can I add 300 users across a dozen domains to a Security group without taking all week? My on premises cube won’t load and recycling services didn’t fix it, can I get it moving without bringing down the Windows server?

There has to be an easier way! There is, and we show the way by attacking these questions and more, showing you the path to making the system speak to us instead of screaming at it in the wee hours.

Back to Top
Leveraging Oracle Database In-Memory to Accelerate Business Analytic Applications
Kai Yu , Dell EMC
Topic: Database - Subtopic: DBA

By introducing In-Memory column store, Oracle Database In-Memory (DBIM) significantly improves the performance for analytic queries as well as mixed workloads. Come to this session to learn Oracle Database In Memory under the hood: the dual format memory architecture and configuration, how the data is populated into In-Memory column store and it helps query performance. . This presentation also covers further enhancements of DBIM in Oracle Database 12cR2: Join group, and In-Memory expression, In-Memory active Data Guard support, etc. Through some case studies of business analytics projects, this presentation covers the practices of leveraging DBIM to improve the query performance of business analytic applications and how to use In-Memory adviser to determine the objects that need to be loaded into In memory column storage . We also will present some analysis on the performance gains by using IM memory features and when and how these gains can be achieved.

Back to Top