The BWCube component enables you extracting a BEx query or an InfoCube via the MDX interface.
The MDX interface of the SAP BW system has a known restriction if the result contains too many cells (more than 1 million cells).
SAP officially states: “In general the MDX interface is not suitable for accessing mass data”.

To solve this problem the BWCube component provides the following solutions:

1. Case
Starting with SAP Netweaver BI
– version 7.01 SP2 or higher (7.0 with ehp1 and support package 2 or later) or
– version 7.11 with support package 00 or higher (SAPKW71100)
SAP has released new BAPIs that remove this limitation.
To use the new BAPIs please select Settings -> “Use new OLAP BAPIs” in your BWCube component.
If you don’t have this setting, be sure to download the last version from our Website.

2. Case
If your SAP Netweaver BI version is older than above mentioned:

First Option: Break the dataset in smaller datasets with less than 1 million cells by using variables (e.g. Year, Month, Product and so on).
Loop over the attributes to extract all the data.

Second Option: Break the dataset in smaller datasets with less than 1 million cells by adding only dimensions (InfoObjects)
and key figures that you need.

In both cases we recommend to set the setting Package Size
in the BWCube component to a value (e.g. 20000).

If you don’t have this setting, be sure to download the latest version from our Website.
For more Information refer to SAP Note 1232751.

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.