Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Data Management: Filtering out data from ERP for a dimension that does not exist in PBCS

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?
Best Answer
-
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
Answers
-
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
-
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.
-
You just select a UD column that is not being currently used in the target app.
-
Thank you John. I created the lookup dimension and see that dimension as an option on the member mapping page