Extract SAP BW Metadata Using the Extract from BW Wizard

Use this wizard in SAS Management Console to extract metadata from selected InfoCube tables and ODS objects, or from all InfoCube tables and ODS objects in your SAP BW system. Extracted metadata is written to SAS data sets. After the metadata is extracted, you can use the SAP BW Register Tables wizard in SAS Data Integration Studio to perform these tasks.
  • Browse the metadata.
  • Select data sources for SAS Data Integration Studio.
  • Build jobs that load the SAP BW data from source tables into a SAS library.
Follow these steps to use this wizard.
  1. Select Startthen selectProgramsthen selectSASthen selectSAS Management Console to start SAS Management Console.
  2. Select Toolsthen selectExtract from BW to start the Extract from BW wizard. The SAP Server page is displayed.
  3. From the Configured SAP Server list box, select the configured SAP server so that you can to connect to your SAP BW system and click Next.
  4. If you are prompted, enter the user name and password to connect to the SAS application server that lets you run a SAS session and click OK.
  5. From the SAP Metadata Location list box in the SAS Libraries group box, select the library where you want to save extracted SAP BW metadata.
    Verify that the appropriate directory is associated with the library and click Next. The Extract SAP BW Metadata to SAS Datasets page is displayed.
  6. Set the options for extracting the BW metadata.
    • Verify the path that is displayed in the Selected Path field. This path is associated with the SAP BW metadata library for the directory. It identifies the location where extracted metadata is saved.
    • Select the Merge into Existing Metadata check box if you want to merge the metadata into existing metadata. For example, you might do this if you read in SAP BW metadata only for a specific InfoCube or ODS object. However, you would not want to merge metadata when you perform a full metadata extract.
    • Extract all active BW metadata, or specify the name of the InfoCube or ODS object for which you want to extract metadata.
  7. Click Next to display the Save SAS Source Code page.
  8. To save the SAS code that extracts the metadata from your SAP BW system, use the text field or browse button to specify the name of the SAS program. Click Next to display the Wizard Finish page.
  9. Review the extraction parameters that you have defined. When you are finished, click Finish to begin extracting metadata.

See Also

SAP Server Page
Extract SAP BW Metadata to SAS Datasets Page
Save SAS Source Code Page
Wizard Finish Page
Copyright © SAS Institute Inc. All rights reserved.