Importing transaction data is covered in detail in the Importing and Wrangling Transactional Data in a Model lesson in the Designing Data Models and Transforming Data in SAP Analytics Cloud learning journey.
Below, you will find some additional information related to creating an import query to suit your own business requirements when creating a hybrid planning solution.
Data Acquisition Limits
Data acquisition limits for new models:
- Non-SAP Data Center Platform: 1,000,000,000 cells, 1000 columns.
- SAP Data Center Platform: 10,000,000 cells, 1000 columns.
As with importing master data, it is also possible to restrict the transaction data that is imported by applying filters in the import query. When importing transaction data, it's common to filter year and period.
In the Map to Facts step, keep the following in mind for transaction data imports:
- The version defaults to Actual. You can switch to a different public version by remapping the dimension.
- Generic and organization dimension types can use a member as a default or # (unassigned).
- It is possible to import multiple measures. For example, you can import local amount, group amount, and quantity in the same import.
Review Date Settings
The date settings can be adjusted in the Map to Fact step by selecting Review Settings.
In the Mapping Summary tab, you can change Mapping and Preferences.
In the Mapping
- Map by Date: Choose this option if your source data is a calendar date. The system will find the date dimension member that matches this date and import data to it.
- Map by ID: Choose this option if your source data is fiscal shifted, or similar to the date dimension ID member. If your source data does not match the date dimension ID member, pick a format for the source data.
In the Preferences section, you can select Apply fiscal settings to column values, which allows you to pick a format for the incoming data such as Same as Target Dimension (YYYYPP) or YYYY.PP.
In the Fiscal Settings tab, you can view the time settings for the model. For example, which periods are included in the fiscal year and the starting period for the year.
When you select Run Import, a dialog provides an overview of the data that is being imported. It is possible to change the settings at this point, if required.
In the Import Settings, you can update:
- Import Method: When data is imported multiple times for the same data region, the update method is used to control the data update. These options are covered in detail in the Importing and Wrangling Transactional Data in a Model linked at the top of this lesson.
- Reverse Sign by Account Type: Use this option if the source data does not have the correct sign. For example, activate this option if revenue is stored as a positive value in the source system).
- Update Local Dimensions with New Members: Use this option to update private dimensions during the transaction data import.
If Validation Settings is enabled, you may select which hierarchies to validate against. Validating against selected hierarchies will prevent data from being imported to non-leaf members.
After you run an import query and the data is in SAP Analytics Cloud:
- Import query selection and data source can be changed for a model.
- Import query selections for dimensions can’t be changed.
- Import query filters can be changed for both models and dimensions.
Edit the Import Job
From the Data Management Workspace, it is possible to access a More actions menu, allowing you to refresh, edit, or delete the import job.