Upcoming ODTUG Webinars

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 alicia@odtug.com.

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.

 

EPM.png

Wednesday, September 14, 2016 12:00 PM - 1:00 PM EDT
How to Make FDMEE-Triggered Essbase Calculation and Partition Scripts Targeted to Current FDMEE Load
Bernard Ash, EPM Clarity

 Part One of a Two-Part Series – Fix Your FDMEE Essbase Loads

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


EPM.pngThursday, September 15, 2016 3:00 PM - 4:00 PM EDT
The Perfect Pair: PBCS with BICS Is Like Peanut Butter and Jelly
Jenish Parekh, Matt Gualtieri, and Shreeram Sharma, Saturn Infotech

With Oracle’s Planning and Budgeting Cloud Service (PBCS), you can create rolling forecasts and analyze variances and what-if scenarios. When paired with Oracle’s Business Intelligence Cloud Service (BICS), users can bridge the gap between reality and planning. This demonstration will cover the ways in which combining PBCS and BICS can optimize the planning, reporting, and analysis process of any size and type of business. Learn how, when used in unison, the two applications can help business owners and finance departments align strategy with business objectives, quickly adapt to change, and make informed decisions. PBCS without BICS is like peanut butter without jelly: They can stand alone, but when paired together they create something great! 

Learning objectives:

Typically, the two applications PBCS and BICS are used and implemented in disconnect. They are marketed as separate solutions, each with their respective benefits. However, PBCS and BICS can be employed side by side to help achieve financial transparency, something that can fall short when a business goes with one or the other. PBCS and BICS can help align strategy with business objectives, leverage information to make informed decisions, and bridge the gap between reality and planning. 

Register Here


EPM.pngWednesday, September 28, 2016 3:00 PM - 4:00 PM EDT
Financial Consolidation and Close Cloud Service (FCCS): Inside and Out
Nancy Ackerman, Vertical Edge

Financial Consolidation and Close Cloud is finally here! Let the seasoned experts at Vertical Edge show you how you can dramatically reduce the time and cost to complete a close. The FCCS solution will:  

  • Maintain transparent reporting
  • Be a complete outlook solution for your company
  • Come equipped with built-in connectivity
  • Prove to be an efficient preconfigured consolidation system

Reserve your spot today for this webinar and join us as we break down what you need to know about FCCS. We will demonstrate:

  • The delivered content you can expect
  • The outline configuration, delivered functions and reports
  • The key benefits and features
  • How to integrate this solution with your existing on-premise ERP system
  • How upgrades and patches are handled

Finally, a consolidation solution that meets the Cloud. You do not want to miss this informative Webinar that details FCCS and covers everything you need to know. 

Register Here


EPM.pngThursday, September 29, 2016 12:00 PM - 1:00 PM EDT
Understanding and Using Essbase Web Services
Dayalan Punniyamoorthy, Vertical Edge

Services on cloud is the new mantra driving most of the Oracle EPM component to be accessed via the cloud. Of course, Essbase We Services are not excluded from the list. They were introduced as a new feature in 11.1.2.2, as silent unnoticed functionality.

Essbase Web Services will expose Essbase user and administrative functionality in a services-oriented (SOA) environment via Provider Services and allow Essbase to be easily integrated with both Oracle and third-party applications.

Essbase Web Services include the following modules:

  • Datasource
  • Administration
  • Data and metadata

In this webinar, we will discuss how to get started with Essbase Web services and explore the variety of functionalities they offer us. Don’t miss this webinar if you want to learn a bit more about Essbase Web Services and how to customize them to meet your requirements.

Register Here


BI.png

Tuesday, October 4, 2016 12:00 PM - 1:00 PM EDT
Scaling to Infinity: Partitioning Data Warehouses on Oracle Database 
Tim Gorman, Delphix

There is a lot of talk about big data, and it is often associated with Hadoop and other NoSQL databases. But SQL and Big Data are not mutually exclusive. There are petabyte-sized databases on Oracle Database, and this is how they happen.

This presentation is distilled from 15+ years of extensive experience implementing multi-terabyte databases to support data warehouses on the Oracle RDBMS. One of the most important technical decisions is how to implement partitioning within the Oracle RDBMS to optimize query performance for response time even as data volumes increase, and also to optimize data loading to maximize availability during data loading, eliminating downtime and minimizing impact on the system. Partitioning is also implemented to optimize storage by enabling compression and taking advantage of "tiered" storage strategies and READ ONLY tablespaces.

Partitioning is the key to unlock the full power of numerous advanced Oracle features for data warehousing in a way that is not explicitly documented by Oracle. This interlocked dependency between features is described by the presenter as the "virtuous cycle." Not starting with partitioning on a data warehouse project can lead to a deadlock of unfortunate circumstances that can doom the project to failure, which the instructor characterizes as the "death spiral." In fact, one of the most important query optimizations for data warehouses in Oracle known as "star transformations" is effectively unavailable without using properly implemented partitioning.

Register Here


Database.png

Thursday, October 6, 2016 12:00 PM - 1:00 PM EDT
2016 Code Talk Series: 12 Things Developers Will Love About Oracle Database 12c Release 2 
Steven Feuerstein and Chris Saxon, Oracle Corporation

12.2 is packed full of goodies for Oracle Database developers. This session features a conversation with the Ask Tom Answer Team (Chris Saxon and Connor McDonald), along with Keith Laker, SQL Product Manager, and Bryn Llewellyn, PL/SQL Product Manager. It will be followed by a live Q&A session with Chris Saxon and Steven Feuerstein.

Register Here


EPM.pngTuesday, October 11, 2016 12:00 PM - 1:00 PM EDT
Save Time with FDM to FDMEE Migration Utility
Bernard Ash, EPM Clarity

Do you want to upgrade to FDMEE but you’re too afraid of the large number of FDM artifacts you have in FDM (locations, data load rules, import formats, validation rules, validation entities, etc.)? It would be very time-consuming and therefore expensive and error-prone to migrate all those artifacts from FDM to FDMEE. The bad news is that artifacts such as custom reports and VBScripts will not be migrated; you will have to convert those artifacts by hand. However, the vast majority of your standard artifacts such as locations, data load rules, import formats, mappings, etc. can be migrated using Oracle’s FDM to FDMEE migration utility that Oracle released last fall. The migration utility is implemented using ODI but with a little coaching; even if you don’t know ODI, you could take what would ordinarily be a six-month migration/“upgrade” effort and condense that into a one- to two-month effort. Also, if there is enough time, we could give you an introductory tutorial on how to convert VBScript to Jython and/or how to create a custom report in FDMEE. This will be a live, hands-on demo. 

Register Here


APEX.pngBI.pngThursday, October 13, 2016 3:00 PM - 4:00 PM EDT
Using APEX to Integrate Projections into an OBIEE Financials Dashboard
Teal Sexton, UC Berkeley

University of California, Berkeley is building an APEX form to integrate user-entered financial projections into OBIEE dashboard reports. Faculty will have up-to-date financial data including projected fund balances, particularly important for research and sponsored programs. The APEX form integrates with PeopleSoft HCM to automate the projections for employee salaries and benefits. RA’s can update, delete or add projection lines in a single form for a given faculty member’s full portfolio of funds. Upon hitting the “submit” button, the APEX application writes the projections into a staging table that triggers database updates and refreshes the OBIEE dashboard reports. Instantly, projections are factored into the calculations to give projected ending fund balances and more. The projected go-live for this functionality is March, 2016. The new functionality will efficiently provide faculty with 24/7 access to their projected ending fund balances for the first time at UC Berkeley!

Register Here


BI.pngTuesday, October 18, 2016 12:00 PM - 1:00 PM EDT
Does Your Data Have a Story? Find Out with Oracle Data Visualization
Mike Durran, Oracle Corporation

Oracle Data Visualization makes it easy to get insight from your data. This stunningly visual and intuitive application enables you to access, blend, and wrangle a variety of sources including spreadsheets, databases, and applications and tell the story of your data. In this session, learn about the capabilities of Oracle Data Visualization to create compelling analytics narratives, including how you can rapidly apply advanced analytics techniques to gain insights previously only accessible to advanced users.

Register Here


 

EPM.pngTuesday, November 8, 2016 12:00 PM - 1:00 PM EDT
FDMEE Smart Replace for HFM
Bernard Ash, EPM Clarity

While HFM clears the entities in your current load file, it will not clear entities that were loaded previously. A clear of entities from a previous load could be required if someone books some transactions incorrectly (for example, to the wrong entities) and they flow through to HFM. Smart Replace will catch and clear ALL entities (even from previous loads) and by doing so will save customers from many hours of digging to find out why their data doesn't tie. Many thanks to Tony Scalese for writing the first generation of this Smart Replace module in VBScript, but this demo and code are by EPM Clarity in Jython for FDMEE compatibility. It is in production at Chevron. 

Register Here


BI.pngThursday, November 10, 2016 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.pngThursday, November 17, 2016 3:00 PM - 4:00 PM EDT
Face Your Budgeting Fears: Indirect Budgeting
Matt Gualtieri, Shreeram Sharma, and Shreyas Krishna, Saturn Infotech

How efficient is your business’ budgeting process? Indirect budgeting can be unclear, especially when it comes to understanding how to allocate costs to departments. Without an accurate budget that correctly predicts costs and profits, meeting fiscal obligations and keeping your business compliant become a challenge. In this webinar, Saturn Infotech’s technical and functional experts will demonstrate how to streamline your planning and budgeting process with Oracle PBCS. You will learn how PBCS provides more comprehensive reporting options and simplifies companywide hiring and budgeting, making headcount management a breeze!

Learn how to:

  • Make smarter budgeting decisions with the proper allocation of costs
  • Allocate indirect cost to departments
  • Simplify headcount input for users
  • Avoid common budget mistakes
  • Understand the difference between centralized drivers and local drivers
  • Customize the application according to your business process needs
  • Determine headcount cost reporting by department
  • Perform data integration with a feeder system (ADP, HR.1, etc.)
  • Improve data security
  • Manage workflow in a corporate hierarchy

Register Here


 

BI.pngThursday, December 1, 2016 12:00 PM - 1:00 PM EST
Data Warehousing in the Real World
Kent Graziano, Snowflake Computing

At a former health-care client, we were not able to implement a pure Data Vault 2.0 architecture. Instead, we had to evolve a hybrid solution that uses Type 2 persistent stage tables we tie together using standard Hub and Link structures along with a Key Map table. While we have been able to utilize DV 2.0 concepts such as MD5 hash keys, in order to avoid joins in loading the stage tables we had to come up with a way to resolve the business keys further into the process. We will show you our solution and discuss the pros and cons of our approach. 

Register Here


 

Recent Stories
ODTUG March 2019 News

ODTUG Cross-Community Initiatives Outreach

ODTUG February News