Data Management Integration to ERP: Filtering/Controlling what data comes into PBCS from ERP

t.walker

Hi,

I'm working with a PBCS integration.  Source system is Oracle Financials.  After the first run, client realized they did not want to pull in all members of a dimension.  For example, both system may have 100 members in Account dimension.  But we only want to pull data for 98 of those accounts into PBCS.  All the accounts are mapped, if we removed mapping we get lines in the error log about the missing account.

How can I filter the data or control what members come into PBCS?  Is there a best practice for type of issue?

JohnGoodwin

You can control it by updating the definition of the source filters in the load rule. You can also map members to IGNORE if you don't want to load them to the target.

Cheers

John

JohnGoodwin

You can control it by updating the definition of the source filters in the load rule. You can also map members to IGNORE if you don't want to load them to the target.

Cheers

John

Robert Angel

Like this?

https://docs.oracle.com/cd/E57185_01/AGFDE/ignoring_member_mappings.htm

Robert Angel

Sorry, your reply landed before mine.

t.walker

Thank you so much for the guidance.  I am testing this out in a lower environment and update with my results.

t.walker

Thanks for the link