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

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.

Audience

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

Prerequisites

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

Content

  • 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 bjorn.vandamme@element61.be or via mobile on  +32 473 283 666.

Date

29/04/2021 -
09:00 to 17:00

Location

Virtual Session

Duration

Full day

Price

700 euro per participant