When data is located in cubes, it behaves rather differently compared to data in the relational databases traditionally accessed via Spotfire. See Cubes in Spotfire for more information.
When you are working with data connections to cube data from SAP BW, there are a number of things to think about.
Known Issues
The SAP BW connector does not support SAP BW network hierarchies.
BEx Queries
When you select a SAP BW BEx query, you may have to specify desired values for predefined variables. The specified values will be used to limit the selected data. Once the BEx variables have been specified, you cannot change them.
Note: Even if the BEx query has allowed you to filter out some values for a column or hierarchy, you will see the full range of values from the source if you click Limit Data in the Data Selection in Connection dialog. This means that if you are not careful, you may select values in the Limit Data dialog that are already filtered out by the BEx query, and the resulting selection will be empty. This is also applicable when filtering in Spotfire.
In-memory
When it comes to import of data from a cube, the most important thing to think about is to limit the data to import as much as possible by making sensible selections. This is because import of large amounts of data may not work.
SAP BW has a built-in limit of 1M cells when it comes to import, so try to make sure the number of selected cells is less than this number.
See Importing Data from Cubes for details.
Note: It is not possible to import multiple characteristics that belong to the same dimension.
See also:
Working With Large Data Volumes