00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

BOAN10: SAP BusinessObjects Analysis, Edition for Microsoft

COURSE OBJECTIVES

This course will prepare you to:

  • Analyse OLAP sources in Microsoft Excel and create intuitive presentations with MS PowerPoint using SAP BusinessObjects Analysis Addins
  • 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

Price: €1,195 per person

Dates

  • 1st February, 2018 – 2 Days

SAP_Partner

TARGET AUDIENCE

The target audience for this course is key users of Analysis in SAP and includes Application Consultants, Business Analysts, Business Process Owners / Team Leads / Power Users and Developer Consultants.

PREREQUISITES

Essential

  • Microsoft Excel skills

Recommended

  • Experience with BEx Queries
Software Release Information and Notes

Course based on software release

  • SAP BusinessObjects Analysis 2.4, edition for Microsoft Office, BI Launchpad, SAP NetWeaver Business Warehouse 7.4

Notes

  • None
Course Outline

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, edition for Microsoft Office – Excel

  • 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
  • Defining Formatting Options for the Crosstab
  • Adding Components to the Workbook
  • Working with Formulas
  • Creating a Default Workbook
  • Converting BEx Analyzer Workbooks
  • Setting Preferences
  • Publishing and Scheduling
  • Introducing the Usage of VBA in Analysis
  • SAP BusinessObjects Analysis, edition for Microsoft Office – PowerPoint

    • Starting the Microsoft Power Point Addin and Inserting a Data Sourc
    • Using the Fit Table Function
    • Adding Charts and Info Fields
    • Changing Presentation Settings
    • Publishing Analysis Presentations”
    Contact Us

    Drop us a line, include your contact details and we will get back to you as soon as possible.