odi blog
TRANSCRIPT
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 112
Business Intelligence ndash Oracle
Home
About Me
Contact Me
Workshop Series
Your Questions
Category
Acquisitions
All Posts
APEX
Bi Publisher
Coherence
Conference
Data MiningData Modelling
Database
Enterprise Performance Foundation
EPM
General
Hyperion Business Rules
Hyperion DIM
Hyperion Essbase
Hyperion Financial Reporting
Hyperion Shared Services
Hyperion Web Analysis
Hyperion Workspace
Informatica
Mapviewer
OBI EE Plus
OLAP
Oracle 11g
Oracle Data Integrator
Oracle EPMA
OWB
Web Center Suite
Top Posts
Oracle BI EE 10133 - Configuring Delivers - iBots
Your Questions
Customizing OBI EE ndash GO URL Parameters
Oracle Reports to BI Publisher - Conversion Utility
Oracle BI EE 101332 - Changing Administrator Passwords - Impact on BI Scheduler and BI
Publisher - Understanding Impersonation
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 212
Oracle BI Publisher and BI EE - Invisible Admin Tab
Oracle BI EE 101332 - Write Back Option - BudgetingPlanning
Customizing OBI EE - SOAP API
Oracle BI EE 101332 - Top 10 Common Errors
Hyperion Financial Reporting - Getting Started
Oracle BI EE 101332 - Between Prompts for Date Columns - Using Presentation Variables
Oracle BI EE 1013332 - Row Level Security and Row-wise Intialized Session Variables
Pages
About Me
Contact Me
Workshop Series
Your Questions
February 2009M T W T F S S
laquo Jan Mar raquo
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28
ArchivesJune 2009
May 2009
April 2009
March 2009
February 2009
January 2009
December 2008
October 2008
September 2008
August 2008July 2008
June 2008
May 2008
April 2008
March 2008
February 2008
January 2008
December 2007
November 2007
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 312
October 2007
September 2007
August 2007
July 2007
Bookmark
About Me
I am Venkatakrishnan J a Business Intelligence enthusiast working with Rittman Mead Consulting who
likes blogging about acquisitions in the BI space technical workings of the BI tools in general and
Oracle Business Intelligence tools in particular All the views expressed here are my own and does not
reflect the views of Rittman Mead Consulting or Oracle Going forward i would be blogging at
httprittmanmeadcomblog
Blogroll
Abhinav Agarwal
Adrian Ward
Alex
Andriy Yakushyn
Antonio Romero
Asktom
Borkur Steingrimsson
Christian Berg
David Aldridge
Dimitri Gielis
Doug Burns
Eddie Awad
Frank Buytendijk
Howard Rogers
John Goodwin
John Minkjan
Jonathan Lewis
Justin Kestelyn
Karthik
Laurent Scheider
MAIA Blog
Marcos Campos
Michael Armstrong-Smith
Oracle OLAP Blog
Pawel Barut
Pete Finnigan
Peter Scott
Ramkumar Krishnan
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 412
Rittman and Jon Mead
Tim Dexter
Tim Hall
Tom Kyte
Vlamis
Subscribe
Entries (RSS)
Comments (RSS)
Meta
Register
Log in
Entries RSS
Comments RSS
WordPresscom
Stats
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Oracle Data Integrator 10135 ndash Loading Data into Hyperion
Essbase Cubes from Relational Data Sources ndash Using Rule Files
Posted by Venkatakrishnan J on February 13 2009
I was on a call yesterday with an Oracle partner who was developing a custom data loading solution(for a
complex reporting system involving Essbase Oracle OLAP and Oracle 10g) for one of his customers One of
the issues that they were facing was in using ODI to do data loads into Hyperion Essbase Before i proceed
further i would like to point out Johnrsquos article series here which has the details on how to go about using ODI
for loading into Essbase The issue faced by the partner was they were not comfortable in using JAPI
provided by ODI as they felt that the data loads could be much faster using traditional approaches They were
actually used to loading data through rule files using the SQL Interface And they were of the opinion that
SQL Interface was performing better than the JAPI Though the conclusion arrived at was not correct as
there were no quantifying factsmetrics stating JAPI load was slower than the SQL Interface this question
made sense as the partner was more or less new to ODI and was not comfortable in using JAPI for data loads
But one of the features that they liked about the ODI and Essbase integration was the ability to define
Essbase connections which offered them the flexibility of doing every data load using the ODI interfaces The
partner basically wanted to know of a way where an ODI interface could be created with no mappings to the
source and all the interface should do is to call a Rule file through the SQL Interface and load the data I
thought i would blog about this since this is more or less a common requirement considering the fact that
many Essbase customers use the SQL interface rather than the JAPI First let us start with creating a physical
schema using the Hyperion Essbase Technology
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 512
The next step is to create a logical schema and establish a relationship between the physical and logical
connections using a context
Now lets jump over to the designer and create a model While importing the objects choose customized
reverse and enter the relevant details as shown below
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 212
Oracle BI Publisher and BI EE - Invisible Admin Tab
Oracle BI EE 101332 - Write Back Option - BudgetingPlanning
Customizing OBI EE - SOAP API
Oracle BI EE 101332 - Top 10 Common Errors
Hyperion Financial Reporting - Getting Started
Oracle BI EE 101332 - Between Prompts for Date Columns - Using Presentation Variables
Oracle BI EE 1013332 - Row Level Security and Row-wise Intialized Session Variables
Pages
About Me
Contact Me
Workshop Series
Your Questions
February 2009M T W T F S S
laquo Jan Mar raquo
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28
ArchivesJune 2009
May 2009
April 2009
March 2009
February 2009
January 2009
December 2008
October 2008
September 2008
August 2008July 2008
June 2008
May 2008
April 2008
March 2008
February 2008
January 2008
December 2007
November 2007
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 312
October 2007
September 2007
August 2007
July 2007
Bookmark
About Me
I am Venkatakrishnan J a Business Intelligence enthusiast working with Rittman Mead Consulting who
likes blogging about acquisitions in the BI space technical workings of the BI tools in general and
Oracle Business Intelligence tools in particular All the views expressed here are my own and does not
reflect the views of Rittman Mead Consulting or Oracle Going forward i would be blogging at
httprittmanmeadcomblog
Blogroll
Abhinav Agarwal
Adrian Ward
Alex
Andriy Yakushyn
Antonio Romero
Asktom
Borkur Steingrimsson
Christian Berg
David Aldridge
Dimitri Gielis
Doug Burns
Eddie Awad
Frank Buytendijk
Howard Rogers
John Goodwin
John Minkjan
Jonathan Lewis
Justin Kestelyn
Karthik
Laurent Scheider
MAIA Blog
Marcos Campos
Michael Armstrong-Smith
Oracle OLAP Blog
Pawel Barut
Pete Finnigan
Peter Scott
Ramkumar Krishnan
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 412
Rittman and Jon Mead
Tim Dexter
Tim Hall
Tom Kyte
Vlamis
Subscribe
Entries (RSS)
Comments (RSS)
Meta
Register
Log in
Entries RSS
Comments RSS
WordPresscom
Stats
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Oracle Data Integrator 10135 ndash Loading Data into Hyperion
Essbase Cubes from Relational Data Sources ndash Using Rule Files
Posted by Venkatakrishnan J on February 13 2009
I was on a call yesterday with an Oracle partner who was developing a custom data loading solution(for a
complex reporting system involving Essbase Oracle OLAP and Oracle 10g) for one of his customers One of
the issues that they were facing was in using ODI to do data loads into Hyperion Essbase Before i proceed
further i would like to point out Johnrsquos article series here which has the details on how to go about using ODI
for loading into Essbase The issue faced by the partner was they were not comfortable in using JAPI
provided by ODI as they felt that the data loads could be much faster using traditional approaches They were
actually used to loading data through rule files using the SQL Interface And they were of the opinion that
SQL Interface was performing better than the JAPI Though the conclusion arrived at was not correct as
there were no quantifying factsmetrics stating JAPI load was slower than the SQL Interface this question
made sense as the partner was more or less new to ODI and was not comfortable in using JAPI for data loads
But one of the features that they liked about the ODI and Essbase integration was the ability to define
Essbase connections which offered them the flexibility of doing every data load using the ODI interfaces The
partner basically wanted to know of a way where an ODI interface could be created with no mappings to the
source and all the interface should do is to call a Rule file through the SQL Interface and load the data I
thought i would blog about this since this is more or less a common requirement considering the fact that
many Essbase customers use the SQL interface rather than the JAPI First let us start with creating a physical
schema using the Hyperion Essbase Technology
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 512
The next step is to create a logical schema and establish a relationship between the physical and logical
connections using a context
Now lets jump over to the designer and create a model While importing the objects choose customized
reverse and enter the relevant details as shown below
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 312
October 2007
September 2007
August 2007
July 2007
Bookmark
About Me
I am Venkatakrishnan J a Business Intelligence enthusiast working with Rittman Mead Consulting who
likes blogging about acquisitions in the BI space technical workings of the BI tools in general and
Oracle Business Intelligence tools in particular All the views expressed here are my own and does not
reflect the views of Rittman Mead Consulting or Oracle Going forward i would be blogging at
httprittmanmeadcomblog
Blogroll
Abhinav Agarwal
Adrian Ward
Alex
Andriy Yakushyn
Antonio Romero
Asktom
Borkur Steingrimsson
Christian Berg
David Aldridge
Dimitri Gielis
Doug Burns
Eddie Awad
Frank Buytendijk
Howard Rogers
John Goodwin
John Minkjan
Jonathan Lewis
Justin Kestelyn
Karthik
Laurent Scheider
MAIA Blog
Marcos Campos
Michael Armstrong-Smith
Oracle OLAP Blog
Pawel Barut
Pete Finnigan
Peter Scott
Ramkumar Krishnan
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 412
Rittman and Jon Mead
Tim Dexter
Tim Hall
Tom Kyte
Vlamis
Subscribe
Entries (RSS)
Comments (RSS)
Meta
Register
Log in
Entries RSS
Comments RSS
WordPresscom
Stats
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Oracle Data Integrator 10135 ndash Loading Data into Hyperion
Essbase Cubes from Relational Data Sources ndash Using Rule Files
Posted by Venkatakrishnan J on February 13 2009
I was on a call yesterday with an Oracle partner who was developing a custom data loading solution(for a
complex reporting system involving Essbase Oracle OLAP and Oracle 10g) for one of his customers One of
the issues that they were facing was in using ODI to do data loads into Hyperion Essbase Before i proceed
further i would like to point out Johnrsquos article series here which has the details on how to go about using ODI
for loading into Essbase The issue faced by the partner was they were not comfortable in using JAPI
provided by ODI as they felt that the data loads could be much faster using traditional approaches They were
actually used to loading data through rule files using the SQL Interface And they were of the opinion that
SQL Interface was performing better than the JAPI Though the conclusion arrived at was not correct as
there were no quantifying factsmetrics stating JAPI load was slower than the SQL Interface this question
made sense as the partner was more or less new to ODI and was not comfortable in using JAPI for data loads
But one of the features that they liked about the ODI and Essbase integration was the ability to define
Essbase connections which offered them the flexibility of doing every data load using the ODI interfaces The
partner basically wanted to know of a way where an ODI interface could be created with no mappings to the
source and all the interface should do is to call a Rule file through the SQL Interface and load the data I
thought i would blog about this since this is more or less a common requirement considering the fact that
many Essbase customers use the SQL interface rather than the JAPI First let us start with creating a physical
schema using the Hyperion Essbase Technology
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 512
The next step is to create a logical schema and establish a relationship between the physical and logical
connections using a context
Now lets jump over to the designer and create a model While importing the objects choose customized
reverse and enter the relevant details as shown below
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 412
Rittman and Jon Mead
Tim Dexter
Tim Hall
Tom Kyte
Vlamis
Subscribe
Entries (RSS)
Comments (RSS)
Meta
Register
Log in
Entries RSS
Comments RSS
WordPresscom
Stats
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Oracle Data Integrator 10135 ndash Loading Data into Hyperion
Essbase Cubes from Relational Data Sources ndash Using Rule Files
Posted by Venkatakrishnan J on February 13 2009
I was on a call yesterday with an Oracle partner who was developing a custom data loading solution(for a
complex reporting system involving Essbase Oracle OLAP and Oracle 10g) for one of his customers One of
the issues that they were facing was in using ODI to do data loads into Hyperion Essbase Before i proceed
further i would like to point out Johnrsquos article series here which has the details on how to go about using ODI
for loading into Essbase The issue faced by the partner was they were not comfortable in using JAPI
provided by ODI as they felt that the data loads could be much faster using traditional approaches They were
actually used to loading data through rule files using the SQL Interface And they were of the opinion that
SQL Interface was performing better than the JAPI Though the conclusion arrived at was not correct as
there were no quantifying factsmetrics stating JAPI load was slower than the SQL Interface this question
made sense as the partner was more or less new to ODI and was not comfortable in using JAPI for data loads
But one of the features that they liked about the ODI and Essbase integration was the ability to define
Essbase connections which offered them the flexibility of doing every data load using the ODI interfaces The
partner basically wanted to know of a way where an ODI interface could be created with no mappings to the
source and all the interface should do is to call a Rule file through the SQL Interface and load the data I
thought i would blog about this since this is more or less a common requirement considering the fact that
many Essbase customers use the SQL interface rather than the JAPI First let us start with creating a physical
schema using the Hyperion Essbase Technology
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 512
The next step is to create a logical schema and establish a relationship between the physical and logical
connections using a context
Now lets jump over to the designer and create a model While importing the objects choose customized
reverse and enter the relevant details as shown below
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 512
The next step is to create a logical schema and establish a relationship between the physical and logical
connections using a context
Now lets jump over to the designer and create a model While importing the objects choose customized
reverse and enter the relevant details as shown below
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 612
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 712
Now the next step is to create a custom project (or use an existing project) This project should have all the
Knowledge Modules Now duplicate the ldquoIKM SQL to Hyperion Essbase (DATA)rdquo and give it a custom
name ldquoIKM Essbase Data Load using Rule Filesrdquo
And in the custom tab remove the steps ldquoLoad Data Into Essbaserdquo and ldquoReport Statisticsrdquo from the IKM
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 812
The reason for removing these 2 steps is to ensure that the IKM does not use JAPI to do the data loads Now
lets create a new interface and include the fact table related to the Global cube as target into the InterfaceEnsure that the staging area is SUNOPSIS_MEMORY_ENGINE
Now go to the flow control and choose the custom IKM that we create above Since we have removed 2
steps Load Data into Essbase and Report Statistics the not all the options that you see for the IKM are
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 912
relevant anymore The only options that are relevant are given below
Now in order to use the SQL interface to load the rule files create a maxL script as shown below and save it
as GlobalUnitsLoadmaxL
As you see the maxL script basically spools the log out to a specific file And also it calls the rules file to do a
data load When this data load happens it would be through the sql interface Now come back to the
Interface and in the options for the IKM enter the below details The maxL script would be called through the
PRE_LOAD_MAXL_SCRIPT option
Now save and run this interface
Now you should be able to bypass the JAPIs to do your data loads This is not always the recommended
option But neverthless this is something that would be wanted by everyone who is new to ODI and who is
used to loading rule files through the sql interface
983089 983155983152983151983151983148 983151983150 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983148983151983143983079983099
983090 983145983149983152983151983154983156 983140983137983156983137983138983137983155983141 983079983111983148983151983138983137983148983079983086983079983111983148983151983138983137983148983079 983140983137983156983137 983139983151983150983150983141983139983156 983137983155 983079983143983148983151983138983137983148983079 983145983140983141983150983156983145983142983145983141983140 983138983161 983079983143983148983151983138983137983148983079 983157983155983145983150983143 983155983141983154983158983141983154 983154983157983148983141983155983135983142983145983148983141
983079983125983150983145983156983155983116983140983079 983151983150 983141983154983154983151983154 983159983154983145983156983141 983156983151 983079983108983098983132983111983148983151983138983137983148983125983150983145983156983155983116983151983137983140983086983141983154983154983079983099
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
2 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1012
Like Be the first to like this post
This entry was posted on February 13 2009 at 913 am and is filed under Hyperion Essbase All Posts EPM
Oracle Data Integrator You can follow any responses to this entry through the RSS 20 feed You can leave a
response or trackback from your own site
4 Responses to ldquoOracle Data Integrator 10135 ndash Loading Data into Hyperion Essbase
Cubes from Relational Data Sources ndash Using Rule Filesrdquo
BASH said
March 26 2009 at 611 am
Hi Venkatakrishnan
Your blog is great Your topics are very useful Your explanations make sense and they are very easy to
follow Thank you
Wersquore loading over 6 million records into an Essbase ASO cube The load is fast at under 2 minutes
However getting the data out of the Relational server and over to the Essbase server is killing us that
part takes over 2 hours In addition to optimizing our query as a stored procedure would you
recommend ODI as the fastest way to get the data from our data warehouse into an Essbase ASO cube
Any other suggestions about getting this done in lightning speed
Thank you
Reply
1
kalyan said
March 31 2009 at 1206 pm
2
Download Google ChromeSearching is fast and easy with Googles
web browserwwwGooglecomChrome
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1112
Hi
This is kalyanI am working as a software Engineer in a small company hyderabad
Few days back I got a chance to work on Hyperion Essbase from that time I am not able to find any
PDF or step by step guide to work on that tool
I hope you understand my problem and hope to suggest me
Regars
kalyan chakravarthyk
Reply
Ahmad said
April 12 2009 at 1230 pm
Hi
Nice Blog special for beginner like me
on one of our client they have oracle EBS R12 and Hyperion System 9 and client want to load data in
such a way that he can schedule uploading like backup in night etc
you are aware of any tool script by using which we can achieve this functionality
Thanks
Ahmad
Reply
3
Reid Lai said
April 20 2009 at 110 pm
Hi Venkatakrishnan
When I followed your instruction to populate date from Oracle DB to Essbase I found there Flow tab
was disabled until I drag source data model into Interface Diagram I also tried to map loading and
integration knowledge module in order to execute the interface but canrsquot find appropriate KM from the
list box Do you have any hint Thanks
Cheers
Reid
Reply
4
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
12 7192011
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra
7232019 ODI Blog
httpslidepdfcomreaderfullodi-blog 1212
Notify me of follow-up comments via email
Notify me of new posts via email
Post Comment
Leave a Reply
laquo Oracle BI EE 10134 and Hyperion Web Analysis ndash Drill from BI EE to Web Analysis ndash Part 1
Hyperion Essbase 11110 ndash Database Archive and Replay in BSO Cubes raquo
Blog at WordPresscom | Theme Andreas09 by Andreas Viklund
Log In Log In Log In
e Data Integrator 10135 ndash Loading Data into Hyperion Essbase Cu httporaclebizintwordpresscom20090213oracle-data-integra