**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 18.104.22.168 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.
Enterprise Performance Management (EPM) Using Oracle Essbase.
computer lab in Carroll Hall, Regis Lowell Campus, Room #19
This is a Meetup Group event. Click here to access the Meetup Event!
Proposed Agenda for Lab
In a partnership with the Rocky Mountain Oracle User Group (RMOUG) and Regis University, the Bean Consulting Group, an Oracle partner specializing in Essbase and Hyperion Applications, has agreed to host a five–‐hour hands–‐on lab on April 6th , 2013, covering a real–‐world case of Enterprise Performance Management (EPM) using Oracle Essbase. The lab will cover the following subject areas:
- 8–‐8:45AM –‐ Enterprise Database Systems and Performance Management –Case Overview
- Relational Databases
- Performance Management
- Multi–‐dimensional Databases
- System Integration
- 8:45–‐9:00AM –‐Break
- 9:00–‐10:45AM –‐Essbase
- Essbase Administration Services Console
- Applications and Databases
- Outlines, Dimensions and Hierarchies
- Loading Data with Load Rules
- Calc Scripts and Member Formulas
- 10:45–‐11:00AM –‐ Break
- 11:00AM–‐12:30PM –‐ Reporting and Analytics
- Workspace and Financial Reports
- Reports Studio – An Introduction
- Ad Hoc Analysis with Smart View
- Office Integration with Smart View
- 12:30–‐1:00PM –‐ Other Topics & Lunch
- Other Integration Options
- Aggregate Storage Option
- Considerations and Best Practices
Digital Versions of RMOUG SQL>UPDATE Newsletters are Now Available for Preview and Download!
Select Newsletter and then RMOUG SQL>UPDATE Newsletters Online from the top menu bar, or click here to access them.