AUGUST 09, 2013
Come Learn and Play at the Next
Quarterly Educational Workshop
Elitch Gardens Theme and Water Park
2000 Elitch Circle Denver, CO 80204
This year RMOUG has partnered with Oracle and Intel to bring you the latest on 12c
Please join us on August 9th. Don’t forget to bring the family along for $15.00 (each)
$15 for Parking ($20 VIP)
Play hooky from work!
(shhh, don’t let the boss know)
Instead, tell the boss about the great speakers presenting in the morning.
Heck, invite the boss!
It’s the end of summer, and what better way to celebrate than to spend the afternoon networking with other RMOUG members and their families?
Registration Required! (Please register by August 2nd so we can order food)
Discover the Latest Breakthroughs!
Oracle Database 12c is here, complete with over 500 new features. Join Oracle and Intel at Oracle Technology Day to see firsthand how this new multitenant architecture makes it easy to deploy and manage database clouds.
Oracle experts will be on hand to provide a comprehensive overview of this new release. And your peers will be there to share perspectives on the impact of the latest breakthrough in Oracle. You do not want to miss this exclusive event, where you will learn how to:
Simplify database consolidation
Automatically compress and tier data
Improve application continuity
Redact sensitive data
8:00 am Registration and Continental Breakfast
8:30 am Keynote: Plug into the Cloud with Oracle Database 12c
9:15 am Security Inside Out‚ Latest Innovations in Oracle Database 12c
9:55 am Break
10:05 am Maximize Availability with Oracle Database 12c
10:45 am Automate Information Lifecycle Management with Oracle Database 12c
11:25 am Break
11:30 am Simplify Consolidation with Oracle Database 12c
12:10 pm Networking Lunch
1:00 pm Drive Database as a Service with Oracle Exadata
1:40 pm Managing Oracle Database 12c with Oracle Enterprise Manager 12c
2:15 pm Theme Park Fun
Apex vs ADF — Moving to a Modern Development Environment
This is a Meetup Group event. Click here to access the Meetup Event!
In a partnership with the Rocky Mountain Oracle User Group (RMOUG), Avout, an Oracle Gold Partner, has agreed to host an all-day, hands-on lab on June 14th , 2013, covering real‐world issues organizations need to consider when looking at modernizing their Oracle-driven applications. The lab will cover the following subject areas:
- 08:00‐08:45AM – Modern development – what Forms & PL/SQL developers need to know
- 08:45‐09:00AM ‐ Break
- 09:00‐10:00AM – Apex – an introduction
- 10:45-11:00AM – Break
- 11:00‐12:00PM – ADF – an introduction
- 12:00‐12:45PM – Lunch / questions / networking
- 12:45-01:45PM – Apex and ADF side-by-side: Distinguishing Characteristics
- 01:45-02:00PM – Break
- 02:00-03:00PM – Mobile topics
**Hyperion EPM – Special Interest Group**
May 17th, 2013
Oracle Broomfield Campus
Question please e-mail Heidi at firstname.lastname@example.org Or call 303.948.1786
$15 visitor fee
7:30 am – 8:15 am Continental Breakfast
8:15 am – 9:15 am XML Processing with Oracle 11g
8:15 am – 9:00 am A Leap of Faith: Upgrading a Hyperion Environment at Catholic Health Initiatives
9:25 am – 10:25 am Three Types of Table Compression
9:10 am – 9:55 am Using EIS and EAS to dynamically refresh Essbase cubes
10:05 am – 10:50 am Hyperion Tips & Tricks for Maintaining a Steady and Proficient Environment
10:35 am – 11:35 am The new 12c kid on the block
11:00 am – 11:45 am OBIEE and Essbase Jointed at the Hip
11:45 am – 12:45 pm WIT Session: “The Imposter Syndrome- When Successful Women Feel Like Frauds”
11:55 am – 12:40 pm Implementing EPM and Tri-State Generation and Transmission
Lunch to introduce the WIT members 11:45 am during Kellyn’s session
12:45pm 1: 55pm Board Meeting (open to all members), Board Elections and Annual Membership
8:15 am – 9:15 am
XML Processing with Oracle 11g
Don Schaefer, Ingenix, Senior Software Engineer
With the introduction of Oracle 11g, Oracle has released new versions of three applications utilized for XML Processing: Oracle XML Developer Kit 11g, Oracle XML DB 11g and JDeveloper 11g.
Specifics for the presentation.
- Oracle XML Developer Kit 11g Release 2. XML Parsers using industry standard DOM and SAX interfaces. Java, C++ and the Java API for XML processing. XSL Processor. XML SQL Utitlity
- Oracle XML DB 11g Release 2. Oracle XMLtype Datatype, XMLQuery, XMLTable, Full Text Search over XML Data.
- Processing XML Documents with Oracle JDeveloper 11g Release 2
8:15 am – 9:00 am
A Leap of Faith: Upgrading a Hyperion Environment at Catholic Health Initiatives
Ross B Kimball, Manager, Financial Systems Integration, Catholic Health Initiatives
The challenges of upgrading from 9.3.1 to 22.214.171.124 are many, but there are none that can’t be overcome. Some of the challenges are substantial, such as the migration from EAS to Calc Manager, or the migration of the user community to the new SmartView. And some challenges are more subtle such as the migration of Planning forms and Financial Reports. My presentation will guide users through some of our key lessons learned during the upgrade, and detail out what I consider to be best practices for any Hyperion upgrade.
9:25 am – 10:25 am
Three Types of Table Compression
Tim Gorman, Independent Consultant, Evergreen Database Technologies, Inc.
There are several types of table compression in Oracle database, and so the question must arise: which are most appropriate, based on what requirements? Why are there different methods, which ones work for what situation, and why?
We will discuss all the different types of table data compression in Oracle database (i.e. basic/advanced de-duplication compression and hybrid-columnar compression), as well as some older often-forgotten techniques for fitting more data into less space. The presentation will begin with a brief review of data compression in general, followed by a review of the formats used for storage in database blocks and rows, the latter supported by block dumps. All leads to a knowledgeable discussion of the advantages and disadvantages of each type of table compression in Oracle. At the end, we get to the subject of the talk, which is a form of compression which has always existed within Oracle database, but which can only be exploited when you know how data is stored internally.
9:10 am – 9:55 am
Using EIS and EAS to dynamically refresh Essbase cubes
Qingchen Chen, Hyperion Applications Analyst, Berry Petroleum Company
Berry Petroleum Company uses Essbase cubes for reporting on Financial, Capital Spending and Production data. We need to refresh all 3 BSO cubes automatically each night. EIS (Essbase Integration Services) is used to refresh Essbase outlines from Oracle source. Load rule is used to load data to Essbase via SQL interface. Automation is scheduled via MAXL scripting.
10:05 am – 10:50 am
Hyperion Tips & Tricks for Maintaining a Steady and Proficient Environment
Lester Trough, Senior Consultant Manager of IT and Support, Abeam Consulting
With the complex nature of Hyperion come a variety of issues which often lead to poor performance which will plaguing your Hyperion environment, along with your end users and IT department. In this presentation we will show you a few key tips & tricks which you will be able to implement within your Hyperion environment to enhance performance.
10:35 am – 11:35 am
The new 12c kid on the block
Peter Sharman, Oracle, Principal Product Manager
This presentation introduces the new Oracle Database 12c functionality
11:00 am – 11:45 am
OBIEE and Essbase Jointed at the Hip
Sohel Jeelani, Sr. Sales Consultant, Oracle
OBIEE has been supporting Oracle Essbase as a physical data source since the early 10g versions but now the integration between the two has become seamless. Going forward Oracle intends to tie them together even tighter so that BI content that can be deployed to a broad user audience through Oracle BI Dashboards, Analyses.
11:45 am – 12:45 pm
WIT Session: “The Imposter Syndrome- When Successful Women Feel Like Frauds”
Kellyn Pot’Vin, Enkitec, Senior Technical Consultant
What is Imposter or Fraud Syndrome? Why people feel this way, (source of the feelings). How to deal with situations to ensure fraud syndrome doesn’t impede a women from her goals.
The popular and successful actress Tina Fey, Facebook COO and author Sheryl Sandberg, among others, have all admitted to experiencing this. Research has shown, men often judge themselves consistently as performing better than their actual performance and women do the opposite. Georgia University psychologists, Pauline Rose Clance and Sue Imes started to use the term “Imposter Syndrome” back in 1978 when referring to those that were susceptible to this, but recognized women suffered from it more often. Why do highly successful women feel like imposters or frauds? This session will discuss how women can overcome and deal with the feelings involved with this phenomenon to keep it from holding them back in their goals.
11:55 am – 12:40 pm
Implementing EPM and Tri-State Generation and Transmission
Marisa Gregorio, IT Applications Development Manager, Tri-State Generation and Transmission
Tri-State, a long-time customer of Hyperion Pillar, discusses the evolution from an annual budgeting process, to a monthly forecasting model. Hear about the why the company moved to a 20-month forecast, the challenges in implementing such a change, and the future direction this utility company is heading with its EPM solutions.