Course announcements

  • In this course you will learn about basic and special functions of Analysis edition for Office 2.2 and Design Studio 1.6. You will learn how to create workbooks and Dashboards to show complex issues based on BW data in an easy way.


  • This course will prepare you to:
    • Create workbooks by using the functionalities and Design options of SAP BusinessObjects Analysis, edition for MicrosoftOffice 2.2
    • Know about the special functions of Analysis edition for office 2.2
    • Create applications for desktop clients and mobile devices using SAP BusinessObjects Design Studio


  • Application Consultant
  • Business Analyst
  • Data Scientist
  • Business Process Architect
  • Business Process Owner / Team Lead / Power User
  • Consultants, to complete the Certification C_TBI30_74 - SAP Certified
  • Application Associate - Business Intelligence with SAP BW 7.4 & SAP BI
  • User




  • None

Course based on software release

  • SAP BusinessObjects Analysis 2.2, edition for Microsoft Office
  • SAP BusinessObjects Design Studio 1.6
  • SAP NetWeaver Business Warehouse 7.4 SP 09


  • Understand the positioning of SAP BusinessObjects Design Studio and Analysis, edition for Microsoft Office
  • Understand the different deployment types and architecture of SAP BusinessObjects Design Studio and Analysis, edition for Microsoft Office
  • Analysis edition for office 2.2
  • Understand the basic functions of Analysis for Office 2.2
  • Learn how to use components and Data Sources in SAP Business Objects Analysis edition for Office
  • Navigation, Sorting and Filtering in Analysis edition for office
  • Lean how to create measures and work with hierarchies / variables in a workbook
  • Learn how to define formatting options for cross tables and Charts
  • Learn how to create Analysis edition for Office workbook templates
  • Learn how to customize a layout of a workbook
  • Learn how to use formulas and function of Analysis edition for office
  • Migration of BEx workbooks
  • Learn how to extend a workbook with Visual Basic for Applications (VBA)
  • Learn how to create Presentations
  • Publication of Workbooks
  • BusinessObjects Design Studio 1.6
  • Understand the basic functions of BusinessObjects Design Studio 1.6
  • Positioning / Architecture
  • Learn how to create dashboard-like applications
  • Learn how Create script free applications by :
    • using Analysis components like e.g. Crosstab and Chart
    • using Container components
    • using Basic components with data bound properties
    • using Icons and Images
    • using the Scorecard component for highly formatted tables
  • Define the layout of applications
    • Understanding the usage of Templates
    • Using predefined Themes
    • Using the direct CSS property
    • Using a Custom CSS file
  • Create advanced applications using scripting techniques
    • Introduction to scripting
    • Define the navigation behavior of basic components with scripting
    • Using local variables in script functions
    • Using global variables as URL parameter
    • Using global script objects and formatter functions
  • Deploy and optimize applications on mobile devices

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

Learn more