Forum Stats

  • 3,838,814 Users
  • 2,262,400 Discussions
  • 7,900,761 Comments

Discussions

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

t.walker
t.walker Member Posts: 9 Red Ribbon
edited Sep 9, 2019 10:17AM in Planning and Budgeting

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?

Tagged:
Robert Angel

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Sep 6, 2019 9:39AM Answer ✓

    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

Answers