Use the
New SAP BW wizard in SAS Data Integration Studio to read existing
InfoPackage and InfoSource data in SAP Business Information Warehouse
(SAP BW). You can use the wizard to create a flat file in a format
that an existing InfoPackage can load into SAP BW. The InfoPackage
and InfoSource data that is read from SAP BW contains information
about the expected file structure and its location. The wizard loads
only transactional and characteristic data; characteristic data must
be of the master and text types.
You can
use the data that you read in using this wizard to generate a process
flow diagram and connect a registered table to the input port of the
SAP BW File Writer transformation template. You can then map the data
to the correct flat-file format based on the rules and metadata contained
in the InfoPackage and InfoSource.
Once the
data is completely mapped, you can run the job in SAS Data Integration
Studio and process the data as needed. 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. The InfoPackage and InfoSource
cannot be modified from SAS.
The following
windows are available in the New SAP BW wizard: