Update and Schedule Models
When you create a model from a data source, or import data into an existing model, an import job is automatically created as well, so that you can schedule data imports.
Context
Schedule a data import if you want to refresh data against the original data source. See “Import Data Options” in step 3 of this help topic for details.
You can import data from multiple queries (and data sources) into a model, and each of these imports can be separately scheduled.
Data sources that support scheduling:
- SAP Business Planning and Consolidation (BPC)
- SAP Business Warehouse (BW)
- SuccessFactors
- A Salesforce (SFDC) user-predefined dataset or entity-based model
- An SAP BusinessObjects BI platform universe (UNX) query
- SAP ERP Central Component (SAP ECC)
- SQL Databases
- OData services
- XLSX (Excel) and CSV (comma-separated values) files imported from a file server (not imported from your local machine)
- Concur
- Google Drive
- SAP Integration Suite Open Connectors
Procedure
Results
After a scheduled job runs, the result is shown on the Schedule Status tab. If any errors or warnings occurred, select the job to see the job details in the Data Timeline panel.
If any rows in the dataset were rejected, you can select Download rejected rows to save the rejected rows as a .csv file. You can then examine this file to see which data was rejected. You could fix the data in the .csv file and then import the .csv file into the model using the Import Data workflow, or fix the data in the source system.