General Settings are independent of the extraction type.
To open General Settings #
In the main window of the Designer, double-click an extraction.
The window “Define data source for […]” opens.
Within the opened window, click [General Settings].
The window “General Settings” opens.
Misc. tab #
The miscellaneous tab consists of two subsections:
Cache results (1)
Note: Cash results option is only available in pull destinations (e.g., PBI, Qlik etc.).
Pull destinations often pull the data from SAP for several times. To decrease the SAP server load, you can select the Cache results option, this way the pull destination pulls the data from cache and not from the SAP. This increases the performance and limits the impact on the SAP system. If this behavior is not desired (for example, because the data must be always 100% up to date), the cache option must be explicitly turned off.
Preview Mode (2) If preview mode is activated, only a small portion of data is extracted from SAP or, if extraction is not possible, sample data is generated instead.
One or more keywords (Tags) can be set to an extraction. Keywords can be entered directly in the keyword field (3). Within the Designer you can use these keywords to filter extractions.
Tip: to display filter options, navigate to [Extractions] > [Filter] or press [CTRL]+[F].
Primary Key tab #
Table extractions inherit the primary keys from SAP. Other objects such as SAP Query, BW Cube etc. require manual setting of the primary keys.
Depicted example demonstrates the SAP object MAKT with it’s primary key inherited from SAP in the general settings of the Designer. In this example the primary key consists of MANDT, MATNR, SPRAS. The demonstrated primary key is also taken over in the destination.
Note: A defined primary key field in a table is a prerequisite for merging data.
Security Tab #
The security tab is described in the section access management.