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.