Enterprise Performance Management (EPM) using Oracle Essbase.

This is a past event

28 people went

Regis University

3333 Regis Blvd · Denver, CO

How to find us

computer lab in Carroll Hall, Regis Lowell Campus, Room #19

Location image of event venue


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:00--‐8:15AM --‐ Registration and Continental Breakfast

8:15--‐8:30AM --‐ Enterprise Database Systems and Performance Management – Case Overview

Relational Databases Performance Management Multi--‐dimensional Databases System Integration 8:30--‐9:15AM --‐ Introduction to Financial Reports and Analytic Reporting Model

Amazon AWS --‐ Remote Desktop Connection Introduction to Workspace and Financial Reports Introduction to Essbase Administration Services Console Applications and Databases Outlines, Dimensions and Hierarchies Calc Scripts and Member Formulas 9:15--‐9:30AM --‐ Break

9:30--‐10:30AM --‐ Introduction to Analytic Models and Data Integration

Updating the Outline Introduction to Loading Data to Essbase --‐ Essbase Load Rules Updating the Load Rule Loading Data with Load Rule Review Updated Reports Introduction to Reports Studio

10:30--‐10:45AM --‐ Break

10:45AM--‐11:45AM – Reporting and Analytics

Introduction to Smart View Office Integration with Smart View More on Financial Reporting Studio

11:45AM--‐12:00PM--‐ Break (Lunch is Served)

12:00--‐1:00PM --‐ Other Topics and Q&A Over Lunch

Performance Management and Driver Based Modeling Operational Metrics and Performance Management Synchronizing Metadata Aggregate Storage & MDX Security & Tuning Other Considerations and Best Practices