Use the
Select Extraction Options page (for InfoCubes) to specify the following:
-
how data is extracted from a specified
InfoCube
-
where to save the SAS data sets
that contain the extracted SAP BW data
-
a metadata folder location for
storing the table and job metadata created by this extraction operation
The Select
Extraction Options page (for InfoCubes) contains the following items:
enables you to specify
whether you want to use change data capture (CDC) processing in the
extraction process. CDC processing enables you to extract only the
data that has changed since your last extraction. Select this check
box if you want to use CDC processing.
enables you to select
the date that is associated with the master tables and text tables
that you want to use from the InfoCube. The default date is today's
date. You can either enter a different date using the MMMDDYYYY format
or you can click the button to the right of the field to select a
date from a calendar. In SAP BW, master tables and text tables might
be time-dependent. The date that you specify is the date that is associated
with the master table and text tables that are extracted from the
SAP BW System.
identifies the name
and location of the BW star library, which
is the library in which you want to store the SAS data sets that contain
the SAP BW data. The SAP BW data is extracted from the specified InfoCube.
When extracting InfoCube data, the data is converted from a snowflake
schema to a star schema. When the conversion process is complete,
a fact table, dimension tables, and a star schema view are saved in
the data sets in this library.
identifies the name
of the library in which the data that is extracted from the specified
InfoCube data is saved as SAS data sets.
identifies the complete
path of the directory that is associated with the
BW star
library.
Use Browse to specify a metadata folder location to store table and job metadata
created by this extraction operation.