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!

Filtering EBS data coming into FDMEE

MAmmarJan 7 2016 — edited Mar 4 2016

I've setup a FDMEE direct integration with EBS. I'm able to load data and all is working fine now. My only question is i need to set some filters.

e.g. When loading data for an entity/ledger there is entries from other entities booked in that entity but i only want to load entity related to that entity only

e..g I'm loading corporate ledger and it has company/region/entity 01, 02, 03, 04 data but i only want to load data for 01.

Is there a way that i can limit the data to 01 only. It'll be based on location/ledger so for every ledger i only want to load data to the related company.

Is it even possible with direct EBS integration or i've to use the open interface adapter.

If someone can help on how to do this what ever the load method is?

Thanks

This post has been answered by _Sanjay_ on Mar 4 2016
Jump to Answer

Comments

MAmmar

Finally i figured that out you can defined that in the data load rule setups.

Thanks

Hem Palariya

Yes, you can add the source filters for each of the dimension, under Data Load Rule options.

Thanks

Hem

SH_INT

Could you close the thread by marking it as answered. Thanks

MAmmar

Hi Hem,

How can you add source filters for each dimension. I can only do that for balancing segment not have option for others?

Thanks

_Sanjay_
Answer

Ignoremaping.jpg

There are multiple option you have to filter the source data load to target. You can you explicit mapping.. or between mapping if you know the range Please see the FDMEE guide for more filer option. You can filter data for each dimension..

Marked as Answer by MAmmar · Sep 27 2020
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 1 2016
Added on Jan 7 2016
5 comments
1,509 views