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.

To import data in pieces, limit the data selection to only include data for a portion of the values in a characteristic or variable. Then, in your analysis, use Insert Rows to add more pieces of the data to the data table containing the imported data.

Procedure

  1. In the Data Selection in Connection dialog, select the data you want to import from the data source.
  2. Identify a characteristic or variable that contains a suitable number of categorical values to limit the data to.
    Example: If you have a data source with sales data for the year 2016, the characteristic 'Calendar day' contains too many values for it to be practical to piece the data by. The characteristic 'Quarter' is more suitable, because it contains only 4 values. By limiting the data by 'Quarter', you can import the data in 4 pieces, each containing only the data for the specified quarter of the year.
  3. Click the characteristic or BEx variable and limit the data to only one value.
    Tip: You can limit the data to more than one value. For example, you could make an import of the data for 'Q1-Q2' first, and then add the rows for 'Q3-Q4' in a second import.
  4. Click OK to close the Data Selection in Connection dialog.
  5. In the Add Data Tables dialog, click Import data. Then click OK.
  6. Select Insert > Rows.
  7. In the Insert Rows dialog, select the data table containing the data from your SAP BW data source.
  8. Click Select > Connection To > SAP BW. Connect to your SAP BW data source again.
  9. In the Data Selection in Connection dialog, select the same data you selected in step 1.
  10. Click the characteristic or BEx variable that you used to limit the data import in step 3, and make a new selection to limit the data.
  11. Click OK and, in the Insert Rows dialog, click Finish.
  12. Repeat steps 6-11 until you have imported all the data you want to analyze.