Importing SAP Fieldglass data into a New or Existing Model
To import data from SAP Fieldglass to a new or existing model, you import a report and specify how the incoming data should be mapped to model dimensions.
Procedure
-
Select the appropriate option:
- If you're creating a new model:
- Select (Main Menu) Create Model.
- Select Get data from a data source SAP Fieldglass.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 (Main Menu) Browse Files.
- Open the model you want to update.
- Switch to the Data Management screen.
- Select Data source.
- Select SAP Fieldglass.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:
-
Select your connection or select Create New Connection
to create a new connection.
For more information, see Import Data Connection to SAP Fieldglass.
-
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, and then select OK.
-
If you're creating a new query, enter a name for your query, select a
report, and then select Next.
In the list of reports, you can search by report ID or report description. When hovering over a report, the tooltip shows the report ID.
NoteSelecting a report starts the data import for a report in Fieldglass. Currently, it is not possible to filter or to select a subset of properties for Fieldglass data.For more information about reports in Fieldglass sign into SAP Fieldglass, click on the Help icon in the upper-right of your screen, and then select "Online Help". Within the "Create Report" section you can find instructions on how to fill in the required fields when creating a new Report. The section "View Predefined Reports/Graphs" provides more information about the set of most commonly used Reports/Graphs provided by Fieldglass.
The data appears in the data integration view, where you can complete the mapping of your new data to the model's dimensions.