Analytics | Core & Database | Enterprise Planning | EPM Foundations & Reporting | Essbase | Financial Close
Hands-on Training Sponsored by
Hands-on Training is back – with fresh new content for ODTUG Kscope22. These sessions are BYOL – Bring Your Own Laptop – and are included free of charge with your conference registration. Classes are limited to 40 people and will be filled on a first-come, first-served basis; there is no advance sign-up required.
Analytics
Monday, June 20, 11:00 a.m. - 12:45 p.m. | San Antonio 6
Fusion Analytics Warehouse
Join this session to get hands-on experience using Oracle Fusion Analytics Warehouse. Whether you are an existing or prospective user/admin, this session will train you on:
• Overview of Fusion Analytics Warehouse including architecture and an introduction to “out-of-the-box” KPIs, Cards, and Semantic Data Models
• How to navigate and view KPIs, Cards, and Dashboards
• How to edit or create KPIs
• How to edit or create Cards
• How to create new visualizations and reports using the Semantic Data Model
• Advanced Topics: Creating new data sources, Extending the Data Model
Presenter – David Harter, Peloton Group
Core & Database
Wednesday June 22 | 9:00 - 11:15 a.m. | San Antonio 6
Developing with JSON in Oracle Database
In this workshop, you will create a simple web shop using JSON collections and SQL/JSON with the Autonomous JSON Database. After completing this workshop you will have a good understanding of what JSON features are available in Oracle Database and when to use them. We will also show how MongoDB drivers and tools can connect directly to the Autonomous Database.
Prior to the session, please go to the following link to get setup!
Presenter – Josh Spiegel, Oracle Corporation
Wednesday June 22 | 12:45 - 3:00 p.m. | San Antonio 6
How to Build a Modern Data Platform
The goal of this hands-on session is to showcase how organizations can achieve faster Mean Time to Analysis and Decision (MTTA/MTTD) as they transition and pivot to embracing digital transformation.
You will learn to build a modern data platform with an emphasis on Data Lake House using “out-of-the-box” tooling and integrations available in Oracle Cloud Infrastructure (OCI).
We will demonstrate how to use publicly available data sets and store it in an object store bucket (a.k.a. Data Lake). We will then harvest this data and make it accessible to Autonomous Data Warehouse (ADW) by using Data Catalog, without physically moving data out of the Data Lake. We will schedule harvest jobs to facilitate automated processing of new incoming content into the Data Lake.
In addition, we will transform the data using OCI’s Data Integrator tool by creating data flows.
Last but not the least we will create visualizations using this ingested data and demonstrate the full capabilities of Oracle Analytics Cloud (OAC).
Presenter – Ajay Padhye, Oracle Corporation
Enterprise Planning
Monday, June 20 | 2:15 - 4:00 p.m. | San Antonio 6
Discover the Capabilities of Profitability and Cost Management
Discover the capabilities and the concepts required to design and create Oracle Profitability and Cost Management (PCM) applications. In this introductory hands-on session, attendees will get an overview of how to identify and exploit profitability through the development of advanced modelling and complex what-if scenarios and reporting.
Presenter – Simon Beesley, Keyteach
Tuesday, June 21 | 2:30 - 4:00 p.m. | San Antonio 5
Build FreeForm Planning Applications
Learn how FreeForm Planning can be used to create applications without the limitations imposed on standard applications. This functionality can be used to extend the capabilities of existing environments with additional analysis options, or to bring on-premises Essbase applications to the EPM Cloud platform. In this hands-on session, you will explore how to create and manage FreeForm applications using a variety of approaches and discuss the key considerations when making use of this feature.
Presenter – Chris McManus, Keyteach
Wednesday, June 22 | 9:00 - 11:15 a.m. | San Antonio 5
Groovy Scripting for Enterprise Planning Cloud
Groovy rules can be written in Calculation Manager as an alternative to traditional business rules, providing additional functionality to solve problems that can't be addressed in other ways. Discover how to create and manage Groovy rules and explore how they can be used for a variety of tasks, from performing complex run-time validations to generating Calc Scripts dynamically, based on the context in which they are executed.
Presenter – Chris McManus, Keyteach
EPM Foundations & Reporting
Monday, June 20, 11:00 a.m. - 12:45 p.m. | San Antonio 5
Explore the REST APIs for Oracle EPM Cloud
Discover how the REST APIs allow clients to issue requests to and receive responses from the Oracle EPM Cloud platform using the HTTP protocol. In this introductory session, you will explore how to extend and automate the Oracle EPM Cloud using these APIs, facilitating a wide variety of administration, maintenance, and integration tasks.
Presenter – Chris McManus, Keyteach
Tuesday, June 21| 11:15 a.m. - 12:45 p.m. | San Antonio 6
Enterprise Data Management Cloud Service (EDMCS)
Join this session to get hands-on experience using Oracle EDMCS. Whether you are an existing or prospective user/admin, this session will train you on the EDMCS Information Model and why EDMCS is more than just “DRM in the Cloud.”
Presenter – Julia Radovani, Peloton Group
Co-Presenter – Sky Hannan, Peloton Group
Essbase
Monday, June 20 | 2:15 - 4:00 p.m. | San Antonio 5
Get "Hands-on" with Essbase 21c
Get hands-on with the latest Essbase platform and review the differences in features and functionality between Essbase 11g on-premises and Essbase 21c. Explore the modern browser-based UI for management and administration, discover the new Cube Designer plugin for Smart View, and learn about new platform features such as connections/data sources, new security roles, dynamic filters, and more.
Presenter – Chris McManus, Keyteach
Tuesday, June 21 | 2:30 - 4:00 p.m. | San Antonio 6
Essbase 21c Connections, Data Sources and Better Drill-Through
Essbase 21c offers new features for building and loading cubes from external on-premises or cloud data sources, and more powerful and flexible drill-through capabilities to those sources than are available in the 11g releases. In this hands-on session we'll build a cube in the 21c web interface, take advantage of the new connection and data source constructs to load data, and then explore all the new options for drill-through to both data sources and URLs.
Presenter – Roger Cressy, Qubix
Financial Close
Tuesday, June 21| 11:15 a.m. - 12:45 p.m. | San Antonio 5
Explore the HFM to EPM Cloud Migration Accelerator
Explore the migration of HFM applications to the EPM Cloud using Oracle’s EPM Cloud Migration Accelerator. Examine how metadata is manipulated to create a Financial Consolidation and Close application, how data is transferred using Data Management, and how calculations are transformed to operate in the cloud environment.
Presenter – Simon Beesley, Keyteach
Wednesday June 22 | 12:45 - 3:00 p.m. | San Antonio 5
Understanding Calculations in Financial Consolidation and Close (FCC)
This session introduces techniques for manipulating data using business logic in Financial Consolidation and Close (FCC). Explore the concepts of writing calculations and tailoring consolidations, using both business rules and configurable consolidations, where journal entries are created to re-classify, adjust, and eliminate reported data.
Presenter – Simon Beesley, Keyteach