Install & Setup SAP 7.60 With Analysis for Office 64bit


Install SAP 7.60 With Analysis for Office 64bit

Before you begin

  • The installation requires Administrative privileges to install.
  • Download the DukeSAPgui760 and AuthenticLogon installers from the OIT Software Site.
  • If a previous version of SAP is installed - Completely uninstall the current version of SAPgui and Authentic Logon and reboot.

 

Prerequisites:

 

Please refer to the following article if you need to install SAP Basic GUI only.https://oit.duke.edu/help/articles/kb0032065


  1. Install Office 64-bit 2016, 2019, or Office 365.
    • Only 64-bit versions are compatible.
  2. Install Microsoft Visual Studio 2010 Tools for Office Runtime
  3. Install Duke SAP GUI (Duke_SAPgui_760_A4O.exe)
  4. install Authentic Logon (Authentic Logon for SAP 4.1.0 (X64).msi)

Screenshots of the process are below:


Install Duke SAPgui 760

  1.  Run the Duke_SAPgui_A4O.exe as Administrator.
              


  2. If all prerequisites are installed, you will see the window prompt below:
             


  3. Click Next to Continue.

  4. Select "Duke SAPgui 760" > Click Next
              


  5. The Installation will run and you will be prompted to Close and reboot once completed. 

 

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.

           

 

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 select 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)

Article number: KB0032058

Valid to: April 15, 2025