Click Extraction Settings in the main window of the component. The window “Cube Settings” opens.
Extraction Settings #
Package Size
Defines how many data records are fetched from SAP in a data package.
Values between 10,000 and 100,000 are practical for large data volumes.
If the value is set to 0, the complete result set is fetched at one time.
This option is not supported when using BICS mode.
Recommendation: Always define a package size.
Row Limit
Defines the maximum number of rows in the result set.
If the value is set to 0, the complete result set is fetched.
This option is not supported when using BICS mode.
You can use Row Limit to perform tests with a small amount of data by entering a row limit of e.g., 1000 (not 0).
Member Display
This setting is only available for the BICS extractor.
Key: Extracts the key of the dimension member.
Text (default): Extracts the text of the dimension member.
Text and Key: Adds an additional column for every dimension with the suffix .KEY. The original column contains the text of the dimension member, the column with the .KEY suffix contains the key of the dimension member.
Formatted Values
If this option is active, the values of key figures are formatted as defined in the Query Designer e.g., scaling factor and number of decimal places.
Only Structure
Activate Only Structure if your BW Cube extraction was created in an old version of the BW Cube component.
The method for the metadata retrieval has changed, which affects especially BEx Queries with two structures.
This option can only be activated and deactivated in the Look Up window of the component.
Automatic Slicing Dimension #
This option sets a dimension for an automatic slicing. Slicing is the act of picking a subset of a cube by choosing a single value for one of its dimensions. Automatic slicing means that a loop is executed for each single value of the chosen slicing dimension (characteristic) to extract the result from BW.
Automatic Slicing Dimension allows the extraction of a large amount of data (millions of records) from BW.
Dimension on Columns #
The following extraction setting is only available for MDX extractions. It appears in the extraction settings window after retrieving the metadata of an MDX extraction.
Dimension on Columns allows selecting another dimension/structure than the measure (key figures) dimension on the column axis. This swaps the measures and the selected dimension: the measures are placed on rows, the selected dimension is placed on columns.
Note that:
- your BEx Query must contain a dimension structure.
- dimension filters on columns are not applied.
- the selected properties for the new column dimension are ignored.
- unit columns are only supported when key figures is selected for the columns.
- up to 1000 members will be loaded when confirming the extraction settings window. These members will be the column names.
Recommendation: We recommend only using structures on columns.
Example:
- Output for Dimension on Columns = Key Figures
- Output for Dimension on Columns = Cal. Year/Quarter [0CALQUARTER]
Experimental #
The following settings are only available for BICS extractions. They appear in the extraction settings window after retrieving the metadata of a BICS extraction.
Create BICS Compatibility Report
When encountering an error using BICS, click [Create BICS Compatibility Report] to run a number of tests to help us analyze why and where the error occured.
The test results are automatically stored in a .zip file.
If you have multiple different SAP systems, perform this test on each of them.
Send the resulting .zip files to the Theobald Support team.