DSP Expert

1. Community
2. Data Questions & Discussion
3. How do you automate adding a sample line to dspCompose Excel Templates?

We have done this with Excel Integration on the page within dspCompose, Register a procedure to  the data entry button to insert a sample record. This will provide a record in the Excel spreadsheet...

• View comment
• DSP Expert
• June 08, 2018 11:23
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do you extract multiple languages with special characters when a description is classified as "English"?

TEmpson: Hi Alyssa. Do you know what code page the Russian text is encoded with? We had a legacy system where they used western european code page, but then changed the code page on the fly in thei...

• View comment
• DSP Expert
• May 30, 2018 16:12
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do you configure summary emails so they are generated and sent on only the days the corresponding reports run?

CBermingham: Summaries run on their own schedule, which is controlled by a service page. Go to Monitor > Configuration > Schedule Service Page. There you can edit the "Build Summary Workflow Report...

• View comment
• DSP Expert
• May 24, 2018 18:23
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do other projects work around the FireFighter ID issue with loading in SAP using Integrate?

KVandergriend: A Fire Fighter ID is no different than a standard SAP User ID. Simply update the user login information in Data Source registry > User Credentials.

• View comment
• DSP Expert
• October 23, 2017 11:36
• 1 vote

1. Community
2. Data Questions & Discussion
3. Can someone solve this 'flexible' WHERE Clause?

PTowe: If I understand the question correctly, it's just a simple where statement: SELECT B.ProjectID, B.boaUserID, B.[Count] FROM B INNER JOIN A ON B.boaUserID = A.UserID Where viewzeroRecords=1 o...

• View comment
• DSP Expert
• April 11, 2017 07:03
• 1 vote

1. Community
2. Data Questions & Discussion
3. Can someone help me read the status for fields whose MODIF in TMODU is greater than 100?

AGarcia: Here is an example for FIELD status group = '3000'. Yours could be different: SELECT dbo.TMODU.TABNM, dbo.TMODU.FELDN, dbo.T004F.FSTAG, dbo.T004F.BUKRS, dbo.TMODU.MODIF, dbo.T004F.FAUS1, d...

• View comment
• DSP Expert
• February 21, 2017 06:15
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do I determine in-transit inventory?

SUddin: The system runs an availability check in the supplying plant (issuing plant) for stock transport orders. The checking rules that you define in Customizing determine which stocks (for exampl...

• View comment
• DSP Expert
• February 08, 2017 16:00
• 1 vote

1. Community
2. Data Questions & Discussion
3. Can anyone advise how to override the default code page when retrieving data from Oracle?

MUpton:  Navigate to Assemble > Configuration > Connection Types. Find the row “SQL” and the column “Code Page.” Change the value from 2 to 1. Navigate to the Vertical View of the Assemble package...

• View comment
• DSP Expert
• February 03, 2017 15:18
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do I automate the movement of files using a custom application?

MBohne: This can also be accomplished using a DOS Batch file and either running it via Powershell, scheduled task, etc. The NET USE command can be fed login information to map a drive to a remote ...

• View comment
• DSP Expert
• June 18, 2018 08:37
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can users work in the DSP while a CTS archive is being installed?

PTowe: Andy, having used CTS on a live system I can tell you how it appears to behave. As no-one else has replied, maybe this is better than no answer? My comments are based on CTS in ADM 6.5. Firs...

• View comment
• DSP Expert
• June 15, 2018 11:31
• 0 votes