ODTUG September News

GeekAThon Videos Coming Soon

ODTUG’s first-ever GeekATmetavero.pnghon, sponsored by METAVERO and brought to you from the imagination of the Kscope16 Conference Committee, is complete! Stay tuned to see what this year's participants have invented.

ODTUG Board of Directors Nominations Close Today

ODTUG Board of Directors Nominations close September 22, 2016, at 11:59 PM PDT. To submit a nomination or find out more about the responsibilities of the ODTUG Board of Directors, check out this blog post. Members of the Board enjoy the opportunity to guide the direction of ODTUG as well as increased contact with Oracle Corporation’s upper management and other experts in the development community.

If you’d like to run for the Board or vote in the elections, you must be a paid member by September 30, 2016, to be eligible. Not a member yet? Join today!

Community News

The Community Meetups at Oracle OpenWorld were a rousing success! Visit our Facebook page for more, and be sure to tag yourself in our album!


 View Album on Facebook

Make plans to attend these upcoming Community events:

Did you miss us at Oracle OpenWorld? Do you want to start your own meetup? Click here to learn how.


Kscope17: San Antonio, Here We Come!

Kscope17 is heading to San Antonio, Texas, June 25-29 at the JW Marriott San Antonio Hill Country. Registration and hotel reservations are open.

Abstract submission is open now through October 14, 2016. Get recognized! Submit your abstract today.

Kscope16: A Look Back

Can’t get enough of Kscope16? The second and final wave of videos have been added to YouTube. Take a look back at our wrap-up video and all of the interviews with some of Kscope16’s brightest stars.

Don't miss this episode of Apex.World with Monty Latiolais, Juergen Schuster, and Martin D’Souza as they broadcast from Kscope16 as well as the value, benefit, and significance of being an ODTUG member. 

ODTUG Webinars


Tuesday, September 27, 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

Liberate ASO procedural calcs from admin ownership – make them runnable by end users from Smart View. We can do this, thanks to the Calc Manager CDF – MaxLScriptFunction – which allows us to run a MAXL script from a calculation script/business rule. Also with this approach, users could trigger a BSO calc and then subsequently refresh a partition to push the calc results to an ASO reporting cube. 

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 Web Services are not excluded from the list. They were introduced as a new feature in, 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


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


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

Database.pngThursday, October 20, 2016 12:00 PM - 1:00 PM EDT
Oracle SQLcl and SQL Developer Tips and Tricks
Jeff Smith, Oracle Corporation

This session has something for everyone. The DBA, the developer, the beginner, the expert – all will walk away with at least two or three new techniques in their favorite SQL-PL/SQL IDE and database GUI. I have fun doing this presentation, and I think you'll have fun participating or just soaking in some new things to try out. The presentation changes as the product updates, but the gist remains the same: Show folks the things they need to know to go from casual users to experts.

I guarantee each attendee that they will pick up two or three new things/techniques/tricks that will fundamentally change the way they use the tool. This adds up to a lot of saved time, and just as importantly, a happier end user. 

Register Here

blog.jpgBlogs to Check Out!




Recent Stories
ODTUG Board Member Nomination Example

Upgrade from Associate to Individual Membership

Join the 2025 ODTUG Board of Directors - Call for Nominations Now Open