SAP BW/4HANA Query Design and Analysis – BW405 — Lesson 2: Restricted and Calculated Key Figures, Properties, Aggregation, Exception Aggregation, Currency, and Units

Learning Objectives

• Explain the SAP structures, data, settings, roles, and dependencies governing key-figure calculations and aggregation.
• Perform and validate currency, units, and exception aggregation using reviewable system evidence.
• Evaluate the condition where a query returns misleading totals because calculated key figures, exception aggregation, variable processing, and structure intersections are misconfigured and select proportionate corrective action.

Detailed Topics

• Restricted and Calculated Key Figures applied to the course scenario, expected SAP behavior, dependencies, and evidence.
• Properties applied to the course scenario, expected SAP behavior, dependencies, and evidence.
• Aggregation applied to the course scenario, expected SAP behavior, dependencies, and evidence.
• Exception Aggregation applied to the course scenario, expected SAP behavior, dependencies, and evidence.
• Currency applied to the course scenario, expected SAP behavior, dependencies, and evidence.
• and Units applied to the course scenario, expected SAP behavior, dependencies, and evidence.

Instructor Demonstration

The instructor traces a BI developer creating governed analytical queries that support both routine reporting and complex management analysis. The walkthrough connects navigation, configuration or process logic, system messages, and evidence captured in the BW405 query design, validation, and performance portfolio. It also tests the exception where a query returns misleading totals because calculated key figures, exception aggregation, variable processing, and structure intersections are misconfigured.

Hands-On Exercise

Complete a controlled SAP exercise covering Restricted and Calculated Key Figures, Properties, Aggregation, Exception Aggregation, Currency, and Units and preserve the verified result in the BW405 query design, validation, and performance portfolio.

1. Confirm scope, prerequisites, master data, roles, dependencies, and acceptance criteria.
2. Execute the workflow while recording settings, transactions, outputs, and system messages.
3. Test normal behavior, one boundary condition, and the stated exception.
4. Document corrections, evidence, ownership, retest criteria, and handover actions.

Scenario Analysis

• Identify which object, rule, setting, or process step most strongly influences key-figure calculations and aggregation.
• Compare two defensible responses and explain business, technical, control, and support trade-offs.
• Determine how the BW405 query design, validation, and performance portfolio should be approved, retained, retested, and updated.

Troubleshooting Guidance

Start where expected SAP behavior first differs from the observed result. Check master data, configuration sequence, authorization, integration, status, and transaction evidence separately. Treat “a query returns misleading totals because calculated key figures, exception aggregation, variable processing, and structure intersections are misconfigured” as a hypothesis until system settings, logs, documents, and outcomes confirm the cause.

Validation Checklist

• Required SAP structures, master data, roles, settings, and dependencies are present.
• The BW405 query design, validation, and performance portfolio connects each conclusion to objective, reviewable evidence.
• Normal processing, the boundary condition, integration behavior, and exception were tested.
• Corrections, ownership, retest criteria, documentation, and operational handover are complete.

Lesson Outcome

Learners can apply Restricted and Calculated Key Figures, Properties, Aggregation, Exception Aggregation, Currency, and Units, explain the resulting SAP behavior, and defend the outcome through the BW405 query design, validation, and performance portfolio.