MicroStrategy ONE

Use the SAP BW/4HANA Connector to Import Data

Once you've authenticated and connected to SAP BW/4HANA, you can import data from a SAP BW/4HANA CDS View into MicroStrategy.

The SAP BW/4HANA 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/4HANA 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.

The following BW queries are supported:

  • Queries with variables
  • Queries with Top N and Bottom N

Queries with Replacement Path variables are not supported.