Wat is SAP Analysis for Microsoft Office
Analyze SAP BW and SAP HANA sources in MS Excel and create intuitive presentations with MS PowerPoint using SAP Analysis for Microsoft Office. NOTE: This course is applicable for customers on the SAP BusinessObjects BI Platform version 4.2 or 4.3, as well as for customers using only an SAP BW Platform. Course based on software release: SAP BusinessObjects BI 4.3, SAP Analysis for Microsoft Office 2.8
This course will prepare you to:
- Learn the basic functions and navigation options of SAP Analysis for Microsoft Office
- Learn the special functions and layout design options of SAP Analysis for Microsoft Office
-
Contents:
Positioning and Overview of SAP Analysis for Microsoft Office
SAP Analysis, Excel – Analysis Tab
Insert a Data Source
Navigate in a Data Source
Sorting and Filtering
Creating Measures in the Workbook
Working with Hierarchies
Working with Variables
Working with Formulas
Setting Preferences
SAP Analysis, Excel – Analysis Design Tab
Adding Components to a Workbook
Define Formatting Options for the Crosstab
Creating a Default Workbook
Synchronizing Crosstabs
Using Workspaces