ODTUG OOW 2015 Sunday Sessions

ODTUG is pleased to participate in Oracle OpenWorld, October 25 through October 29 in San Francisco. 

All sessions should be posted soon to the OpenWorld Content Catalogue. 

EPM

UGF9980: Redesigning Hyperion Planning BSO to Hyperion Planning ASO
Cindy Eichner, The Finit Group

Day:     Sunday, October  25, 2015
Time:    8:00 - 8:45 am
Room:  Moscone South Room 302

Users will be introduced to a true life case of a Hyperion Planning application with two plan types and 13 dimensions, including the challenges faced, performance issues, and design decisions that were made when implemented in a previous 11.1.2 version. Next, the users will be taken through the decision process to redesign the application using an ASO plan type.  Topics covered will include performance, metadata updates challenges without EPMA, user experience, and administration.  Finally, the outcome of the conversion will be reviewed including comparisons of performance, user experience, metadata updates, administration, and interfaces to FDM, HFM, EPMA, etc.

UGF4112: OBIEE The Oracle Smart View Way 
Wayne Van Sluys, interRel Consulting, LLP

Day:     Sunday, October  25, 2015
Time:    9:00 - 9:45 am
Room:  Moscone South Room 302

With the release of OBIEE 11.1.1.7, Oracle Smart View became yet another tool for creating OBIEE Content. The use of Oracle Smart View allows people to use the tools they know to analyze data while making use of the established subject areas within OBIEE.

UGF7215: Creative Hyperion Planning Design: With Planning, There is No Box 
Edward Roske, interRel Consulting, LLP

Day:     Sunday, October  25, 2015
Time:    10:00 - 10:45 am
Room:  Moscone South Room 302

In Hyperion Planning, there are the obvious ways to design applications (many of which result in cubes that are way too big, way too complex, and take way too much effort to maintain) and then there are the more creative ways.  In this session, you'll learn better ways to reduce dimensionality, how to use both ASO and BSO plan types successfully, methods for making your driver-based budgets more dynamic, ways to reduce form count by using user variables, and more.  We'll even cover creative uses for Planning outside of the world of budgeting & forecasting (one company used Planning for expense report entry).  If you want to not only think outside the box but you want to blow it up, join us as we cover the creative side of Planning design.

 UGF2145: ASO, BSO, or Hybrid:  Which Flavor of Essbase Should I Use? 
Cameron Lackpour, Citadel Informatics, Inc. dba CL Solve

Day:      Sunday, October  25, 2015
Time:    11:00 - 11:45 am
Room:   Moscone South Room 302

Conventional wisdom has been to do complex calculations in BSO, partition the results to ASO, add limited calculation there and then report.  Is that the only model?  ASO has a powerful procedural calculation language as well as MDX formulas.  Does Hybrid change everything when it comes to BSO?  Is there still a place for traditional BSO?  Join Oracle ACE Director Cameron Lackpour as he explores aggregation, FX and allocation use cases in each engine, then shows when, where, and how each is best used.  Areas covered:  Calculation use cases:  accounts, YTD, QTD, MTD, aggregations, formulas, and allocations;  which engine and why:  BSO, ASO, partitioning, or Hybrid;  how do I write it in; getting there the fastest, with the mostest.

UGF9979: A Deep Dive into HPCM for the Planning and Essbase Professional 
Mike Killeen, Edgewater Technology - Ranzal, Inc.

Day:     Sunday, October  25, 2015
Time:   12:00 - 12:45 pm   
Room:  Moscone South Room 302  

This session will provide a deep dive into how the various HPCM model types work for the Planning and Essbase administrator or consulting professional. Standard, detailed, and management ledger model types will be reviewed and insight provided as to how HPCM works by relating its algorithms to a language the Planning and Essbase professional will understand. Time for Q&A will be provided at the end.

UGF9983: Advanced Calculations in Calc Manager 
Ron Moore, TopDown Consulting

Day:     Sunday, October  25, 2015
Time:    1:30 - 2:15 pm
Room:  Moscone South Room 302

Essbase has for years been capable of advanced calculations such as predictive analysis, projections, rolling calculations, allocations and driver based planning. But implementing these advanced calculations on working databases frequently involved significant manual effort, repetitive code and limited re-usability. The Calc Script and Business Rules editors provided little help in debugging and optimizing.

Now new features in Calc Manager make developing, optimizing and reusing your code much easier.

In this session we will use several advanced calculations to show how to use CM to build reusable components that can be more widely deployed with less effort.

UGF10834: HBSO to ASO: Can We? Should We? How Do We? 
Sarah Zumbrum, interRel Consulting

Day:     Sunday, October  25, 2015
Time:    2:30 - 3:15 pm
Room:  Moscone South Room 302

ASO aggregations are fast. Really fast. No having to wait minutes or hours while the cube aggregates and calculates.   No storing massive amounts of data at all levels of a cube on a server. This seems like a dream! However, there are trade-offs.  No complex calculations. Reporting could take a bit more time. Oh, and having to learn a new language to interact with the cube (MDX). So how do you know if you could and/or should go the ASO route? How do you successfully make the switch with minimal impact to the users? This session will highlight the technical decisions that need to be made and addressed when making the switch.  It will also offer best practices for deciding if this switch is right for your organization.

UGF9982: The Needle in the Haystack: Aggregate to Transaction-Level with Essbase & OBIEE  
Mike Nader, Huron Consulting  Dave Collins, The Hackett Group

Day:     Sunday, October  25, 2015
Time:    3:30 - 4:15 pm
Room:  Moscone South Room 302

The traditional world of EPM analysis is changing. Historically, finance analysts were comfortable performing ad-hoc analysis in Essbase and Smart View. The more “exotic” deployments required drill through reporting. Today, “standard” EPM analytic deployments require more and more detailed information. In our last three BIFS deployments, our organization has implemented Essbase and OBIEE in an effort to perform aggregate to ledger-level reporting. We used a combination of Essbase drill through reports (via Essbase Studio) and the OBIEE Action Framework to provide the detailed analysis capabilities.  The ultimate goal of the session is to provide practical, implementation tested methods for drill-through and ledger detail reporting.

Back to Top

BUSINESS INTELLIGENCE

UGF5827: No More Big Data Hacking; It's Time For a Complete ETL Solution With ODI 12c!
Jerome Francoisse, Rittman Mead

Day:      Sunday, October  25, 2015
Time:    8:00 - 8:45 am
Room:   Moscone South Room 301

With new tools every week, Big Data projects imply a lot of scripting. Looks like the beginning of data warehousing when we manually wrote SQL code, right? Nowadays an ETL (Extract-Load-Transform) tool will generate the SQL code and handle the logging, scheduling, versioning and development lifecycle for you. And we also need that for Big Data projects! With Oracle Data Integrator 12c, it’s now possible to easily Hive, Pig, or Spark jobs just by providing the business rules behind without writing a single line of code. It can also generate and deploy Oozie workflows and easily handle files on HDFS for automated administrative tasks. After attending this session, you will be ready for a new era of Big Data integration, thanks to ODI!

UGF7409: OBI "Best Practices": The Bad, the Worse, and the Really Ugly - Which Reporting Tool Should I Use?
Christian Berg, Dimensionality GmbH 
 

Day:      Sunday, October  25, 2015
Time:     9:00 - 9:45 am
Room:   Moscone South Room 301

 Lists of "best practices" as well as "how-to's" on the subject of Oracle BI and all its facets are commonplace and often discussed. Real-life practices, however, are a completely different story. What happens when implementations go astray or dogmatically follow half-knowledge, misconceptions, or conveniently cheap shortcuts? Learn about recurring pitfalls, their origins, their impacts, and most importantly their remedies in an entertaining fashion. However bad you thought your project was, you’ve seen nothing yet...,

UGF9978: Oracle BI Visual Analyzer is Your Answer to Departmental BI Challengers
Mike Jelen, eCapital Advisors

Day:      Sunday, October  25, 2015
Time:    10:00 - 10:45 am
Room:   Moscone South Room 301

Gartner predicts that by 2017, the CMO will spend more on IT than the CIO.  BI tools need to be faster, easier to use, and more nimble than ever before, along with the ability to combine data from outside traditional data warehouses and data marts.    IT may not always be involved with all BI tool selections, but they end up owning or supporting these applications as “shadow BI tools”.  There are political and technological ways to incorporate these applications into your ecosystem while being a positive partner within your organization.  Come learn how the Oracle BI Visual Analyzer addresses each of these needs.

UGF10047:The Cloud Offers a Glimpse Into the Next Release of Oracle Business Intelligence    
Kevin McGinley, Red Pill Analytics

Day:      Sunday, October  25, 2015
Time:    11:00 - 11:45 am
Room:   Moscone South Room 301

The Oracle BI Cloud Service (BICS) provides companies with a new way to use OBIEE to solve different types of Business Analytics problems, but it also gives Oracle a chance to gradually release new features into the OBIEE product line before they become part of a large on-premise release. OBIEE 12c is the next major release of OBIEE, but BICS users can already begin exploring features of OBIEE 12c months before they arrive on-premise. In this session, we'll look at the features of BICS that will eventually appear in OBIEE 12c and how these features may eventually impact on-premise OBIEE users.

UGF6311: A Walk Through the Kimball ETL Subsystems with Oracle Data Integration
Michael Rainey, Rittman Mead

Day:     Sunday, October  25, 2015 
Time:    12:00 - 12:45 pm
Room:   Moscone South Room 301

Big Data integration is an excellent feature in the Oracle Data Integration product suite (Oracle Data Integrator, GoldenGate, & Enterprise Data Quality). But not all analytics require big data technologies, such as labor cost, revenue, or expense reporting. Ralph Kimball, an original architect of the data warehouse, spent much of his career working to build an enterprise data warehouse methodology that can meet these reporting needs. His book, "The Data Warehouse ETL Toolkit", is a guide for many ETL developers. This session will walk you through his ETL Subsystem categories; extracting, cleaning & conforming, delivering, and managing - describing how the Oracle Data Integration products are perfectly suited for the Kimball approach.   

UGF6869: On Metadata, Mash-ups and the Future of Enterprise BI
Kevin McGinley, Red Pill Analytics

Day:      Sunday, October  25, 2015
Time:    1:30 - 2:15 pm
Room:   Moscone South Room 301

For years now we've heard the cry: "One version of the truth!" While organizations invest heavily in analytic systems supporting unified reporting, users struggle to answer questions specific to their individual departments or job responsibilities. Can we combine the speed and agility of departmental analytics with the need of the enterprise to speak with a single voice?

UGF4906: Oracle BI Cloud Service - Moving Your Complete BI Platform to the Cloud
Mark Rittman, Rittman Mead

Day:      Sunday, October  25, 2015
Time:    2:30 - 3:15 pm
Room:   Moscone South Room 301

Customers now have the option to run Oracle Business Intelligence in Oracle’s Public Cloud, giving you potential benefits in terms of business agility, total cost of ownership, and integration with other cloud applications and data sources.

UGF4519: Real Business Value From Big Data and Advanced Analytics   
Antony Heljula, Peak Indicators Limited

Day:      Sunday, October  25, 2015
Time:    3:30 - 4:15 pm
Room:   Moscone South Room 301

By attending this session, you will learn about real case studies where Big Data and Advanced Analytics have delivered significant return-on-investment to a variety of Oracle customers. These are solutions that can pay for themselves within one year. Customer case studies include: 1) predicting employees likely to leave within the next 12 months, 2) predicting which sales outlets are likely to suffer from out-of-stock products, 3) predicting sales based on the weather forecast, and 4) predicting which students are likely to withdraw early from their courses. A live demonstration will demonstrate the high-level process for implementing Predictive BI and the best-practices.

Back to Top

DATABASE/ADF/MAF/CLOUD

UGF7763: Powerful SQL Constructs That You Might Not Be Aware Of
Galo Balda, Texas Health & Human Services

Day:     Sunday, October  25, 2015
Time:    8:00 - 8:45 am
Room:  Moscone South Room 274 

The SQL language offers a rich set of constructs that simplify how to query and analyze our data. However a large number developers don’t know about features that could help to reduce the complexity of the code they have to write. In this session, we’ll explore how features like analytic functions, subquery factoring, table functions, pivoting, pattern matching, etc. can be used to solve a variety of problems.   

 UGF10017: Build a Cloud Platform Using Oracle Enterprise Mgr 12c & Oracle Database Appliance
Bobby Curtis, Accenture Enkitec Group

During this session, attendees will take a look at how Database as a Service (DBaaS) is implemented with Oracle Enterprise Manager 12c and Oracle Database Appliance using Cloud APIs.  The aim of the session will be to provide attendees with lessons learned that will help them implement their own cloud architecture on the Oracle Database Appliance.  The session will also cover how databases are created and destroyed using REST APIs and Blueprinting within the cloud framework.  Information that is discussed will lead to a greater understanding of building flexible and reliable Cloud platforms for growth as more organizations move to the cloud.

UGF9985: Worst Practices in Data Warehouse Design
Kent Graziano, Data Warrior

Day:     Sunday, October  25, 2015
Time:    10:00 - 10:45 am
Room:  Moscone South Room 274 

After many years of designing data warehouses and consulting on data warehouse architectures, I have seen a lot of bad design choices by supposedly experienced professionals. A sense of professionalism, confidentiality agreements, and some sense of common decency have prevented me from calling people out on some of this. No more! In this session I will walk you through a typical bad design like many I have seen. I will show you what I see when I reverse engineer a supposedly complete design and walk through what is wrong with it. This will be a test of your knowledge of data warehouse best practices by seeing if you can recognize these worst practices.  .

UGF10016: Oracle Database Security: Frustrating the Patient Intruder
Tim Gorman, Delphix

Day:     Sunday, October  25, 2015
Time:    11:00 - 11:45 am
Room:  Moscone South Room 274 

Patience and persistence count for a lot in the data security world, but more so for the hacker or unauthorized intruder. As software itself has become more complex and entwined, there are numerous corners where the designers and developers have left little holes that might make integration a little easier but become the entrance point through which unauthorized intruders could drive a truck. All the patient intruder needs to do is wait and watch. While Oracle offers a variety of complex and high-priced options for securing data, such as Transparent Data Encryption or Database Vault, it is important to know security is implemented in a series of rings and having the outermost rings secured lessens the necessity for the innermost rings.  .

UGF2717: Alta UI Patterns for Enterprise Applications and Responsive UI Support   
Andrejus Baranovskis, Red Samurai Consulting

Day:       Sunday, October  25, 2015
Time:      1:30 - 2:15 pm
Room:    Moscone South Room 274 

Alta UI brings ADF enterprise application to a completely new level. Forget about plain boring interfaces from the past; nowadays, enterprise users should have much cleaner and robust interfaces for the job to be done. This is where Alta UI comes into play - it offers a set of ready made patterns that developers could use them for dashboards and CRUD screens. Besides modern and appealing UI patterns, Alta UI provides support for UI responsiveness. This enables rendering of the same screens on different devices with different screen resolutions. Displayed content is adjusted automatically based on the available screen size. Attendees are going to learn how to upgrade to Alta UI and how to use the most of its offered functionality.    

UGF10048: What's in a Word: Mobile/Cloud Terminology For Dummies
Mia Urman, AuraPlayer Ltd. 

Day:       Sunday, October  25, 2015
Time:     2:30 - 3:15 pm 
Room:   Moscone South Room 274  

MAF, Alta UI, MAX, PaaS, SaaS, MBaas, oh my! Does it seem like the world of technology has been taken over by four-letter words? With all of the new Oracle product releases and the ever-changing mobile and cloud landscapes, it's easy to get lost in the shuffle and feel like you have no idea what is going on. This leads many application developers to feel the world of mobile seems way beyond reach. This session will go through the many four- (and more) letter words that leave us with no idea how to move forward. We hope to clear the air and explain what you need to know to begin planning your mobile and cloud strategy.   

UGF2566: Give MAF a REST: Using REST/JSON Services in MAF 
John King, King Training Resources

Day:    Sunday, October  25, 2015
Time:    3:30 - 4:15 pm
Room:  Moscone South Room 274 

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 will show 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

APPLICATION EXPRESS

UGF4096: Open Source and APEX
Martin D'Souza, Insum

Day:     Sunday, October  25, 2015 
Time:    8:00 - 8:45 am
Room:  Moscone South Room 300

Most people don’t associate the words "open source" and "Oracle". That time has changed, as it is becoming more common for Oracle developers to publish their projects on open source platforms such as GitHub. This talk will focus on how you can leverage open source projects as part of your APEX development practices and integrate them in your applications. It will highlight some popular open source APEX projects, including several from OraOpenSource.

UGF10269: Oracle APEX + 12c JSON Support
John Scott, APEX Evangelists

Day:      Sunday, October  25, 2015
Time:     9:00 - 9:45 am
Room:   Moscone South Room 300

Most new web frameworks make use of JSON in the front end. However, historically working with JSON inside the database has been difficult; 12c fixes that.

This session will show some of the things now possible using the new JSON support in 12c.

UGF10050: The Objects of My Affection. Deploying Your APEX Applications
Francis Mignault, Insum

Day:      Sunday, October  25, 2015
Time:     10:00 - 10:45 am
Room:   Moscone South Room 300

During this session, learn how to deploy your applications to test , QA, and production. Also learn how supporting objects works and see the new APEX 5.0 features that will help you package and deploy your applications.

UGF10018: Template Options Power Options  
Jorge Rimblas, Accenture Enkitec Group

Day:      Sunday, October  25, 2015
Time:     11:00 - 11:45 am
Room:   Moscone South Room 300

APEX5 introduced a very useful little feature called “Template Options”, but did you know that you can use this powerhouse of a feature on any of your pre-APEX5 applications right after you upgrade?

In this session you will learn how Template Options are implemented and how they work.  Come learn the different ways you can use them and why you may want to. Gain knowledge that you can apply immediately to improve your application's look and feel.

UGF7157: Transitioning from APEX 4 to APEX 5
Scott Spendolini, Sumner Technologies

Day:      Sunday, October  25, 2015
Time:     12:00 - 12:45 am
Room:   Moscone South Room 300

With APEX 5 right around the corner, it’s time to start getting ready for a whole new development environment: the Page Designer view.  This new view looks and feels like more traditional desktop-based IDEs, and can be intimidating to both new and seasoned APEX developers alike.  However, with a little guidance, the benefits of it can be realized almost immediately.

This session will explore APEX 5’s new Page Designer view in detail, including the new methodologies used.  It will also highlight how specific workflows in APEX 4 are now achieved in APEX 5, making transition for existing APEX developers easier.

UGF5179: Dynamic 360º Virtual Tours with Oracle APEX in the Oracle Cloud
Scott Spendolini, Sumner Technologies

Day:     Sunday, October  25, 2015 
Time:    1:30 - 2:15 pm
Room:  Moscone South Room 300

When approached by a customer looking to showcase advertising opportunities in public spaces, we thought "No Problem!". However the customer's requirements were a bit more complex than initially outlined:
   * It must be web based multi-tenant environment capable of supporting unlimited end clients
   * It must present 360º Virtual Tours of the each public space
   * The Client should be able to dynamically change and preview their artwork in a given space
After some research we found tools that solved the VR Tour challenge. We then turned to Application Express in the Oracle Cloud to solve the User Interface challenge. This session outlines the challenges we faced and why we chose APEX and the Oracle Cloud as our platform.

UGF10049: Pins, Polygons, and Perspectives: Visualizing Geographic Data in APEX
Christoph Ruepprich, Accenture Enkitec Group

Day:     Sunday, October  25, 2015 
Time:    2:30 - 3:15 pm 
Room:  Moscone South Room 300

Several online services provide powerful API’s that allow you to integrate maps in your APEX applications. We will explore some of these API’s, and see how to display and configure a map inside a region. We will also see how to integrate stored data with the map, and render map pins and polygons.

Additionally we will see how to add informational data to pop-up windows, and how to use polygons to depict areas like counties and zip codes. All this is done from your data inside the database.

At the end of the presentation, the audience will have a better understanding of how to integrate their own maps with APEX , and how to communicate stored data to the map.

UGF3322: How to Make APEX Print Through Node.js
Dimitri Gielis, APEX R&D

Day:      Sunday, October  25, 2015
Time:     3:30 - 4:15 pm
Room:   Moscone South Room 300

Printing has always been a weaker point in Oracle Application Express (APEX). BI Publisher could be used, but for many people this technology is too expensive. Alternatives like Jasper Reports, XSL-FO and others have other drawbacks.
This presentation will show another method based on Node.js to enable printing in APEX, so you can use Word, Powerpoint, and Excel to create your template and have it outputted in the different Office formats or PDF.

Back to Top