SAP Analytics Cloud allows you to add data into an existing import (Acquired) model. In this blog, let us learn about various import methods to properly update the new data without affecting the context.

Data Import

In the existing data model under the Data Management tab, you have the option to import draft data sources. You can import data from File or any other data source irrespective of the origin of the existing data.
sap-analytics-cloud-importing-new-data-existing-model-1

The field names the same as the one in the existing model are mapped automatically. If the field names are different you can manually link them.
sap-analytics-cloud-importing-new-data-existing-model-2

Import Methods

There are four import methods available. You can select the appropriate import method and select Finish Mapping.
sap-analytics-cloud-importing-new-data-existing-model-3

Let us see the various import methods in detail.

  1. Update

    • Records with completely new tuples are added without any changes.
    • For existing tuples with updated facts, the old values will be overwritten with new ones.
      sap-analytics-cloud-importing-new-data-existing-model-4
  2. Append
    • Completely new records are added without any changes.
    • For existing records with updated facts, the new values are aggregated with the old ones.
      sap-analytics-cloud-importing-new-data-existing-model-5
  3. Clean and replace selected version data
    • Completely new records are added without any changes.
    • For existing records with updated facts, the old values will be overwritten with new ones.
    • Records that are present in the old file and not present in the new file are removed.
    • This is like a clean wipe-out of existing data for the selected version and replacement with new data.
      sap-analytics-cloud-importing-new-data-existing-model-6

      Loading the data into a different version of the account

      Note that all the above types of DML (Data Manipulation Language) operations can be maintained in versions. We now try to load the same data into the ‘forecast’ version of sales. Since this is a new version, update and append will have a similar effect and all the data in the existing version are left untouched.
      Select the New Version option while importing the data and create a Version called ‘Forecast’. This version will be available in the dropdown list of Existing Version in the upcoming import jobs.
      sap-analytics-cloud-importing-new-data-existing-model-7

      • A union of records from both the files is present in the new file.
      • Both existing, intersecting and new records are present in the new file with null values in appropriate versions for tuples with no data in one of the files.
        sap-analytics-cloud-importing-new-data-existing-model-8
  4. Clean and replace the subset of data
    When selective delete and load is to be performed, clean and replace a subset of the data should be used.
    By default, Category is defined in scope and you can add additional dimension(s) to the scope as well.

sap-analytics-cloud-importing-new-data-existing-model-9

When a dimension is added to the scope,

    • The list of members in the file to be imported is taken.
    • Records in the existing model containing the list of members matching the imported file for the dimension (specified in the scope) is dropped.
    • The records in the new file are added to the data model.

Consider the following – original data in the data model (left) and new data to be imported (right).
sap-analytics-cloud-importing-new-data-existing-model-10
Let us look at how data gets impacted when various dimensions are defined in scope.

  1. Product is defined in the scope
    sap-analytics-cloud-importing-new-data-existing-model-11
  2. The year is defined in the scope
    sap-analytics-cloud-importing-new-data-existing-model-12
  3. Both Year and product are defined in the scope
    sap-analytics-cloud-importing-new-data-existing-model-13

 

* * *

Reach out to us here today if you are interested to evaluate if SAP Analytics Cloud is right for you.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com