Creating Transformations

Dimensions

1. Right-click → New Transformation
2. Choose Type: Dimension
3. Select source tables (e.g., BKPF)
4. AC creates a transformation that maps all fields from the source
5. You can apply friendly names (technical → business-friendly)

Example:

Fact Tables

1. Create a new transformation of type “Fact”
2. Select one main transactional table (e.g., BSEG) and its related dimension tables (e.g., BKPF)
3. Define the join keys manually or use inherited references
4. Add calculated fields (e.g., Amount = Quantity * Price)
5. Add surrogate keys (SK) to link to dimensions

Tip: If some tables are not directly linked, you can define manual relationships using the “Reference Statement” field.