APEX

#LetsWreckThisTogether APEX Talks

Just in case you have not received enough inspiring content by the end of the week, the #LetsWreckThisTogether APEX Talks are 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 most well-known speakers and personalities in the APEX world. The exact lineup will be announced closer to the event.

OK, let’s do it!

Back to the Top


BI

Navigating the Oracle Business Analytics Frontier

Panel Moderators - Kevin McGinley, Red Pill Analytics, and Tracy McMullen, interRel Consulting

Saddle up and dig in your spurs as we trail blaze through Oracle’s Reporting, Business Intelligence, and Data Visualization solutions. Through a rotating panel of experts from Oracle, partners, and customers and interactive discussions with attendees, we’ll navigate Reporting and BI challenges and how Oracle Business Analytics addresses those requirements. Led by moderators Kevin McGinley and Tracy McMullen, the panel will discuss questions such as, “Should I use Smart View or Data Visualization or Oracle Analytics Cloud?”, “How do these solutions work together, and when should I use what?” and, “What are the considerations for moving to the Cloud?” Our panel will share thoughts and perspectives on today’s reporting, BI, and DV questions, climate, and trends. We reckon you won’t want to miss this EPM and BI reporting rodeo in Thursday’s Deep Dive Session.

Back to the Top


Database

A Real-World Comparison of the NoPlsql and Thick Database Paradigms

Bryn Llewellyn, Oracle Corporation, and Toon Koppelaars, Oracle Corporation

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 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 all SQL is done from PL/SQL. These two paradigms are mutually incompatible.

In this Deep Dive Session, we present the empirical findings acquired over many years of extensive hands-on experience of building, and tuning, applications that use Oracle Database. We have worked with applications that use the thick database paradigm and with ones that use the NoPlsql paradigm. So, we mean what we say by "real-world comparison." Additionally, we will present and discuss the results of a very carefully designed and conducted apples-to-apples experiment to compare the performance characteristics of the two paradigms. We show that the thick database paradigm is two to three orders of magnitude better than the NoPlsql paradigm, and we enable attendees to repeat our experiment.

Back to the Top


Essbase

Essbase Cloud – How You Do It: Live Demos and Expanded Q&A

Tim German, Qubix, and Cameron Lackpour, ARC EPM

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 the Top


EPM Infrastructure

Enhance Your Cloud Application with EPM Automate and REST APIs

Noah Neal and Steven Wang, Key Performance Ideas

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 subtopics to help you get started and optimize automation processes, including:

  • EPM Automate vs. REST API highlights
  • Scripting and syntax
  • Email notifications
  • Logging and 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 the Top


Big Data and Data Warehousing

Squeegee Your Third Eye: Building an Analytics Platform on New-World Technologies

Robin Moffatt, Rittman Mead

Beyond the hype of big data, the way in which we build systems for analyzing and storing our data is genuinely changing. In this Deep Dive Session, we'll look at how an existing Oracle-based ETL and Data Warehouse were rewritten to take advantage of new technologies. It will include discussion of Apache Spark (compute), HDFS (storage), and Presto, Drill, and Impala (SQL-on-Hadoop querying). We'll discuss why it's worth re-examining the de facto platforms and patterns with which we currently work, and the benefits that new ways of working can bring: specifically, lower costs, greater flexibility, scalability, and portability.

Back to the Top


Financial Close

Campfire Stories: Tips for Making Life Easier for the Financial Close Administrator

Chris Barbieri, Finit Solutions

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 homemade 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 the Top


Planning

A Deep Dive into All Things Planning from On-Premises to PBCS to EPBCS

  • Roadmaps
  • Functionality differences between on-premises Planning, PBCS, and EPBCS
  • Migration from on-premises to Cloud
  • Simplified user interface
  • Excel-based application creation
  • Q&A with Oracle regarding product strategy and roadmap

Back to the Top