Below is the list of upcoming webinars. If there is a topic you would like covered that is not on our current list, or if you would like to present a webinar, please email firstname.lastname@example.org.
Did you miss a webinar? Our Webinar File Library lists all of our webinars and can be filtered by subtopic (content track). As an ODTUG member, you can watch all of our past webinars at any time. Not a member? Join now for the low price of $99 per year!
Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.
Thursday, January 5, 2017 3:00 PM - 4:00 PM EST How to Maximize Your PBCS Implementation with Smart View Paul Hoch,TopDown Consulting
Oracle Smart View for Office is one of the most powerful options for taking take full advantage of your Oracle Hyperion and BI applications. It’s long been considered a must-have for Hyperion Planning because it offers hundreds of options to help pull, analyze, and report data. But now you’re considering, or using, PBCS and you don’t want to miss a beat when it comes to all the additional features and support that Smart View offers.
Join Paul Hoch, TopDown Consulting Principal Architect, and discover how you can get the most out of Smart View and PBCS. This session takes a look how Smart View and PBCS work together. It will include a quick comparison of Smart View in on-premise Hyperion Planning and PBCS, what you’ve gained, what you need to let go of, what you need to install to enable Smart View, and best practices, tips, and tricks for how to make the most of Smart View in PBCS. The session also includes real-world examples. You will have a clear understanding of how to work with Smart View and PBCS so you can start taking advantage of all it has to offer.
Tuesday, January 10, 2017 12:00 PM - 1:00 PM EST Agile Data Warehousing: Using Oracle Data Modeler to Build a Virtualized ODS Kent Graziano, Snowflake Computing At a past client, in order to meet timelines to fulfill urgent, unmet reporting needs, I found it necessary to build a virtualized Operational Data Store as the first phase of a new Data Vault 2.0 project. This allowed me to deliver new objects quickly and incrementally to the report developer so we could quickly show the business users their data. In order to limit the need for refactoring in later stages of the data warehouse development, I chose to build this virtualization layer on top of a Type 2 persistent staging layer. All of this was done using Oracle SQL Developer Data Modeler (SDDM) against (gasp!) an MS SQL Server Database. In this talk, I will show you the architecture for this approach, the rationale, and then the tricks I used in SDDM to build all the stage tables and views very quickly. In the end, you will see actual SQL code for a virtual ODS that can easily be translated to an Oracle Database.
Learn a data warehouse architecture that can be implemented incrementally and in layer.
Learn what is a Virtual ODS and how it can help you be Agile.
How to quickly build pattern-based stage tables in SDDM.
How to build complex, pattern-based views in SDDM.
Tips on how to use analytic functions to create virtual columns.
See examples of how to embed change data capture into a view-based loading architecture.
Thursday, January 12, 2017 3:00 PM - 4:00 PM EST All About EPMA: From Setup to Tips and Tricks Deanna Sunde,Key Performance Ideas
The classic method of building Essbase, Hyperion Planning, and Hyperion Financial Management (HFM) applications can be unwieldly. How is your process for building hierarchies? Is it time-consuming and difficult to maintain? Enterprise Performance Management Architect (EPMA) is an innovative tool, included in the Oracle EPM suite, designed to ease the burden of managing data and metadata. Reasons for using EPMA vs. Classic mode will be discussed, along with pros, cons, and design considerations. EPMA will be demonstrated including the shared library; local library along with how to share dimensions across HFM, Planning, Essbase BSO, and Essbase ASO applications; what extra setup is needed to support these applications; and how to exclude portions of a dimension. Also covered will be how to create a flat file and a profile, how to load the metadata, how to use the EPMA batch utility, and how to override properties.
Tuesday, January 17, 2017 12:00 PM - 1:00 PM EST Avoiding FDMEE OpenBatch Pitfalls with Custom Script Pete Petersen, CheckPoint Consulting Have you come across problematic issues while using FDMEE to automate loads via OpenBatch and encountered the issue of the “openbatch” directory filling up with archive directories? There are some simple steps to take to stay organized. In this webinar, we will walk through:
Configuring the Batch Definition for running OpenBatch
Utilizing a custom script to accomplish:
Moving archive directories to appropriate application directories
Renaming archive directories to include date and time
Deleting empty directories to avoid “clogging” the openbatch directory
We will walk through the default OpenBatch process to show the “out-of-the-box” functionality as well as the process with the custom script implemented.
Thursday, January 19, 2017 12:00 PM - 1:00 PM EST 2017 CodeTalk Series: Internet of Things and Oracle Database Blaine Carter, Oracle Corporation, and Anton Nielsen, C2 Consulting
The Code Talk Series is Co-sponsored by ODTUG and IOUG To say we live in an increasingly connected world is to state the obvious – and to entice developers to wonder how they can connect their devices to the Internet. Of course, that immediately begs the question of what to do with all the data gathered. We kick off the CodeTalk 2017 series with an interview with Anton Nielsen, longtime explorer of leading-edge technologies in and around Oracle Database. He’s got lots to say about the IoT, and Blaine Carter, Oracle Developer Advocate for Open Source, will make sure you hear all about it. Register Here
Tuesday, January 24, 2017 12:00 PM - 1:00 PM EST FDMEE /PBCS REST API: Taking Your Hybrid Integration to the Next Level Francisco Amores,Infratects
Hybrid integrations are the best approach to integrate your on-premise and cloud-based applications. Each cloud service provides a REST API that we can use to perform multiple tasks, such as importing/exporting metadata and running business rules.
In this webinar, we will show how to load HFM exchange rates from an HFM on-premise application into a PBCS application using FDMEE on-premise and PBCS REST API.
Thursday, January 26, 2017 12:00 PM - 1:00 PM EST Oracle Database Security Tips and Practices Every DBA and Developer Should Know Simon Pane, Pythian There's an immense array of security features built right into the Oracle Database beyond the basics of grants, privileges, roles, and profiles. This presentation will go over some of the lesser-known features and functionality available in all versions and releases of the Oracle Database. Every DBA and Developer should be using these tricks on a daily basis and considering them when they design, implement, and deploy Oracle-based applications. If you are a DBA or DB Dev, you will not want to miss this presentation. Register Here