Installation & Setup SAP (With and Without Analysis for Office)

Please Note: Using RemoteApps is the preferred method of accessing SAP.
Local computer installation of the applications is no longer recommended. (Please see: https://duke.service-now.com/kb_view.do?sysparm_article=KB0026883)

---

• Prerequisites
• Order of Operations
• Installation of the Program Applications
  • SAPgui
  • Authentic Login
  • Analysis for Office add-in for SAPgui (x64)
• For Analysis for Office:
  • Setup Excel Add-in
  • Testing
• Assistance
• Troubleshooting

 

---

 

Prerequisites

For SAP and SAP with Analysis:

• The installation of the applications requires full administrative rights to be able to run.
• If a previous version of SAP is installed - Completely uninstall the current version of SAPgui and Authentic Logon and reboot.
• Download the installers from the OIT Site License Web site. 
• Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security Update, Both 32bit and 64bit

For Analysis for Office Only:

• 64-bit version of Microsoft Office 2016 and greater, or Office 365
• Microsoft Visual Studio 2010 Tools for Office Runtime 

To use or test SAP, it is necessary to be connected to Duke’s network by one of the methods listed below. 

On Duke University or Duke Medical campus

• A wired connection
• A Wi-Fi connection to Dukeblue, or DukeOpen

Working Remotely

• A VPN connection using Cisco AnyConnect (portal.duke.edu, vpn.duke.edu)

Order of Operations (IMPORTANT!)

For Analysis for Office:

1. Install Office 64-bit 2016, 2019, or Office 365.
2. Only 64-bit versions are compatible.
3. Install Microsoft Visual Studio 2010 Tools for Office Runtime

For SAP and SAP with Analysis:

1. (4.) Install Microsoft Visual C++ 2010 Service Pack 1 Redistributable Package MFC Security Update, both 32bit and 64bit
2. (5.) Install Duke SAP GUI (DukeSAPgui804.exe)
3. (6.) Install Authentic Logon (Authentic Logon for SAP 4.1.0 (X64).msi)

 

Installation of the Program Applications

---

Install Duke SAPgui 

1.  Run the DukeSAPgui804.exe as Administrator. 
            
   
   
   
   
2. If all prerequisites are installed, you will see the window prompt below:
            
   
   
   
   
3. Click Next to Continue.
   
   
4. Select "DukeSAPgui804" > Click Next
            
   
   
   
   
5. The Installation will run and you will be prompted to Close and reboot once completed. IMPORTANT! Be sure to reboot!

Install Authentic Logon for SAP 4.1.0 (x64)

1. Run the Authentic Logon for SAP 4.1.0 (X64).msi as Administrator.
             
             
   
   
   
   
2. The installer will run, and you will notice a couple of flashing windows open and close automatically. This is normal.
   
             
   
   
   
   
3. Once the installation is complete, the new "MIT Kerberos Ticket Manager" icon will be added to the desktop as a shortcut.

           

Install Analysis for Office add-in for SAPgui804 (x64)

1. Run the AOFFICE28SP20_0-70004973.EXE as Administrator.
   
   
   
   
   
2. Select Analysis for Microsoft Office (64-bit) on the SAP Front-end Installer window and click Next
   
   
   
   
   
3. Click Next and leave the default target directory on the next screen. 
   
   
4. IMPORTANT! Reboot the computer and have the employee sign into the system. 

 

Configuration of Analysis for Microsoft Excel

1. Have the customer sign into the system, if necessary.
   
   
   
2. Double-click the 
   
    Authentic Login icon to enter your NetID and password and obtain a security ticket, just as you would to log into SAP.
   
   
   
3. Launch 
   
    Analysis for Microsoft Excel, simply use the Windows Start menu to find and select Analysis for Microsoft Excel as outlined below:
   
   
   
   • Path: All Programs > SAP Business Intelligence > Analysis for Microsoft Excel
     
               
     
     
     
     
     
4. From the Excel menu bar options, choose File > Analysis > Customize Analysis > Options.
   
             
   
   
   
              
   
   
             
5. If you receive a prompt regarding free text fields, click in the box for Do not show again if Desired and then click OK. 
   
   
              
   
   
   
   
   
6. In the Options dialog box, click the Platform tab.
   
              
   
   
   
   
   
7. Under the Platform tab, use the drop-down for the fields if needed to ensure that Business Warehouse is displayed in both the Preferred Platform and Comments Storage fields. Click OK.
   
             
   
   
   
   
   
8. Now open Technical Configuration by selecting Customize Analysis > Options > Technical Configuration.
   
        
   
   
   
   
   
9. Use the Find selection to search for 'Landscape'.
   
   
10. Ensure that the option, "UseSapUILandscapeComApi" option is unchecked and click OK.
    
           
    

 

Testing

1. Use the Back button (circle with arrow) in upper left corner to return to Excel spreadsheet.
   
                  
   
   
   
   
2. Select the Analysis tab in the ribbon.
   
             
   
   
   
   
   
3. Click "Insert Data Source, then click Select Data Source for Analysis...
   
              
   
   
   
   
4. If Prompted for Client and Language, after selecting data source, as in the following screen, enter the following
   
   1. Client: 100
   2. Language: EN
   3. Click OK
      
      
      
      
      
      
5. Ensure that Data sources are available under the Connections folder by expanding the folder.
   
        
   
   
        

Assistance

Be sure to read and follow the user guide:  Analysis for Office 64bit User Guide 

If you have further questions on Analysis for Office please contact your management center office or submit a Support@Duke ticket to the group Financial Services-Admin Sys Mgmt.

For additional support, please contact the OIT Service Desk at 919-684-2200, or send an email to help@duke.edu

 

---

 

Troubleshooting

Symptom:

System connections not recognized in Analysis for Office when attempting to insert a data source into an Excel worksheet.

 

Solution:

Open the menu path File -> Analysis -> Customize Analysis -> Technical Configuration. Use the Find selection to search for Landscape. Ensure that the option UseSapUILandscapeComApi option is unchecked and then select OK.  Close Excel and start again.

 

 

Symptom:

The following screen appears after select data source:

Solution: 

Enter Client: 100, Language EN

 

Symptom:

SAP Front End installer displays the following error message, but Office seems to be installed.

 

Solution

Verify the version of Office is 64bit:

1. Open a Word document or create a new blank document
2. Navigate to File > Account > Click About Word. 

 

---

 

Symptom:

The following username and password prompt appears when attempting to use the Analysis tab:

Solution

Close Excel.

Ensure connection to the Duke network - either via wired, wireless, or VPN connection.

Get ticket from MIT Kerberos Ticket Manager for @ACPUB.DUKE.EDU (see webpage for instructions on getting a ticket)