Webinars


Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at alicia@odtug.com.

Did you miss a webinar? As an ODTUG member, you can hear all of our past webinars at any time. Just log in and you will see the link for the recorded list. Not a member? Join now for $99!

Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinars


EPM.pngTuesday, December 6, 2016 12:00 PM - 1:00 PM EST
How to Make FDMEE-Triggered Essbase Calculation and Partition Scripts Targeted to Current FDMEE Loads
Bernard Ash, EPM Clarity 

Optimize FDMEE performance with Essbase by making all your operations more focused. When your customer’s requirements ask you to use FDMEE to load over 800,000 records per entity for one month, convert YTD to MTD, convert local currency to USD, and then push to an ASO reporting cube, it’s time to break out the big guns. Large data volumes or not, why not parameterize ALL your FDMEE-driven calc scripts based on the entities that are in a given load file? Why not do the same with a partition script that refreshes the data to a reporting cube after it has been loaded and calc’d in BSO? In this live, hands-on demo, we will use Jython to identify the distinct entities in a given data load (TDATASEG table) and pass these entities to a MaxL script to manage the focus of the calcs and partition scripts. This functionality is live at Cigna.

Register Here


Database.png

Friday, December 9, 2016 12:00 PM - 1:00 PM EST
2016 CodeTalk Series: The NoPL/SQL and Thick Database Methods: Which One Do You Think Needs a Bigger Database Server?
Chris Saxon and Toon Koppelaars, Oracle Corporation

Toon Koppelaars recently conducted an experiment comparing the performance of different ways of implementing a specific task. The NoPL/SQL approach treats the database as no more than a persistence layer, using only naive single-row SQL statements; it implements all business logic outside of it. The thick database approach treats the database as a processing engine; it uses a combination of sophisticated set-based SQL statements and PL/SQL to implement all business logic inside it. In this session, Chris and Toon investigate Toon’s findings and discuss their implications for database development. This session is a must-watch for anyone who builds applications using Oracle Database.

Register Here


BI.png

Tuesday, December 13, 2016 12:00 PM - 1:00 PM EST
Tell Your Data Story with Oracle Data Visualization Desktop
Kevin McGinley, Red Pill Analytics

Reports? Dashboards? Those are so yesterday. The latest trend in the world of data and analytics is the art of telling a data story, and Oracle Data Visualization Desktop can help you do it. To prove it, the entire webinar will be presented using Data Visualization Desktop instead of PowerPoint. This is not your ordinary five-minute demo! Come watch the host of the DataViz Daily podcast showcase powerful features of Data Visualization Desktop to articulate your message to your peers or your management using data as your narrator.

Register Here


APEX.pngWednesday, December 14, 2016 12:00 PM - 1:00 PM EST
apex.world On Air: What Can We Expect for 2017?
Panel: M. D'Souza, J. Schuster, J. Kallman, D. McGhan, S. Spendolini, and S. Heimsath

apex.world On Air will bring together some of the world’s foremost APEX experts to discuss news, products, and project updates with special guest Sabine Heimsath, the APEX Twitter Queen @oraesque, in a panel format. Participants are encouraged to participate in the discussion through chat and asking questions, which will be answered live on the show.

Register Here


EPM.pngThursday, December 15, 2016 12:00 PM - 1:00 PM EST
Incredible ODI Tips to Work with Hyperion Tools
Rodrigo Radtke, Dell, and Ricardo Giampaoli, Teracorp

ODI is an incredible and flexible development tool that goes beyond simple data integration, but most of its development power comes from outside-the-box ideas.

  • Did you ever want to have only one interface and loop any number of ODI objects with a lot of control?
  • Did you ever need to have a "third command tab" in your procedures or KMs to improve ODI powers?
  • Did you ever want to have only one data store and loop different sources without the need for different ODI contexts?
  • Do you use "dynamic variables" and know how powerful they can be?

If you want to know the answer to all these questions, please join us in this webinar to learn the special secrets of ODI that will take your development skills to the next level.

Register Here


EPM.png

Tuesday, December 20, 2016 3:00 PM - 4:00 PM EST
#1 Oracle Hyperion Planning Approvals: Out of the Box and Other Custom-Built Methods
Deanna Sunde, Key Performance Ideas

Watch Deanna Sunde, Oracle ACE Associate, as she demonstrates the Hyperion Planning Approval Process. Deanna shares its functionality and compares and contrasts it to the previous Workflow functionality. The steps to set up the Approval Process are shown, including using the upload utility and related security settings. The use of task list functionality will also be shown, as well as other custom-built methods to more easily track approvals using Hyperion Planning forms. Examples of using Hyperion Financial Reporting to report on entities/departments that are complete/incomplete will also be demonstrated.

Register Here


EPM.png

BI.png

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.

Register Here


BI.png

Tuesday, January 10, 2017 12:00 PM - 1:00 PM EST
Agile Data Warehousing: Using Oracle Data Modeler (SDDM) 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!) a 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 layers 
  • 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 

Register Here


EPM.png

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.

Register Here


EPM.png

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: 
    1. Moving archive directories to appropriate application directories 
    2. Renaming archive directories to include date and time 
    3. 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. 

Register Here


EPM.png

Thursday, February 2, 2017 3:00 PM - 4:00 PM EST
Ready. Set. Cloud! Migrating from On-Premise to Oracle PBCS
Deanna Sunde, Key Performance Ideas

Find out how this project started with a cleanup effort so objects, such as forms and reports, could be rationalized and only the appropriate objects migrated and tested on PBCS. Discover how the company migrated from 9.3 to 11.1.2.3 on a lab environment and then to PBCS using LCM. Additionally, learn how the ODI interfaces were updated and Business Rules were migrated to Calculation Manager. Hear tips and tricks for migrating to PBCS and how the build, training, and rollout for this project was completed in eight weeks.

Register Here


EPM.png

Tuesday, February 7, 2017 3:00 PM - 4:00 PM EST
Supporting EPM in the Cloud, Transitioning Roles and Tasks
Mike Turner and Jeff Henkel, CheckPoint Consulting

Cloud environments are unique and lighter but still require a layer of hands-on care. Let’s take a closer look at the demands of an EPM environment’s run and how we can maintain requirements in the cloud. We’ll cover these common on-premise tasks and how to translate these to the cloud:

  • Metadata management to data integration
  • Admin team’s areas of adjustment to keep the numbers rolling up
  • Special considerations for security and backups
  • Tricks for Smart View support

All these tasks still have a piece of the action in PBCS. We will highlight the run and maintenance requirements for PBCS. Even though you’re not managing the servers anymore, PBCS still needs hands-on experience and attention. Are your business users ready to absorb this transition?

Register Here


EPM.png

Tuesday, February 14, 2017 3:00 PM - 4:00 PM EST
Implementing Hyperion Planning Driver-Based Rolling Forecasting
Deanna Sunde, Key Performance Ideas

Driver-based rolling forecasts, simplified. Want a monthly rolling forecast but believe there is a lot of effort required to enter all of the data? Join us for this webinar and find out how companies are implementing a rolling forecast through the use of drivers to streamline the effort. A demonstration will include how a handful of drivers are used along with historical data and trending methods to populate the rolling forecast. This provides more time for analysis, which every company desires. Plus, discover how rolling forecasts are set up and maintained with Oracle Hyperion Planning and how to implement dynamic reporting of overlapping quarters.

Register Here