DVW ANALYTICS
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SAP CLOUD
      • ALTERYX UPDATE TOOL FOR SAP BW
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
      • TABLEAU CONNECTOR FOR SAP BUSINESSOBJECTS
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING >
      • ACS TRAINING
  • DEMOS
  • FREE TRIAL
  • RESOURCES
    • BLOG
    • EVENTS >
      • ALTERYX INSPIRE 2018
      • ALTERYX INSPIRE EUROPE 2018
      • WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS >
      • ACS FOR ALTERYX DESIGNER
      • ACS FOR ALTERYX SERVER
      • ACS BOP FOR ALTERYX DESIGNER
      • ACS BOP FOR ALTERYX SERVER
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
      • TABLEAU CONNECTOR FOR SAP
    • TUTORIALS
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

ACS TRAINING


Agenda

1. Overview of the DVW suite of connectors for SAP

2. SAP Landscape Overview

3. The SAP Logon Tool

  • Finding the right information from SAP Logon pad and from Systems menu 
  • Changing an existing system configuration - manually changing the system details in Systems.csv (ACS's local list of systems) 
  • Setting up SSO based system       
  • Saving password to central ACS Config file 
  • Handling impact of password change in the SAP system  
  • Using local Proxy settings  - to establish connectivity to DVW's license server 
  • Passing correct system details to the downstream tools 
  • Walk through of common errors: ping failure, username/password being locked, ACS license related errors, ACS license being locked) 

4. The SAP BW Query Tool

  • Searching BW Queries 
  • Understanding differences between variables and filters 
  • Using help popups, including additional help value searches 
  • Using Additional Settings screen 
  • Changing output structure  
  • Using field description instead of technical names in the output 
  • Taking advantage of the Messages tab to understand workflow processing 
  • Difference between Splits and Filters 
  • Refreshing metadata of an existing workflow 
  • Understanding SAP system safety belts and how to avoid them 
  • Using dynamic input capability 
    • Passing data from an excel file 
    • Passing data from an ACS tool 
  • Delta load extraction overview  
  • Workflow performance and optimisation - setting correct expectations 
  • Familiarisation of the RSA1 transaction (seeing the underlying data structure of an InfoProvider)  
  • Familiarisation of BW Query Designer - changing existing query structure and saving it as a different query 

5. SAP BW InfoProvider Tool

  • Searching BW InfoProviders  
  • Overview of kinds of InfoProviders ACS supports 
  • Using Additional Settings screen 
  • Maximum number of field selection - and understanding SAP limitations (51 characteristic limits) 
  • Changing output structure  
  • Using help popups, including additional help value searches 
  • Using field description instead of technical names in the output 
  • Difference between Splits and Filters 
  • Refreshing metadata of an existing workflow 
  • Understanding SAP system safety belts and how to avoid them 
  • Using dynamic input capability 
    • Passing data from an excel file 
    • Passing data from an ACS tool 
  • Delta load extraction overview  
  • Workflow performance and optimisation - setting expectations 
  • Familiarisation of the RSA1 transaction (seeing the underlying data structure of an InfoProvider)

6. SAP BW Text Tool

  • Understanding the relationship between BW Query and BW Text tool 
  • Searching BW Queries 
  • Selecting correct BW InfoObject and masterdata fields for output 
  • Understanding masterdata source levels and how to use them 
  • Alternate to BW Text tool - using the SAP Table tool to extract master data 

7. SAP BW Hierarchy Tool

  • Understanding the relationship between BW Query/InfoProvider and BW Hierarchy tool 
  • Searching BW Queries 
  • Selecting correct BW InfoObject and BW Hierarchy  
  • Extracting hierarchy node texts  
  • Familiarisation of BW Hierarhcy in the RSA1 transaction  
  • Creating hierarchy joins with BW Query/InfoProvider tools 

8. SAP Table Tool

  • Searching SAP tables and views 
  • Searching related tables for creating joins 
  • How to find correct tables and views for target system from google searches 
  • Selecting fields for output and understanding 512-character limit - overview of the custom API  
  • How to use Packet Size 
  • Difference between Splits and Filters 
  • Using Packet Size and Splits together  
  • Refreshing metadata of an existing workflow 
  • Best practices when choosing between Splits/Filters and Packet Size 
  • Taking advantage of the Messages tab to understand workflow processing 
  • Creating table joins using dynamic input 
  • Understanding Primary and Secondary indexes on SAP tables 
  • Transforming ABAP Reports into Alteryx workflows using SAP Table tool

9. Using Macros with the ACS

  • How to design efficient workflows using macros and the ACS tools 
  • How to pass large number of dynamic filters to an ACS tool        

10. Requesting DVW Support

  • Using log verbosity to capture extra details about the error 
  • Finding and sending an ACS log file   

11. SAP Roles and Authorisations

  • Required roles and authorisations for using the ACS tools  

12. Working with Alteryx Server

  • Setting up Alteryx Server for ACS tools ​

To discuss your training requirements with us, please complete the short form below.
Fill out my online form.

GET A FREE TRIAL TODAY

PRODUCTS

ALTERYX CONNECTOR FOR SAP
​
ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SAP CLOUD
​ALTERYX UPDATE TOOL FOR SAP BW
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​

TABLEAU CONNECTOR FOR SAP​
​TABLEAU CONNECTOR FOR SAP BUSINESSOBJECTS

SERVICES

PROFESSIONAL SERVICES
TRAINING

FREE TRIAL

DEMOS

BLOG

ABOUT US

CONTACT US

DVW Analytics by De Villiers Walton is dedicated to bringing the power of SAP to users of Alteryx, Tableau & other global leaders in BI and analytics.


© COPYRIGHT 2003 - 2019 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SAP CLOUD
      • ALTERYX UPDATE TOOL FOR SAP BW
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
      • TABLEAU CONNECTOR FOR SAP BUSINESSOBJECTS
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING >
      • ACS TRAINING
  • DEMOS
  • FREE TRIAL
  • RESOURCES
    • BLOG
    • EVENTS >
      • ALTERYX INSPIRE 2018
      • ALTERYX INSPIRE EUROPE 2018
      • WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS >
      • ACS FOR ALTERYX DESIGNER
      • ACS FOR ALTERYX SERVER
      • ACS BOP FOR ALTERYX DESIGNER
      • ACS BOP FOR ALTERYX SERVER
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
      • TABLEAU CONNECTOR FOR SAP
    • TUTORIALS
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS