Data Management: Filtering out data from ERP for a dimension that does not exist in PBCS

t.walker

Hi,

Account combinations exist that I would like to see excluded from data integration.  The source is an Oracle Financial system.  Both systems (PBCS & ERP) have the ACCOUNT dimension.  ERP has a custom dimension that does not exist in PBCS.  The user wants to see

• Any Account data for which the custom dimension does not have a value/uses the default value
• Account data for a specific member of the custom dimension

Since this dimension does not exist in PBCS, I can not ignore the members I do not want to see.  How can I filter out members of a dimension that do not exist in my target system?

JohnGoodwin

In Data Management, for the target PBCS application you could add a lookup dimension. lookup dimensions are not loaded to the target.

Then you could map the lookup dimension to the custom financials dimension in the import format and perform data load mappings against it.

Cheers

John

JohnGoodwin

In Data Management, for the target PBCS application you could add a lookup dimension. lookup dimensions are not loaded to the target.

Then you could map the lookup dimension to the custom financials dimension in the import format and perform data load mappings against it.

Cheers

John

t.walker

Hi JohnGoodwin,

Thank you for the suggestion.  I am trying to test this out in a lower environment.  How do I know which data table column name is correct?  I looked around google, it is the TDATASEG staging table.  I looked up the TDATASEG Table Reference, but I didn't see anything that could help me identify the data table column name that represents the custom dimension.

JohnGoodwin

You just select a UD column that is not being currently used in the target app.

t.walker

Thank you John.  I created the lookup dimension and see that dimension as an option on the member mapping page