Best Practices for the SAP BW Connector
When you work with SAP BW data in Spotfire, there are certain restrictions in SAP BW that you should keep in mind. The following sections contain information describing common SAP BW limitations and suggestions for how you can work around them.
- Default Cell Limit: Maximum 1 000 000 Cells
By default, there is a limit to how many cells of data can be returned in a single query from Spotfire to SAP BW. The MDX interface of SAP BW can generate a result set containing a maximum of 1M cells. - Importing SAP BW Data in Pieces
If you want to analyze a very large amount of SAP BW data, which exceeds the limit of 1M cells, you can import it piece by piece into Spotfire. - Limitation: Multiple Hierarchies or Columns from the Same Characteristic
SAP BW does not support mixing hierarchies or columns that are based on the same characteristic. If more than one hierarchy or column is based on the same characteristic in your data source, make sure you only include one of those columns or hierarchies. - Other Tips for Using the SAP BW Connector
The following tips are useful suggestions to keep in mind when you use the Spotfire connector for SAP BW.
- Default Cell Limit: Maximum 1 000 000 Cells
By default, there is a limit to how many cells of data can be returned in a single query from Spotfire to SAP BW. The MDX interface of SAP BW can generate a result set containing a maximum of 1M cells. - Importing SAP BW Data in Pieces
If you want to analyze a very large amount of SAP BW data, which exceeds the limit of 1M cells, you can import it piece by piece into Spotfire. - Limitation: Multiple Hierarchies or Columns from the Same Characteristic
SAP BW does not support mixing hierarchies or columns that are based on the same characteristic. If more than one hierarchy or column is based on the same characteristic in your data source, make sure you only include one of those columns or hierarchies. - Other Tips for Using the SAP BW Connector
The following tips are useful suggestions to keep in mind when you use the Spotfire connector for SAP BW.
Parent topic: SAP BW