Scheduling Data Imports

Objectives

After completing this lesson, you will be able to:

  • Schedule a data import to SAP Analytics Cloud

Schedule Data Imports

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. They can be set up 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 can be seen in the following example.

Monthly Jobs

Depending on the frequency of the import schedule, the transaction import query may need to be adjusted. 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, you can select two options for the job if the query fails:

  1. The failed import is skipped, and the remaining import queries run.
  2. All imports are stopped.

You can also choose to be notified by email of refresh failures.

Monitoring

The jobs can be monitored in the Schedule Status tab, which can be accessed from both the model and the Connections area.

Schedule a Data Import

Business Scenario

The final phase of the integration project is to schedule the data imports. The business requirement for the master data and transaction data import is that is occurs on a weekly basis.

What skills will you develop in this practice exercise?

We will use SAP Business Warehouse as our example source system.

In this practice exercise, you will:

  • Schedule a repeating data import job
  • View the schedule in the Schedule Status tab

Log in to track your progress & complete quizzes