DSP Expert

1. Community
2. Data Questions & Discussion
3. Where do we configure source path (DSW_Source_FilePath) for files to be imported in DSP?

KVandergriend: Admin >Data Sources >DSW_Source_FilePath > Vertical view. It is best if the path is on a drive that has sufficient space, and not the C drive.

• View comment
• DSP Expert
• February 13, 2018 06:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. What is the implication of GL account not being extended to a company code (SKA1 not extended to SKB1)?

KDestacamento: GL account not extended to a company code cannot be used for posting a transaction. Transactional data are posted at the company code level, which is why GL accounts should be extend...

• View comment
• DSP Expert
• February 08, 2018 11:30
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

VGazquez: Hi Andy, this is in addition to previous answers. The collation has two purposes: Relates to the bit pattern and code page Specifies how character data is sorted and compared (language, ...

• View comment
• DSP Expert
• February 07, 2018 13:32
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

JDanos: I always like to ensure that any language packs are installed on the servers that are used in the process, including SQL and APP. The other suspects are the actual drivers themselves and lo...

• View comment
• DSP Expert
• February 07, 2018 11:49
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

DanDowney: In Collect, go to the Vertical View of the Target Source. Change the SAP Settings Language to 1 (Chinese). Then use BOA RFC to download the data. It will display correctly in the sdb.

• View comment
• DSP Expert
• February 07, 2018 12:05
• 0 votes

1. Community
2. Data Questions & Discussion
3. Does anyone have reporting content on Missing Customer Hierarchies (Retailer)?

KVandergriend: This is a fairly easy report to write in SQL. Simply create 7 views that include the parent/child relationship, each feeding off the previous view created. The first view needs to ...

• View comment
• DSP Expert
• February 05, 2018 16:53
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there DSP documentation on bulk duplicate detection?

JGrippa: There is an update to DSP Help regarding dDup as of version 6.6.1. Hopefully, this will help a bit.

• View comment
• DSP Expert
• January 24, 2018 08:35
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there DSP documentation on bulk duplicate detection?

CBermingham: I have been able to run with datasets as large as 50k records, but it depends on how many fields you're evaluating. To process a larger population, I had to split the data into sets th...

• View comment
• DSP Expert
• January 23, 2018 10:58
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is it possible to use delimiters other than what's available in DSP (Comma, Tab and Pipe) for flat files import?

JFord: Yes. If you go to Assemble > Configuration > Delimiters, you can add delimiters for the file you are importing.

• View comment
• DSP Expert
• January 22, 2018 17:23
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there DSP documentation on bulk duplicate detection?

CBermingham: Hi Paul, The documentation I have is the help. Go to Platform > Common > Find Duplicates Overview. There should be enough there to get you going. Regards, Chris

• View comment
• DSP Expert
• January 23, 2018 10:08
• 0 votes