Importing SAP Concur Data to a New or Existing Model
To import data from SAP Concur to a new or existing model, you specify the source
model and how incoming data should be mapped to model dimensions.
Context
Note
When importing Concur data,
SAP Analytics Cloud
leverages the
Concur Expense Report and
Expense Entries API. Please be aware that the Concur
Expense Entries API has a limitation on the set of fields which can be filtered
on. Here's a list of available Expense Entries Filter Parameters:
- attendeeTypeCode
- expenseTypeCode
- hasAttendees
- hasVAT
- isBillable
- paymentTypeID
- reportID
Because of the above restrictions on filtering data, and data volume
limitations of the Concur API, the amount of data that can be retrieved from
Concur into SAP Analytics Cloud is
limited. For more information on data import thresholds, see System Requirements and Technical Prerequisites and Expense Entries.
Procedure
-
Select the appropriate option:
- If you're creating a new model:
- Select .
- Select .
Note
From 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 Concur.
Note
You 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.
-
Select your connection or select Create New Connection
to create a new connection.
-
Copy a query from an existing model (which you can edit before saving), or
create a new query.
-
If you're using an existing query, select it from the list.
-
If you want to make changes to the query, select Modify
existing query.
-
Make your changes, and then select OK.
-
If you're creating a new query, enter a name for your query.
-
Select a table, and then select Next.
Build your query by moving data elements into the
Selected
Data and
Filters areas. For more
information see,
Building a Query.
-
Select OK.
The data appears in the data integration view, where you can complete the
mapping of your new data to the model's dimensions.
Next Steps
After the initial import of raw data, continue with the
data preparation task before completing your model:
Preparing Data.