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 ReportInformation published on SAP site and Expense EntriesInformation published on SAP site 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 EntriesInformation published on SAP site.

Procedure

  1. Select the appropriate option:
    • If you're creating a new model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Start of the navigation pathGet data from a datasource Next navigation step SAP ConcurEnd of the navigation path.
        Note
        From the acquire data panel, select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.
    • If you're importing into an existing model:
      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step DatasourceEnd of the navigation path.
      5. Select SAP Concur.
        Note
        You can select the filter icon to narrow down the number of datasources in the list. You can filter by datasource type or by category.
  2. Select your connection or select Create New Connection to create a new connection.
    For more information, see Import Data Connection to SAP Concur.
  3. Copy a query from an existing model (which you can edit before saving), or create a new query.
  4. If you're using an existing query, select it from the list.
    1. If you want to make changes to the query, select Modify existing query.
    2. Make your changes, and then select OK.
  5. If you're creating a new query, enter a name for your query.
    1. 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.
  6. 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.