Course : TRN 205 : Oracle BI EE, Essbase and Hyperion Integration

Overview : This course teaches delegates how to import, model and then work with Oracle Hyperion Essbase data within Oracle BI EE 10g. Delegates will learn how to integrate Essbase data with relational models, how to apply security across both data sources and the workarounds and issues that they may need to apply to produce required reports.

The course also covers importing Oracle BI EE data into Essbase using Essbase Studio, together with integration between Oracle BI EE dashboards and the Oracle EPM Workspace. The course covers versions 9.3.1 and 11.1.1.3 of Essbase, together with version 10.1.3.4.1 of Oracle BI EE 10g.

Duration : 2 Days

Course Delivery : Developers, consultants, project managers, technical leads, DBAs

Who Should Attend :End-users, developers, project managers

Prerequisites : 202 Oracle BI EE 10g Basic Administration and 203 Oracle BI EE 10g Advanced Administration

Detailed Course Agenda :

Day 1

1. Basic Essbase Integration

  • Oracle BI EE, Hyperion and Essbase Overview
  • Integration Points
  • Importing an Essbase cube into Oracle BI EE
  • Renaming and post-load steps
  • Creating simple reports against Essbase data

2. Vertical and Horizontal Data Federation

  • Vertical federation of Essbase and relational data
  • Horizontal federation of Essbase and relational data
  • Dealing with ragged hierarchies and outline changes

3. Leveraging MDX Functions

  • Understanding function shipping and Essbase data sources
  • Using EVALUATE and EVALUATE_AGGR
  • Leveraging Essbase advanced calculations

Day 2

4.Security Integration

  • Using Essbase Filters
  • Using Oracle BI EE security filters
  • Security considerations and workarounds

5. Integration with EPM Workspace

  • EPM Workspace overview
  • Registering OBIEE with EPM Workspace
  • Integrating dashboards and answers with EPM Workspace UI and catalog
  • Security considerations

6. Populating Essbase cubes with OBIEE data using Essbase Studio

  • Preparing Oracle BI EE data for integration
  • Creating Essbase Studio Metadata
  • Performing the data load
  • Integrating Essbase data back into OBIEE semantic layer

To book this course for your organization, to customize this course or for more information, contact training@rittmanmead.com for more details.

Website Design & Build: tymedia.co.uk