Importing SAP ERP Data to a New or Existing Model
To import data from SAP ERP into a new or existing model, you specify the source data and then specify how you want to import the data into model dimensions.
Prerequisites
- The SAPCP cloud connector and SAP Analytics Cloud agent are installed and configured.
- You use a supported version of SAP ERP Central Component. For information on supported versions, see System Requirements and Technical Prerequisites.
Procedure
-
Select the appropriate option:
- If you're creating a new model:
- Select .
- Select NoteFrom the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
.
- If you're importing into an existing model:
- Select .
- Open the model you want to update.
- Switch to the Data Management screen.
- Select .
- Select SAP ERP.NoteYou can select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
- If you're creating a new model:
- Choose an existing connection, or create a new connection.
-
Copy a query from an existing model (which you can edit before saving), or
create a new query.
- To edit an existing query, follow these steps:
- Select a query from the list.
- Select Modify existing query.
- Make your changes, and then select Next.
- If the data source contains prompts, select values for them.
- Review the Preview data, and then select Done.
- Or, to create a new query, follow these steps:
- Select Create a new query.
- Type a name for the query.
- Select an ERP object from the list, or search for an object by name, and then select Next.
- Select columns from the Available Columns list to add to the Selected Columns list, and then select Next.
- If the data source contains prompts, select values for them.
- Review the Preview data, and then select Done.
- To edit an existing query, follow these steps: