Analysis for Office and Eclipse-based Query Modeling in BW/4HANA

Sep 2022
19 September, 2022
Full Day
Buro & Design Center - 1020 Brussels
700 euro per participant

This 1 day instructor-led training including exercises provides users the detailed knowledge on how to create queries in the new improved eclipse-based environment and learns them how to use these queries in Analysis for Office for reporting and further analysis.


  • Any person that needs to report on BW/4HANA using Analysis for office
  • SAP BW power users


  • Basic familiarity with BW/4HANA modeling concepts
  • Experience using Microsoft Excel


  • BW Query Modeling in Eclipse
    • Create Queries
    • Structures in Queries
    • Characteristics, Attributes, and Hierarchies in Queries
    • Create Variables in Queries
    • Create Restricted Key figures
    • Create Calculated Key figures
    • Create Global Structure & Global Filter
    • Exceptions and Conditions in Queries
  • SAP Analysis, Excel – Analysis Tab
    • Insert a Data Source
    • Navigate in a Data Source
    • Sorting and Filtering
    • Creating Measures
    • Working with Hierarchies
    • Working with Variables
    • Working with Formulas
    • Axis Sharing
    • Setting Preferences
  • SAP Analysis, Excel – Analysis Design Tab
    • Adding Components to a Workbook
      • Chart
      • Info Field
      • Filter
      • New Lines
    • Define Formatting Options for the Crosstab
    • Creating a Default Workbook
    • Synchronizing Crosstabs

Duration: 1 day

Training Curriculum

  • Presentation, instructor demonstrations and exercises using our Training Environment
  • Bring your own laptop
  • No need to install any tools on your laptop like Eclipse or Analysis for Office. We provide access to a virtual machine using Azure Labs.

Take Away Materials

  • Handbook of the content covered including exercises


  • HANA studio/Eclipse
  • Analysis for Office

More information or registration?

For more information, contact Nico Sacré at or via mobile on +32 473 23 35 80.