5 Replies Latest reply on Feb 22, 2011 3:16 PM by TonyScalese

Help understanding ERPi and planning

user9213000 Feb 22, 2011 1:17 PM

Hi All,

Planning/Essbase. Version is 11.1.2.

Can you please help me understand the role of the ERPi adapter. I have hyperion planning that sits on an essbase cube. We load data and metadata from E-Business Suite 11. From forms and reports I want to drill back to the data in EBS. I have installed and configured the ERPi adaptor and the scenarios in ODI

Question 1)

Do I need to load data and metadata to be able to drill-through.

Question 2)
I have set my target and source systems - where do I configure the "Drill Through"

thanks in advance for any help offered.

1. Re: Help understanding ERPi and planning

791664 Feb 22, 2011 1:36 PM (in response to user9213000)

Hi There,

To answer your questions...
1. This part of the process from what I've seen is integral to the product working - so the answer is yes
2. Drill through is defined in a number of places one of those is in the "Target Application Registration" within ERPi and there is also a flag within the the adapter.

Oracle have produced some good step by step documentation on this, please check metalink for note ID 951369.1 and this will take you through the process.

HTH

Mark
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Help understanding ERPi and planning

user9213000 Feb 22, 2011 1:53 PM (in response to 791664)

Thanks Mark for your reply

The document must be a different version to mine - I can't seem to locate these metadata rules.

What do I need FDM for? Must I load the data into FDM first? I thought I could just use ERPi adaptor and ODI.
Like Show 0 Likes(0)

Actions
3. Re: Help understanding ERPi and planning

TonyScalese Feb 22, 2011 2:07 PM (in response to user9213000)

You do NOT need to load metadata via ERPi in order to drill through. Only data needs to be loaded.

The drill through configuration is part of the installation & configuration process.

I would review the install documents available here:

http://www.oracle.com/technology/documentation/epm.html
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Help understanding ERPi and planning

791664 Feb 22, 2011 3:11 PM (in response to TonyScalese)

Hi Tony,

Thanks for the clarification.

It's just that we've had issues with the MetaData refresh which impacted the data integration that also builds the drill through regions.

thanks

Mark
Like Show 0 Likes(0)

Actions
5. Re: Help understanding ERPi and planning

TonyScalese Feb 22, 2011 3:16 PM (in response to 791664)

Let me clarify, you need to run the metadata rule in ERPi but you do not need to load the metadata to the EPM application. I think a lot of confusion exists around that point.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.