With this extract, the transactional data stored in a SAP BW InfoCube can be extracted and aggregated on the specified detail level.
Settings
| Connection | Name of the SAP Connection. |
| Query cube | Name of the Query cube. |
| Filter | Filtering criteria for each field of the Query cube (optional). See Filtering with SAP Connector. |
| Characteristics | The characteristics that are extracted from the InfoCube. This defines the detail level on which the result is aggregated.
Note: The response time of the extract gets longer with higher detail level, such as increasing number of characteristics. If no characteristic is specified, one row is returned with the globally aggregated key figure values. |
| Key Figures | The key figures of the InfoCube that are extracted. Each key figure is returned in a separate column in the result. The aggregation level can be defined individually on each key figure. Possible values are sum (default), max, and min. |
| Date | Optional date for the cube extraction. The date has to be specified in the format: yyyyMMdd |
| Alpha conversion | If this option is set, the conversion will be applied for all characteristics with Alpha Conversion active. That means leading “0”s are removed if the name consists only of digits. |
| Bulk size | Size of blocks for extraction. |
| Use caching | Memory, disk, or none (default). See Caching in Extracts. |
In SAP BW/4HANA, InfoCubes have been replaced with a new unified persistent object type, the Advanced Data Store Object (aDSO). Therefore, this extract type can no longer be used for BW/4HANA. In order to extract from aDSO, the extract types SAPTable (with a connection of type SAP), or Relational/RelationalTable (with a connection of type SAPHana) may be used.
As a table, the automatically generated view with the name "/BIC/A<aDSOname>7" can be used, e.g., for aDSO "MYADSO" the view is "/BIC/AMYADSO7". Note that the distinction between characteristics, key figures, and the aggregation level of SAPBICube are not available in the other extracts.
Note: It is not possible to extract data from MultiProviders in SAP BW.
Updated February 7, 2024