Skip to main content

Module 7: BW Queries – Basics (BW/4HANA 2.0)

BW Queries are the consumption layer of BW/4HANA.
They do not store data — instead, they define how data is presented, filtered, and calculated for analytics tools.

In modern BW/4HANA:

  • Queries sit on CompositeProviders
  • Heavy logic is pushed down
  • Queries focus on analytical semantics

1. BW Query Concept​

A BW Query is a semantic definition that:

  • Selects characteristics and key figures
  • Defines filters and variables
  • Performs analytical calculations
  • Exposes data to reporting tools
Key Principle

A BW Query defines what users see, not how data is stored.

2. Position of BW Query in LSA++​

aDSO / Open ODS View
        ↓
  CompositeProvider
        ↓
      BW Query
        ↓
Analytics Tools (SAC, AO, etc.)
Best Practice

Always build BW Queries on CompositeProviders, not directly on aDSOs.

3. Query Designer (Eclipse)​

Modern Query Modeling Tool​

In BW/4HANA, BW Queries are created using:

  • BW Modeling Tools (Eclipse)

Why Eclipse over SAP GUI?​

AspectSAP GUI (BEx)Eclipse
Future supportLimitedStrategic
UILegacyModern
IntegrationPartialFull BW4
PerformanceLowerOptimized
Deprecated

SAP GUI-based BEx Query Designer is not recommended for BW/4HANA.

4. Characteristics vs Key Figures​

Characteristics​

Characteristics define dimensions of analysis.

Examples:

  • Customer
  • Material
  • Company Code
  • Time

Used for:

  • Rows / columns
  • Filters
  • Drill-down

Key Figures​

Key figures define measures.

Examples:

  • Revenue
  • Quantity
  • Cost

Used for:

  • Aggregation
  • Calculations
  • KPIs

Comparison​

AspectCharacteristicsKey Figures
RoleDimensionMeasure
NavigationYesNo
AggregationNoYes
FiltersYesYes
Modeling Rule

Use as few characteristics as necessary in initial query layout.

5. Filters & Variables​

5.1 Filters​

Filters restrict data displayed in the query.

Types:

  • Fixed filters
  • Dynamic filters
  • Default filters

Example:

Fiscal Year = 2024
Company Code = 1000

5.2 Variables​

Variables allow dynamic input at runtime.

Types:

  • Characteristic value variables
  • Hierarchy variables
  • Text variables
  • Formula variables

Variable Processing Types​

TypeDescription
Manual InputUser enters value
Replacement PathDerived from master data
Customer ExitABAP logic
AuthorizationBased on user roles
Best Practice

Prefer replacement path variables over customer exits.

6. Structures​

What is a Structure?​

A structure is a reusable container used to:

  • Group key figures
  • Create calculated KPIs
  • Control layout

Types:

  • Key Figure Structure
  • Characteristic Structure

Use Cases​

  • KPI dashboards
  • Variance analysis
  • Multiple calculations in one query
info

Structures are essential for complex analytical scenarios.

7. Restricted Key Figures (Intro)​

What is a Restricted Key Figure (RKF)?​

An RKF is a key figure restricted by conditions.

Example:

Revenue where Fiscal Year = 2024

Use Cases​

  • Period-specific KPIs
  • Region-specific measures
  • Comparison metrics
info

RKFs are evaluated at query runtime, not during data load.

8. Calculated Key Figures (Intro)​

What is a Calculated Key Figure (CKF)?​

A CKF is a key figure derived using formulas.

Example:

Margin = Revenue – Cost

Use Cases​

  • Ratios
  • Percentages
  • Variances
warning

Avoid very complex CKFs — push heavy logic to HANA or modeling layers.

9. BW Query vs Classic BEx Query​

AspectClassic BWBW/4HANA
ToolBEx Query DesignerEclipse
ProviderInfoCubeCompositeProvider
PerformanceAggregate-basedHANA pushdown
Logic locationQuery-heavyModel-first
Key Shift

BW/4HANA prefers simple queries on strong models.

10. Common Query Design Mistakes​

Avoid These

Building logic-heavy queries
Too many free characteristics
Reporting directly on aDSOs
Using customer exit variables unnecessarily

11. Interview-Grade Explanation​

Q: What is the role of a BW Query in BW/4HANA?

Answer: A BW Query is the consumption layer that defines analytical semantics such as filters, variables, structures, and calculations on top of CompositeProviders, exposing data to reporting tools without storing data.

12. Summary​

  • BW Queries define analytical consumption
  • Built using Eclipse-based tools
  • Characteristics = dimensions
  • Key figures = measures
  • Filters & variables enable dynamic analysis
  • RKFs & CKFs introduce analytical logic

13. What's Next?​

➡️ Module 8: Advanced BW Query Concepts
(RKFs, CKFs, Conditions, Exceptions)

Learning Tip

Strong BW models make simple, fast queries possible.