SAC - Load Master Data Daily

To build a dynamic master data dimension in SAP Analytics Cloud (SAC) and load delta records every night, you can follow the steps below. This process ensures that any new records added to your master data are updated regularly in SAC. Here's an outline of the procedure:

Step-by-Step Procedure for Building the Master Data Dimension and Loading Delta Records:

1. Create the Master Data Dimension:

• Login to SAP Analytics Cloud (SAC).
• Navigate to Modeler and choose Create a New Dimension.
• Select Master Data Dimension and define its key attributes (e.g., ID, Description, etc.).
• After creating the dimension, you can upload your initial master data records manually via a CSV file or via a live connection to an external system (like SAP BW or HANA).

2. Schedule Delta Data Loads:

• To automatically load delta records (newly added records) every night, you need to implement a scheduled data load. This is typically achieved through one of the following options:
  • Data Integration via OData Services or SAP BW:
    • If your master data resides in SAP BW or HANA, set up an OData service or use SAP BW live data connections to bring in the updated records.
  • Use Data Management Jobs:
    • In SAC, navigate to Data Management under your model settings.
    • Set up a Data Import Job or Data Export Job, which will be responsible for bringing in delta changes. This can be scheduled for regular intervals (e.g., daily, nightly).

3. Load Delta Records:

• Initial Load: The first step will be to load the full set of master data to SAC.
• Delta Load Setup: For delta records, set up an ETL process (Extract, Transform, Load) that loads only the new or changed records. Typically, this is achieved through one of the following:
  • Data Wrangling: Set up logic in your data pipeline to filter for records added/changed since the last load (this can be done by comparing timestamps or record IDs).
  • Delta-Specific API or Web Services: Use APIs that support delta loads (e.g., SAP BW extractors).

4. Automate Delta Loads (Daily/Nightly):

• After configuring your data source to provide delta records, you'll need to schedule automated loads to run every night:
  • In SAC, go to the Calendar feature to schedule jobs.
  • Create a new process that runs every night at a specified time.
  • Set the process to execute the data load job to bring in delta records.
  • Monitor job success or failure through SAC's monitoring tools.

5. Verify and Test:

• After the automation is set up, perform a test to ensure that new records are loaded correctly. Add a new master data record to your source and confirm that it appears in SAC after the scheduled load.

Key Considerations:

• Ensure that your data source supports delta extraction (e.g., timestamp or incremental loading logic).
• Monitor your scheduled jobs regularly to ensure smooth data flow.
• Validate the master data regularly to maintain data consistency across systems.

---

Key Terms:

SAC, Master Data Dimension, Data Management Jobs, Delta Records, OData Services, SAP BW, SAP HANA, ETL, Data Integration, Data Wrangling, Delta-Specific API, Calendar feature, Automated Data Load.