Listing Analysis for Office Data Sources

Objective

After completing this lesson, you will be able to list the data sources used by Analysis for Excel.

Introduction to Analysis for Office

SAP Analysis for Microsoft Office is a Microsoft Office add-in that allows multidimensional analysis of SAP data sources. It consists of the following plug-ins:

  • Analysis

  • Enterprise Performance Management (EPM)

  • Business Planning and Consolidation (BPC)

The three plug-ins are installed in one common installation. After the installation, the Analysis and EPM plug-ins are available as separate tabs in the ribbon. In this course we discuss the Analysis plug-in.

The Analysis for Office add-in allows users who are familiar with Microsoft Office applications to incorporate SAP data into their Office workbooks and presentations without learning how to use an entirely new software application. When used with Microsoft Excel, you get SAP-specific data analysis functionality, in addition to the standard Microsoft data analysis functions.

The figure shows screenshot of an Analysis for Excel worksheet with the design panel displayed.

Screen shot of an Analysis for Excel worksheet with the design panel displayed

Data Sources for Analysis for Office

Analysis for Microsoft Office is installed on your local machine. Once it is installed, you can insert data from any of these SAP systems:

  • SAP Business Warehouse (BW)
    • BW queries
    • Query views
    • BW InfoProviders
  • SAP HANA
    • Analytic views
    • Calculation views
    • SAP HANA Cloud
  • SAP S/4HANA Cloud
    • Queries
    • Cubes
  • SAP Analytics Cloud
    • Live models
    • Import models
  • SAP Datasphere - analytical datasets of type InAModel

Summary

Le's summarize:

    • SAP Analysis for Microsoft Office enables multidimensional SAP data analysis in Office applications.
    • It features plug-ins: Analysis, EPM, BPC and integrates SAP data from BW, HANA, S/4HANA Cloud, Analytics Cloud, and Datasphere.