Overview
When you create a “Cross-Model Copy” step within an SAP Analytics Cloud Data Action, the system includes a smart feature: Automatic Dimension Mapping.
Instead of manually dragging and dropping to link every single dimension from your source model to your target model, SAC automates this process for you. This feature significantly reduces configuration time and minimizes the risk of incorrect mapping.
- Select Source Model: As soon as you select a Source Model for the copy step, SAC scans its dimensions.
- Apply Mapping Logic: SAC will automatically map a source dimension to a target dimension if one of the following two conditions is met:
- Priority 1: Matching Dimension ID: The system first looks for dimensions in both models that have an identical ID. This is preferred and most reliable.
- Example: The d/Company_Code dimension in the source model will automatically map to the d/Company_Code dimension in the target model.
- Priority 2: Matching Description: If no matching ID is found, SAC will then look for dimensions that have an identical Description.
- Example: The “Profit Center” (ID: d/PC) dimension in the source model will map to the “Profit Center” (ID: d/Profit_Center) dimension in the target model (their IDs are different).
- Priority 1: Matching Dimension ID: The system first looks for dimensions in both models that have an identical ID. This is preferred and most reliable.
Notes
- Manual Mapping: For any dimensions that do not map automatically (because both their ID and Description are different), you will still need to map them manually by dragging and dropping.
- After auto-mapping, you still need to readjust the settings for the individual members to avoid any conflicts (mapping to the wrong members) or shortages (missing members).
