Importing Data in FDMEE from Oracle Tables

2776205

Hi

I have a TB data of different Entities which is loaded in Oracle Interface Tables.

I am using the FDMEE to pull the data from it into HFM.

Version is 11.1.2.3.500

How can I achieve this.

Also how many ways are there to carry out this activity.

Suggestions will be highly appreciated

Thank you for the support.

Regards

Audrian

Roshin

Hi , Can i know if this Oracle Interface Tables is in a Different database or its the Open Interface table for FDMEE . Regards , Roshin

2776205

Hi Roshin

The table is in FDM Schema but not in Open Interface table for FDMEE.

What will happen if we load those Interface tables in Open Interface table of FDMEE?

Thanks

Audrian

Roshin

Hi Audrian , I would suggest if you can load the OIF tables with TB in the format FDMEE needs ( Its mentioned in Admin Guide ) you can use the Open Interface Adapter to Pull the data from the OIF table to FDMEE and do the mapping and export to HFM . You can load the OIF tables with a batch key for each type of data so you can filter and load it . Regards , Roshin

2776205

Hi Roshin

Thank you for the suggestions.

My TB will have data from different Entities. I want to filter data of each entity and load them from separate Locations. The reason is that I don't want the user to see the TB data of Entities other than his own.

Is there any option where we can filter data according to Entity and load them from different locations?

Each Entity will have a different Location.

Is there any alternative?

Regards

Audrian