Resources

• Products & Solutions
• System Requirements
• Samples
• Install Center
• Third-Party Software Reference
• Documentation
  • What's New in SAS
  • Product Index A-Z
  • SAS Viya
  • SAS 9.4
  • SAS 9.3 and Earlier
• Papers
• Focus Areas

What's New Table of Contents

What's New in SAS Data Surveyor 4.1 for SAP

Overview

SAS Data Surveyor 4.1 for SAP makes it much easier to perform the following tasks:

• search pre-extracted SAP BW metadata
• subset the extraction of SAP BW ODS objects and InfoCubes through WHERE statements
• apply a WHERE statement to selected components of the InfoCube
• extract SAP ODS objects as SAS Views
• load external file data to SAP BW systems

For information about changes to the SAS/ACCESS Interface to R/3, see the What's New section of the SAS/ACCESS Interface to R/3 User's Guide.

Note: SAS Data Surveyor for SAP is now called SAS Data Surveyor 4.1 for SAP. It adds new features to the version of SAS Data Surveyor for SAP that originally shipped with SAS 9.1.

---

Details

Search Capabilities for SAP BW Metadata

A metadata search window in the SAP BW Source Designer wizard enables you to quickly find SAP BW metadata that contains a specified search string. You can revise and refine your metadata search criteria by searching within the returned search results. Select an InfoCube or an ODS object to view the associated metadata. You can also view the actual data for an ODS object. From the search window, you can select the ODS Object or InfoCube that you want to identify as a data source in your SAS ETL Studio data warehouse.

Subsetting Capabilities

• In a create star schema view transformation, you can add a WHERE statement to apply subset criteria within a Load InfoCube job. The subset information can include a WHERE statement.
• In a Load ODS object job transformation, you can add a WHERE statement to apply subset criteria within a Load ODS object job. The subset information can include a WHERE statement.

Applying WHERE Statements to Selected Components of a Load InfoCube Job

When you propagate a WHERE statement to the components of the InfoCube using the Propagate Tab in the create star schema view transformation, the extraction steps of the propagation targets and of the Create Star Schema view transformation are optimized.

Extracting SAP ODS Objects As SAS Views

Extraction options in the Extraction Options window (for ODS objects) of the SAP BW Source Designer wizard enable you to specify whether you want to create a SAS View from the ODS object that you specified.

Loading External File Data to SAP BW

A Target Designer wizard enables you to load external file data to an SAP BW warehouse by creating a flat file based on InfoPackage metadata stored in SAP BW. The wizard registers a process to create a flat file in a format that can be loaded by an existing InfoPackage into SAP BW. The wizard generates a process flow diagram into which you can drop a SAS data set as input. By mapping the data to the flat file, you can run a job in SAS ETL Studio that ultimately returns the file with the new data to SAP BW. The exact process that is used to transfer the data to SAP BW depends on the InfoPackage settings and the location of the external data files.