Come Learn and Play QEW – August 09 at Elitch Gardens

June 13, 2013 by · Comments Off
Filed under: QEW 

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)

Register Here

Questions please e-mail Heidi at admin@rmoug.org or Carolyn at programsdir@rmoug.org

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

Agenda

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

May 2013 Quarterly Educational Workshop

April 16, 2013 by · Comments Off
Filed under: QEW, Special Interest Groups 

Rocky Mountain Oracle Users Group

 

 ID Required  

 

 

 

**Hyperion EPM –  Special Interest Group**

Details Below

 

May 17th, 2013
Quarterly Educational Workshop
And Annual Membership Meeting

 

Oracle Broomfield Campus
500 Eldorado Blvd
Building 1
Broomfield, CO 80021

Registration Required!
Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org Or call 303.948.1786

 

$15 visitor fee
For non members

 

 

 

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

 

Presentations

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

 

500 Eldorado Blvd
Show on Google Maps

 

 

 

November 2012 Quarterly Educational Workshop

October 18, 2012 by · Comments Off
Filed under: QEW 

 

 

 

ID Required

 

 

 

 

Don’t miss out on the last Quarterly Educational Workshop before Training Days

PIZZA is being sponsored by ECS Team for lunch

November 16, 2012

Oracle – Campus

7700 Technology Way

Denver, CO 80237

Building 3 (North Building)

Registration Required!

Please go to:

http://www.rmoug.org/RMOUG-forms/QEWregistration.php

Question please e-mail Heidi at admin@rmoug.org

Or call 303.948.1786

 

$15 visitor fee
For non members

 

 

 

7:45 am – 8:15 am Continental Breakfast
8:15 am – 9:15 am Essbase Calculations – Observations from the Road
9:25 am – 10:25 am Sherlock Holmes for the DBA
10:35 am -11:35 am Introduction to SOA and Oracle SOA Suite
11:45 am -12:45 pm CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
12:45 pm – 1:45 pm Board Meeting

 

Presentations

 

8:15 am – 9:15 am
Essbase Calculations – Observations from the Road
Chris Chase, Managing Partner @ The Bean Consulting Group

With nearly 25 years experience in software and database technology I thought I had seen all that programming had to offer; then I discovered Essbase. Learn some interesting observations regarding Essbase calculations accumulated over nearly 10 years of Hyperion implementations. We will discuss aggregations, allocations, eliminations, and driver-based calculations, commands and functions specific to Hyperion Planning, and some of the more confounding aspects such as block creation and cross dimensional operators.

 

9:25 am -10:25 am
Sherlock Holmes for the DBA
Kellyn Pot’Vin, Senior Technical Consultant @ Enkitec

The DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often the administrator is expected to, not only identify, but also correct the problem without impact and in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.

Attendees will leave the session with a better understanding of trouble-shooting techniques and when to use what features, tools and reports to address issues.

 

10:35 am -11:35 am
Introduction to SOA and Oracle SOA Suite
Brian Statkevicus, Senior Consultant @ ECS Team and Greg Opie, Director of Architecture @ ECS Team

Almost everyone has heard of Service Oriented Architecture (SOA). Some people can accurately describe what it is and isn’t. This introductory session will cover:

• What is SOA?
• What are the business problems solved by implementing SOA?
• Oracle’s SOA Suite
• Demo of a sample business process using SOA Suite
• SOA Case Study

 

11:45 am – 12:45 pm
CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
Bradley Brown, CEO/CTO @ InteliVideo

There is a considerable amount of free geo-spatial data available from the government and open source groups. This information can be quite helpful at providing more information about location-based data. For example, if you’re a property management company and you wanted to know close each of your properties are for anything from grocery stores to railroad tracks to flood plains, all of this information is available. If you wanted to know which homes are on a specific golf course, this data is available for free too.

In this presentation, Brad will share what geo-spatial data is available, where you can download the data, and what you might use the information for. You can also create your own layers of information and merge this into your queries. All of this can be done using an Oracle database (even the free version of Oracle) – i.e. without a mapping tool like ESRI. You can easily overlay this information onto Google maps or Google Earth. Brad will share PL/SQL code that will extract shapes into KML

 

 


View Larger Map

7700 Technology Way
Denver, CO 80237

 


Next Page »