Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with ODI importing scenerio

DonsieJun 18 2014 — edited Jun 19 2014

Please help

I am trying to configure ERP integrator so I can integrate Hyperion with EBS. I installed hyperion 11.1.2.2 with FDQM. I am using ODI 11.1.1.7.0, when I try importing scenerios into ODI I cannot find the scenerio folder under

this path HYPERION_HOME\products\FinancialDataQuality\odi\ Where else can I find it to import the scenerios? and

is it a requirement to import the scenerios in order for the integration to be successfully.

Comments

user7417334
If you re-create the join with the exact name / identifier you can still open the workbook without any problem.
Make sure it is similar join which was deleted.
dianap
Thanks for the feedback.

The thing is I don't know the exact identifier anymore of the deleted joins.

Regards,
Diana
user7417334
Do you have any other instance, where you can find the identifier for the same join ?
dianap
No :(
user13716376
There is a workbook DUMP utility that will have a section that will show the EXACT name of the join for updating .. then the the workbook will open
dianap
Thanks,

Where is this workbook DUMP utility?

Diana
dianap
Hi,

After some search, I found how the dump works.
So I executed this.

For some joins, it's showing that the name has been changed:
Example:
*** Found in EUL by id *** Name has changed to r_area_well.r_area_s 1
So now I changed the name of the joins in the BA to the naming showing in the file ( for this example: r_area_well.r_area_s 1).

But still the workbook will not open. It keeps giving the item dependency not found error.

Diana
user7417334
I guess this time its looking for another item and identifier which might have been deleted. More investigation needs to continue
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2014
Added on Jun 18 2014
4 comments
1,742 views