When sending a request to SAP using Qlik SAp Bex Connector, you may encounter the following limitations.
- Memory consumption: common problem with the BEx Connector is that the SAP BW system runs out of memory when executing a load script that extracts a large amount of data.
- Hierarchies: The BEx Connector extracts the data in a flat structure. This means that hierarchical structures in the BEx query will not be represented hierarchically in Qlik.
- Collapsed key figure structures: The BEx Connector cannot access key figures or characteristics that are hidden in collapsed structures. As a workaround to this limitation, edit the BEx query in Query Designer and set all nodes to expanded.
- Customer exit variables: The behavior of customer exit variables in the QlikSAP BEx Connector is different from the behavior of customer exits in SAP reporting products. Some variables function as intended but some do not. The reason is that SAP and Qlik use different methods for extracting the query variables
- Maximum number of dimensions: The maximum number of dimensions that can be extracted in a single load script is 49. T
- Structures: If the BEx query contains a Structure, the Structure must be selected for extraction in the BEx Connector's selection dialog. If there is more than one Structure, only one of the Structures can be selected.
- Hidden key figures: Hidden key figures are not accessible for extraction. Change the display setting for the key figure in Query Designer to access the key figure with the BEx Connector.
Environment:
Resolution:
Check "Limitations and suggested workarounds" for more information.
