ODTUG August E-News

Leadership Program Application Deadline: August 14, 2016

The Leadership Program is a nine-month journey consisting of monthly webinars on subjects ranging from leadership styles, effective communication, mentoring, and ethics to the challenges of leading volunteers.It is limited to an extremely small group of participants.

As a part of the program, participants will receive a complimentary pass to ODTUG Kscope17, where you will bond with fellow participants – all while volunteering, learning more about ODTUG, and attending sessions. There is no fee to apply for the program, however, should you be accepted into the program, you must then become a fully paid ODTUG member. Click here to learn more.

GeekAThon Submission Deadline: August 15, 2016metavero2016_white_logo-01.jpg

Participate in ODTUG’s first-ever GeekAThon, sponsored by METAVERO and brought to you from the imagination of the Kscope16 Conference Committee. We send you a beacon; you make something awesome! Registration to participate ends August 15, 2016. Go to competition.odtug.com to register.

For more information, check out this introductory webinar recording by Danny Bryant and Opal Alapat and be sure to attend the webinar on Friday, August 19, about breadboard circuits and I/O for Raspberry Pi from Jeremy Harms.

ODTUG Board of Directors Nominations Opening Soon

ODTUG Board of Directors Nominations open September 6, 2016. 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!

Join ODTUG at Oracle OpenWorld

Make plans to visit the ODTUG kiosk in Moscone South and attend our Sunday sessions at Oracle OpenWorld September 18-22 in San Francisco. Stay tuned for information about Community Meetups.

Community News

Make plans to attend these upcoming Community events:

EPM/BI Community Meetup in Wichita, KS – Thursday, August 18, 2016
SFL EPM Meetup in Miami, FL – Thursday, August 18, 2016
BI Community Event in Minneapolis, MN – September 6, 2016

Kscope16: A Look Back

Can’t get enough of Kscope16? Take a look back at our wrap-up video and the first wave of interviews with some of Kscope16’s brightest stars.

Kscope17: See You in Texas

Kscope17 is heading to San Antonio, Texas, June 25-29 at the JW Marriott San Antonio Hill Country. Abstract submission is open now through October 14, 2016. Register to attend by September 1, 2016, to take advantage of the Early, Early Bird Rate.

World of Webinars

BI.pngThursday, August 18, 2016 12:00 PM - 1:00 PM EDT
Data Wrangling, Blending, and Mashups
Wayne Van Sluys, interRel Consulting
With the release of Oracle BI Cloud Service (BICS) and OBIEE 12c, the ability for users to include External Subject Areas (XSAs) with curated models has introduced many new terms to the lexicon of Business Intelligence and Data Visualization. This session will break down the technical processes going on behind the scenes when using Data Wrangling, Data Blending, and Data Mashups with External Subject Areas (XSAs) and the functional use of each.

Register Here

Friday, August 19, 2016 1:00 PM - 2:00 PM EDT
Introduction to Breadboard Circuits and I/O for Raspberry Pi!
Jeremy Harms, EmeraldCube Solutions
Grab an old broken radio and whip out your trusty MacGyver Swiss Army knife. Buy $5 worth of electronic components. Rummage up a 9V battery and jack in a #2 pencil. Read the instructions; plug it all up. Draw a line on some paper, and touch it with your finger to become part of your circuit – you’re now literally drawing with sound! Drawing + audio = the Drawdio circuit. 

  • Breadboard circuits 101 
  • Tools of the trade 
  • Reading schematics and building circuits – Drawdio circuit demo! 
  • Physical computing I/O example – integrate a circuit with Raspberry Pi pins 

Register Here

Friday, August 26, 2016 1:00 PM - 2:00 PM EDT
APEX Pi: Interfacing the Raspberry Pi with APEX
Christoph Ruepprich, Accenture Enkitec Group

The Raspberry Pi is a wonderful experimentation platform. In this presentation we will see how we can interface the Rasberry Pi’s hardware with Oracle APEX. Learn how we gain access to the GPIO (General Input/Output) ports, and control attached hardware. This knowledge can be used to build home automation/control systems and much more.

Register Here

EPM.pngThursday, September 8, 2016 3:00 PM - 4:00 PM EDT
Examine the Realities of Exalytics
Jeff Henkel, CheckPoint Consulting

Are you interested in having the most powerful performance that Oracle offers? Does your EPM system bog down under lengthy and complex consolidations or calculations? In this webinar, we will discuss the benefits and potential cost savings in using an Exalytics platform for your organization. We will share real-time implementations of the largest Exalytics systems in the market documented by Oracle. Presented by the consultants who implemented them, this will be a rich, instructive review. Be sure to bring your questions; we encourage an open dialogue. 

Register Here

EPM.pngTuesday, September 13, 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.pngWednesday, 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 Two of a Two-Part Series – Liberate ASO Procedural Calcs from Admin Ownership

Make ASO procedural calcs 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. There are many use cases for this that will be discussed in this webinar. Another popular use case allows a user to trigger a BSO calc and then subsequently refresh a partition to push the BSO calc results to an ASO reporting cube.

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

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

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

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



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