19
Sep 2022
Course
19 September, 2022
09:00
to
17:00
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.
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
- Adding Components to a Workbook
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 Nico Sacré at nico.sacre@element61.be or via mobile on +32 473 23 35 80.