Once master data and transaction data imports are set up and you need regular imports, it is inefficient to run them manually. It's possible to schedule imports to run periodically. You can set up schedules to run hourly, daily, weekly, or monthly.
Imports can be scheduled for:
- Dimensions: Dimension imports can be scheduled for each dimension independently.
- Models: All master data and transaction data imports can be scheduled from the planning model, as you can see in the following example.
Monthly Jobs
Depending on the frequency of the import schedule, you may need to adjust the transaction import query. For example, if the update is scheduled to run monthly, the import query’s filter has to be set to the current month.
Import Query Failure
When you are creating a scheduled job, if the query fails, you can select two options for the job:
- The failed import is skipped, and the remaining import queries run.
- All imports are stopped.
You can also choose to be notified by e-mail of refresh failures.
Monitoring
You can monitor jobs in the Schedule Status tab, which can be accessed from both the model and the Connections area.
