|
|
April 2010

Featuring: Marco Rossodivita
Question: Currently, Our Company uses a Rule File to load Members and Data into Essbase. What are the alternatives to the Load Rules?
Marco: There are several alternatives to load data and members into Essbase. Load Rules are a simple choice for integration, but Oracle is offering additional alternatives for a more robust Essbase integration:
Oracle Data Integrator (9.3.1 - 11.1.1): is a multi platform EL-T integration tool that will allow integration across heterogeneous data Sources. Its latest version incorporates knowledge modules for Metadata and Data integration for Essbase and Planning. Oracle Data Integrator allows the use of Essbase as a Source as well as a Target for Data Integration.
Oracle Hyperion Essbase Integration Server (9.3.0 - 11.1.1): is an integration tool that has Essbase as a Target. Its functionality is based on Star Schema Sources to create Essbase Databases. It provides additional functionalities such as Drill to Detail (D2D) and Hybrid Analysis.
Oracle Essbase Studio (11.1.1): is a java-based integration tool. Its functionality is similar to Essbase Integration Services, but it also provides enhanced Hierarchy management and reutilization.
Hyperion Financial Data Quality Management 11.1.1 Administration (9.3.0 - 11.1.1): is a Data-Loading tool that incorporates Quality controls. It is an alternative for environments with diverse Financial Systems that need consolidation into Essbase.
Data Integration Management (9.3.1 - 11.1.1): is an OEM license for Informatica PowerCenter. It also allows integration for Essbase and Planning.
Private Mentoring Sessons
We have the ability to schedule courses on an ad-hoc basis, or arrange a Private Mentoring Session:
A Senior Consultant will tailor content to your specific needs, teach you the material, and help you troubleshoot the application on your own environment. As your Oracle Education Coordinator, I am ready to provide you with personalized service – and make your experience an easily navigable and pleasant one.
We’re Here to Help!
Doug O'Keefe
Education Coordinator
203.276.1896
doug.okeefe@kerdock.com
|
|

Kerdock Learning Videos are designed for end users for whom it is not cost effective to send to instructor-led training sessions. The recommended audience includes business-level users, new hires, employees moving to new areas, or simply those in need of “refresher” training.
Kerdock Learning Videos provide on-demand videos of common tasks and functions within the Hyperion applications, including guided narration to help users become familiar with the system. These tasks are taught using screen captures of your company’s actual applications on the environment the end users will perform their job functions.
For more information, contact
Doug O'Keefe

April 1st: Hyperion Financial Management New Products Lunch and Learn:
- Essbase Analytic Link - Deliver high performance pre-integrated reporting access to Hyperion Financial Management using Essbase
- Disclosure Management – Add rigor and process transparency to your 10Q/K and deliver self-service XBRL reporting with direct integration to Hyperion Financial Management
April 6th: Reducing the Cost and Increasing the Effectiveness of Your Enterprise Insurance Program, event with CF&W, Bank of America, and Oracle.
April 18-23rd: Collaborate 2010 - Come see us at Booth #2426. Learn more about Collaborate by visiting
oaug.collaborate10.com.
For more information on Kerdock Events, contact
Desirea Daniels

Featured Essbase & Planning course offerings available at Kerdock:
Oracle Hyperion Planning 11.1.1: Create Manage Applications– Mar 22nd & Apr 26th
Designed to teach you how to create and administer applications using the Planning software. You learn how to create applications, add dimensions and members, import members, load data, set up security, create data forms, set up task lists, set up calculations, and move a plan through the planning cycle. Exercises and a case study provide hands-on practice.
Oracle Essbase 11.1.1 Calculate Databases– Mar 29th
In this course, you learn the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.1. You review database structure and configuration and learn basic calculation building blocks, such as FIX and IF statements. Also learn a calculation script development methodology and how to correct common calculation errors. You learn how to effectively leverage dynamic calculations to optimize database performance, and create advanced calculation scripts, such as allocations, cross-database calculations, and multidimensional range calculations. Design discussions and hands-on practice sessions help reinforce important Essbase concepts.
Oracle Hyperion Financial Reporting 11.1.1 for Essbase Planning– April 15th
This course is designed to teach you how to create and manage reports with Financial Reporting, and use Essbase or Planning as the data source. You create reports, report objects, books, and batches; format reports; and add auto calculations and functions. You also learn to manage items in the repository and define permissions for report items. Exercises help you practice the skills taught.
Oracle Essbase 11.1.1: Bootcamp– April 19th
Learn the principal techniques and theories for the design of block storage databases. In this class you will create a database outline, load data into the database, analyze data with Smart View. Also, create calculation scripts (to calculate data for different scenarios) and perform advanced analysis on the database by implementing varying attribute dimensions and typed measures. Design discussions and hands-on activities help you practice the skills taught.

As the only Houston partner provider of Oracle certified training, we not only provide Oracle knowledge, but also help you advance in your career. Oracle certifications are established industry credentials. Here are the certified Oracle training courses that we are hosting in the coming month:
About Kerdock
Kerdock Consulting is an Oracle Certified Advantage Partner and Approved Education Center, specializing in Enterprise Performance Management, Oracle Business Intelligence, and Oracle E-Business Suite with a unique offering of services, training and licensing.
|
|