Deriving an architecture overview model from a key figure matrix is a critical step in designing an SAP

BW/4HANA solution. The first step in this process is to identify the sources of the data that will

populate the key figures. Understanding the data sources ensures that the architecture is built on a

solid foundation and can meet the reporting and analytical requirements.

Correct Answer:

Identify sources (Option B):

Before designing the architecture, it is essential to determine where the data for the key figures

originates. This includes identifying:

Source systems: ERP systems, external databases, flat files, etc.

Data types: Transactional data, master data, metadata, etc.

Data quality: Ensuring the sources provide accurate and consistent data.

Identifying sources helps define the data extraction, transformation, and loading (ETL) processes

required to populate the key figures in the architecture.

Why Other Options Are Incorrect:

Identify transformations (Option A):

Transformations are applied to the data after it has been extracted from the sources. While

transformations are an important part of the architecture, they cannot be defined until the sources

are identified.

Analyze storage requirements (Option C):

Storage requirements depend on the volume and type of data being processed. However, these

requirements can only be determined after the sources and data flows are understood.

Define data marts (Option D):

Data marts are designed to serve specific reporting or analytical purposes. Defining data marts is a

later step in the architecture design process and requires a clear understanding of the sources and

transformations.

Steps to Derive an Architecture Overview Model:

Identify sources: Determine the origin of the data.

Map data flows: Define how data moves from the sources to the target system.

Apply transformations: Specify the logic for cleansing, enriching, and aggregating the data.

Design storage layers: Decide how the data will be stored (e.g., ADSOs, InfoCubes).

Define data marts: Create specialized structures for reporting and analytics.

Key Points About Architecture Design:

Source Identification:

Identifying sources is the foundation of any data architecture. Without knowing where the data

comes from, it is impossible to design an effective ETL process or storage model.

Key Figure Matrix:

A key figure matrix provides a high-level view of the metrics and dimensions required for reporting.

It serves as a starting point for designing the architecture.

Reference to SAP Data Engineer - Data Fabric:

SAP BW/4HANA Modeling Guide:

This guide explains the steps involved in designing an architecture, including source identification

and data flow mapping.

Link: SAP BW/4HANA Documentation

SAP Note 2700980 - Best Practices for Architecture Design in SAP BW/4HANA:

This note provides recommendations for designing scalable and efficient architectures in SAP

BW/4HANA.

By starting with source identification , you ensure that the architecture overview model is grounded

in the actual data landscape, enabling a robust and effective solution design.