SAP Analysis for Office Training

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

Software :

  • HANA studio/Eclipse
  • Analysis for Office

More information or registration ?

For more information, contact Bjorn Van Damme at or via mobile on  +32 473 283 666.


20/04/2020 to 21/04/2020


Brussels Moore Belgium


2 days


1.250 Euro