SAP BusinessObjects Analysis, edition for Microsoft Office (BOAN10)

Request a Quote for this class

Audience Profile

This course is intended for business intelligence analysts, project team members, and “power-users.”

At Course Completion

  • Through fifteen exercises, participants will experience and learn of the basic functions, navigation, and layout design options of Business Objects Analysis, edition for Microsoft Office.
  • It will prepare particpants to analyse Bex Querys, define formatted workbooks, define navigational elements using VBA.



  • Basic understanding of SAP NetWeaver Business Warehouse Querys

Course Outline

  • Overview of Analysis, Office edition
  • Filtering & Sorting
  • The Design Panel
  • Navigation Options
  • Adding a Chart
  • Filtering By Measure
  • Working with Hierachies
  • Insert Components
  • Using Formulas to add additional information
  • Conditional Formatting & Prompting
  • Change Variables in Prompts and Add Calculations
  • Creation of layout elements (e.g.; dropdown boxes) in combination with VBA to control variables and filter values
  • Combination of multiple functions into one action
  • Advanced scenarios for formula usage