APEX, 9:00 AM - 11:00 AM Grand Oaks G
#LetsWreckThisTogether APEX Talks - UPDATED!
BI, 9:00 AM - 11:00 AM, Cibolo Canyon 8/9/10
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.
Database, 9:00 AM - 11:00 AM, Grand Oaks E/F
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.
Essbase, 9:00 AM - 11:00 AM, Grand Oaks H
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.
EPM Infrastructure, 9:00 AM - 11:00 AM, Grand Oaks I
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
- Maintenance minimization
Find out more about how these powerful tools can allow your business to save time and enhance processes!
Big Data and Data Warehousing, 9:00 AM - 11:00 AM, Grand Oaks A/B
The Great Debate: Where Should My Data Warehouse Live?
Michael Rainey, moderator, Gluent, Inc.
The long standing debate of running your data warehouse on premises versus in the cloud continues at the KScope17 Big Data and Data Warehousing Thursday Deep Dive session. Whether built in a traditional, relational database or constructed from “schema on read” data in Hadoop, the recent rise of cloud services over the past few years has led data architects, IT directors, and CIO's to ask the question: “Where should my data warehouse live?” Several experts in the Oracle data warehousing field will provide arguments for their preferred approach, while attempting to refute evidence presented for the alternative solution. Along with what should be a lively and engaging debate, the experts will join together to answer any questions you may have around big data, data warehousing, and data integration in general. Don’t miss this great debate and Q&A; session!
Financial Close, 9:00 AM - 11:00 AM, Grand Oaks C/D
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!
Planning, 9:00 AM - 11:00 AM, Cibolo Canyon 2/3/4
A Deep Dive into All Things Planning from On-Premises to PBCS to EPBCS
- 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