Course announcements

  • Analyse OLAP sources in MS Excel and create intuitive presentations with MS PowerPoint using SAP BusinessObjects Analysis Addins.


  • This course will prepare you to:
    • Learn the basic functions and navigation options of Analysis, edition for Microsoft Office
    • Learn the special functions and layout design options of Analysis, edition for Microsoft Office


  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Developer Consultant



  • Microsoft Excel Skills


  • Experience with BEx Queries

Course based on software release

  • SAP BusinessObjects Analysis 2.7, edition for Microsoft Office, BI Launchpad 4.2, SAP BW/4HANA


  • Positioning and Overview of SAP BusinessObjects Analysis, edition for Microsoft Office
    • Positioning of SAP BusinessObjects Analysis
    • Getting an Overview of SAP BusinessObjects Analysis
  • SAP BusinessObjects Analysis, Excel - Analysis Tab
    • Starting the Microsoft Excel Addin and Inserting a Data Source
    • Navigating in Data Sources
    • Sorting and Filtering
    • Creating Measures in the Workbook
    • Working with Hierarchies
    • Working with Variables
    • Working with Formulas
    • Setting Preferences
  • SAP BusinessObjects Analysis, Excel - Analysis Design Tab
    • Adding Components to the Workbook
    • Defining Formatting Options for the Crosstab
    • Creating a Default Workbook
    • Synchronizing Crosstabs
    • Using Workspaces
  • SAP BusinessObjects Analysis, Excel - Advanced/Administrative Topics
    • Publishing and Scheduling Analysis Workbooks
    • Using Profiles
    • Converting BEx Analyzer Workbooks
    • Introducing the Usage of VBA in Analysis
    • Using OpenDoc with Analysis Workbooks
    • Transporting between Environments
    • Troubleshooting Workbooks
  • SAP BusinessObjects Analysis, edition for Microsoft Office - Power Point
    • Starting the Microsoft Power Point Add-in and Inserting a Data
    • Source

CPE Credits

016 Credits

Please note CPE credits are available only for publicly scheduled courses delivered at SAP locations. CPE credits are not available for virtual classroom deliveries or customer specific deliveries.

This course is also available as a test system within SAP Live Access

Learn more

Submit your request

Is the course not scheduled? Or looking for other dates and locations that fit your schedule? Let us know what works for you by clicking the button below and select your preferred location. We will do our best to consider your request.

Note: Location can be for a Virtual Classroom, Public Classroom or Any location (Any Physical location except Virtual Classroom.)

Register Interest