ODI to Essbase: There and Back Again

Once again, John Goodwin has outdone himself by an exhaustive in-depth study of how ODI and Essbase work together to improve data integration to Enterprise Performance Management applications. On his very first blog on the subject, John writes on his views of ODI:

If you load hierarchies from files or manage them straight from a repository then ODI (Oracle Data Integrator) could be the way you want to go, it offers all this functionality and so much more.

John goes on to describe in over 20 detailed blogs just what he means by "more" for how it works, tips and tricks, and the benefits of the ODI + Essbase solution. He describes how to use the connectors and Knowledge Modules – which provide pre-built functionality for specific tasks for Essbase integration that save effort in having to re-invent the wheel.

Below are the blog series for your reference where you can step through one or all of them. Keep his blog in your RSS feed for upcoming results. Thanks again John for your outstanding effort.

Introduction to Oracle Data Integrator
The Agent
Essbase Quick Fix
Configuration
Enter the Designer
SQL to Planning
Data Load to Planning
A diversion, Text to Planning
ODI & Planning - Brief look into file manipulation
Essbase Outline Extractor
ODI / Essbase challenge - Extracting alternate alias member information
Loading Essbase Metadata
Loading SQL Metadata into Essbase and its problems
Planning and multiple UDAs
Loading data into Essbase
Extracting data from Essbase
Essbase to Planning
ODI Release Update
ODI Series - Putting it all together
ODI Series – A few extra tips
ODI Series – The final installment
Essbase/Planning – Automating changes in data - Part 1
Essbase/Planning – Automating changes in data - Part 2
ODI Hyperion Knowledge Modules - Reporting statistics correctly

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today