DSP Expert

1. Community
2. Data Questions & Discussion
3. Has anyone created Integrate sessions that can be scheduled to run on a nightly basis?

EWeldon: Hey Dan, This can be scheduled via Automate. You may have to make the WebApp Event Public, then it will show up in the Interfaces page. Once it's there, you can schedule it.

• View comment
• DSP Expert
• May 03, 2017 12:48
• 0 votes

1. Community
2. Data Questions & Discussion
3. What ports needs to be open for fire wall settings to allow SSMS to open a connection to SQL Server without using remote desktop on the network?

SShah: SQL Server default port: 1433. You can very the port using following path: 1. Login to (RDP) to Database Server 2. Open SQL Server Configuration Manager 3. Check Property of the TCP/IP 4. Te...

• View comment
• DSP Expert
• April 11, 2017 11:31
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone encountered any "gochas" in DSP with a BODS upgrade?

JCohen: There "shouldn't" be an issues from the DSP side. Make sure they upgrade to the version that is in the support band for DSP 6.5.6 (IPS 4.1 SP8, DS 4.2 SP7, and IS 4.2 SP7). The certificatio...

• View comment
• DSP Expert
• March 23, 2017 10:12
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there a way to set up integrated authentication where the browser asks for the network ID and password every time a user signs in to the DSP?

KVandergriend: No. This would require that DSP have read access to the corporate logins/passwords, which they should never allow. And this is not needed anyway, since the user has already entered t...

• View comment
• DSP Expert
• March 31, 2017 11:16
• 0 votes

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

AOttone: The SQL sentence that Angel sent you works fine because SAP stores the position of field in FAUS2 in TMODU.MODIF plus 90. The TMODU.MODIF value ranges are 001-050 for T004F.FAUS1 and 091-1...

• View comment
• DSP Expert
• February 21, 2017 08:27
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do I set a field to be read-only in an Excel template in Construct?

VGazquez: Hi Sergio/Didac, Unfortunately, as far as I know, this action is not possible (I hope the Development team adds it in the next release). According to the documentation, only fields with C...

• View comment
• DSP Expert
• February 09, 2017 07:59
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone developed a CLR function to read the Microsoft Windows Search catalog?

PCardoso: Kurt, I have not had the need to do this. I did some digging and it appears this is an area that has lacked attention from Microsoft and the CLR wrapper seems to be the only viable approa...

• View comment
• DSP Expert
• January 08, 2017 14:52
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can the supplied SAP ECC system type be copied to another system type?

CBermingham: You can copy the system type directly using INSERT INTO...SELECT statements. Override the key values and the system type name with appropriate values. You can find all of the tables yo...

• View comment
• DSP Expert
• December 22, 2016 10:31
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can the supplied SAP ECC system type be copied to another system type?

MGlaeser: There are more procedures, functions, and routines that run in the DSP than in the old platforms and they won't run if you copy system types through the back end. One suggestion is to fin...

• View comment
• DSP Expert
• December 23, 2016 11:40
• 0 votes

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

JValerio: It depends on what the kind of stock transfer you have if you do a 2-step movement in inventory management by only using movement types 313 and 314. Using these movement types, the transf...

• View comment
• DSP Expert
• December 15, 2016 10:01
• 0 votes