Use the SAP BW Connector to Import Data

Once you've authenticated and connected to SAP BW, you can import data into MicroStrategy.

The SAP BW connector does not support live connect mode.

1. Under Data Sources, click on a connection.

   The tables of your selected connection are displayed under Entities.

2. In the Entities search box, type in a table name to search for a specific table.

   

3. Select a table.

   When a table is selected, all of its columns are selected by default.

4. Under Available Columns, use the search box to search for a specific column.

5. Select the checkbox next to the column you want to import. You can select multiple columns.

   

   If you select a different data source or table, the connector throws the following warning and your selections are cleared.

   .

6. You can add filters by clicking Add New Qualification. Learn how to create a filter qualification.

7. To add multiple tables to your data import, click Prepare Data.

   In the Preview dialog, click Add a new table.

   Select a data source and select the SAP BW connector.

   Select a table, columns, and add filters and click Add. You can see the added data in the Preview dialog.

   
   

8. Click Finish.
9. In the Save As dialog, select a location and type in a name.

10. Click Save.

You can use your published cube to create a dashboard, document, or report.