Forum Stats

  • 3,759,064 Users
  • 2,251,495 Discussions
  • 7,870,478 Comments

Discussions

Importing Data in FDMEE from Oracle Tables

2776205
2776205 Member Posts: 6
edited Nov 26, 2014 12:15AM in Financial Data Management


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

Tagged:

Answers

  • Roshin
    Roshin Member Posts: 87 Red Ribbon

    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
    2776205 Member Posts: 6

    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
    Roshin Member Posts: 87 Red Ribbon

    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
    2776205 Member Posts: 6

    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

This discussion has been closed.