Importing Workforce Analytics Data to a New or Existing Model

You can import data from Workforce Analytics into a new or existing model.

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 data source Next navigation step SAP SuccessFactors Workforce AnalyticsEnd of the navigation path.
        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:
      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 Data sourceEnd of the navigation path.
      5. Select SAP SuccessFactors Workforce Analytics.
        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.
  2. Select your Workforce Analytics connection or select Create New Connection to create a new connection.
    For more information, see Import Data Connection to SAP SuccessFactors Workforce Analytics.
  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, build your query by moving data elements into the Selected Data and Filters areas.
    Select a measure to display a list of dimensions related to that measure. Then, select at least one dimension. For more information see, Building a Query.
    Note
    You can only use dimensions as filters. Filters only support EQUALS and AND operations.
    1. Select OK.
    2. Enter a name for your 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.