MicroStrategy ONE
Use the SAP S/4HANA Connector to Import Data
Once you've authenticated and connected to SAP S/4HANA, you can import data from a SAP S/4HANA CDS View into MicroStrategy.
The SAP S/4HANA connector does not support live connect mode.
-
Under Data Sources, click on a connection.
The tables of your selected connection are displayed under Entities.
- Use the Service Catalog to select from a list of services. Learn how to access the Service Catalog.
-
In the Entities search box, type in a table name to search for a specific table.
Entity sets are treated as tables and appear in the Entities pane.
-
Select a table.
When a table is selected, all of its columns are selected by default.
- Under Available Columns, use the search box to search for a specific column.
-
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.
.
- You can add filters by clicking Add New Qualification. Learn how to create a filter qualification.
-
You can aadd multiple tables to your data import.
- Click Prepare Data.
- In the Preview dialog, click Add a new table.
-
Select a data source. For example, the SAP S/4HANA connector.
- Select a table, columns, and add filters and click Add. You can see the added data in the Preview dialog.
- Click Finish.
- In the Save As dialog, select a location and enter a name.
-
Click Save.
You can use your published cube to create a dashboard, document, or report.
Related Articles
KB484335: How to Import Data from a SAP S/4HANA CDS View into MicroStrategy