9 Replies Latest reply on Apr 25, 2017 10:58 AM by Nishant Fukate

Using Source Filters in FDMEE.

Nishant Fukate Apr 24, 2017 12:27 PM

Hello Experts,

We are trying to export data from one EPM application to another EPM application.

For this, we have defined Source Filters in a data load rule. The challenge we are facing is that, while importing we have multiple set of combinations so unnecessarily we need to create the multiple data load rules. For example, we have 75 different combinations for which we need to extract data and load it into another application. So do we need to create 75 different data load rules?

Any other way to do this?

Kindly suggest.

Thanks

Nishant

1. Re: Using Source Filters in FDMEE.

Brian Somers Apr 24, 2017 1:20 PM (in response to Nishant Fukate)

Which products are using this with HFM or Planning?
Like Show 0 Likes(0)

Actions
2. Re: Using Source Filters in FDMEE.

Nishant Fukate Apr 24, 2017 1:34 PM (in response to Brian Somers)

Target is planning application..

Regards
Nishant
Like Show 0 Likes(0)

Actions
3. Re: Using Source Filters in FDMEE.

Brian Somers Apr 24, 2017 1:52 PM (in response to Nishant Fukate)

Not sure why you are trying to use FDMEE to do this. Do you have drill through data that you require the other app to access? If not then you could write a business rule to do it in Planning maybe.
Like Show 0 Likes(0)

Actions
4. Re: Using Source Filters in FDMEE.

Francisco Amores Apr 24, 2017 1:54 PM (in response to Nishant Fukate)

Would making a single DLR dynamic help you?

so which is different in the 75 DLRs?
Like Show 0 Likes(0)

Actions
5. Re: Using Source Filters in FDMEE.

Nishant Fukate Apr 25, 2017 4:46 AM (in response to Francisco Amores)

Hi Francisco,

But need to create 75 rules. Is there any copy paste feature available? Because even after defining these 75 rules, I must have to define the data load mappings . That seems hectic while maintaining all those 75 rules and their respective mappings.

Any other way to do this?

Regards
Nishant
Like Show 0 Likes(0)

Actions
6. Re: Using Source Filters in FDMEE.

Francisco Amores Apr 25, 2017 8:43 AM (in response to Nishant Fukate)

You can use Excel interface to create the rules or just directly in the db.

The problem is not creating N DLRs, it's just to find the best design.
Like Show 0 Likes(0)

Actions
7. Re: Using Source Filters in FDMEE.

Satheesh Selvam Apr 25, 2017 10:20 AM (in response to Nishant Fukate)

HI ,

We don't need so much of rule.
Just you build the combination in data load mapping

Regards
Satheesh
Like Show 1 Likes(1)

Actions
8. Re: Using Source Filters in FDMEE.

SH_INT Apr 25, 2017 10:40 AM (in response to Nishant Fukate)

Why not just have one rule which extracts all the data you require and then in the mapping filter out any combinations that you are not interested in loading to your target application using IGNORE
Like Show 1 Likes(1)

Actions
9. Re: Using Source Filters in FDMEE.

Nishant Fukate Apr 25, 2017 10:58 AM (in response to SH_INT)

Sounds good. Will try this. Definitely will minimize the efforts to create multple DLR's.

Thanks All.

Regards

Nishant
Like Show 0 Likes(0)

Actions

Go to original post

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