SAP Analysis for Microsoft Office

Gain insights faster – with easy-to-use BI tools for your Microsoft Office environment

Uncover deep business insights in your data – with SAP Analysis for Microsoft Office. This business intelligence (BI) and multi-dimensional data analysis software makes it easy to filter and manipulate data, identify trends and outliers right within Excel, and share findings in live PowerPoint presentations – all without help from IT.

Why SAP Analysis for Microsoft Office?

Because this Microsoft Excel add-in can help you easily run ad-hoc analysis of OLAP sources in Excel. Seamlessly connect with SAP Business Warehouse and SAP HANA to power real-time analytics – and share your findings by embedding BI into live PowerPoint presentations.

Analyze large data sets to uncover deep business
insights
Discover, compare, and forecast business drivers in Excel
Share discoveries by embedding data analytics into PowerPoint presentations
Boost analyst efficiency with content reuse and
real-time query responses
Speed data analysis with in-memory computing
technology

Learn how SAP Analysis for Microsoft Office can simplify the lives of business users and IT staff:

Functional Capabilities

Design and navigation

Use simple drag-and-drop tools to filter, drill-down, slice and dice, replace data, and more
Get easy access to data hierarchies
Sync with other SAP BusinessObjects clients

Live PowerPoint presentations

Export current analysis from Excel
Insert BEx query results directly into your presentations

Collapse

Technical Capabilities

Analysis plug-in - Conduct multi-dimensional analysis of OLAP sources in Microsoft Excel. Design Excel workbook-based applications – and easily create BI presentations in PowerPoint.
EPM add-in for Microsoft Office Access, analyze, and report on data in SAP BusinessObjects EPM solutions. This plug-in introduces new connectivity to SAP Business Planning and Consolidation sources and MDX-based third-party tools.

Note: Both plug-ins include versions for Excel and PowerPoint. They are installed in a single installation, and are available as separate tabs in your ribbon.

Collapse

Need additional help? Explore SAP Digital Business Services

System requirements for SAP Analysis for Microsoft Office

System and software requirements vary according to specific customer scenarios – please refer to the Sizing Guide for details. Also, please see the Product Availability Matrix for the latest information on updates and releases.

System Requirements	Details
Microsoft Office	Microsoft Office 2010 (Excel and PowerPoint) or Microsoft Office 2013 (Excel and PowerPoint)
SAP NetWeaver	SAP Business Warehouse (SAP BW) 7.0 or higher Recommendation: Use SAP BW 7.0 EHP1 or even SAP BW 7.3 as there are significant TCO and integration improvements between SAP BusinessObjects Enterprise and SAP BW.
Other	Microsoft .NET Framework 4.5 Redistributable Package

Product Availability Matrix*

Licensing and purchasing options

The modular structure of SAP Analysis for Microsoft Office allows you to license and pay for only the functionality and number of users that you require at any given time. Start with the packages and licenses your organization needs right now and add more users and functionality as your needs evolve. This product is deployed on-premise and requires a perpetual license. Contact your local SAP account executive for additional licensing and purchasing options.

Buy SAP software now and pay later — with our flexible payment plans and financing options

For general licensing information, consult Licensing SAP Software: A Guide for Buyers

Implementation

Ensure a successful implementation and maximize your ROI with information resources that support the different phases of SAP Analysis for Microsoft Office – from planning and installation to operation.

- Plan
- Install
- Operate
- Train

Plan the installation

Refer to SAP Analysis for Microsoft Office Administrator Guide* for important information about installation and upgrade planning.

Confirm that you have a license key

To request permanent license keys, you need authorization under myProfile*. To extend your authorization, please contact an SAP user administrator*.

Download the software

Visit the SAP Support Portal* to download the SAP Analysis for Microsoft Office software installation package.

Need additional help with your implementation?
Contact SAP Digital Business Services or SAP Enterprise Support services

Find an SAP partner to help with your implementation

Complete the installation steps

Refer to page 10 of the Administrator’s Guide* for a step-by-step overview of the installation process, including the required tools and associated documentation.

Need additional help with your implementation?
Contact SAP Digital Business Services or SAP Enterprise Support services

Find an SAP partner to help with your implementation

Ensure the security of SAP Analysis for Microsoft Office

Download the SAP Analysis for Microsoft Office Admin Guide* for important information on ensuring the security of your software.

User Guides

Need additional help with your implementation? Contact Digital Business Services

Find an SAP partner to help with your implementation

Find additional documentation on this product in the Help Portal.

Enhance your knowledge of our analysis tool

View the SAP Analysis for Microsoft Office training and certification catalog of instructor-led courses and e-courses – and train when and where it’s convenient for you.

View the catalog

Stay up-to-date with our learning maps

Consultants, get role-specific learning maps with SAP implementation and operation information. These online knowledge products cover our latest products and upgrades.

Learn more*

Need help planning your SAP education? Learn how our education consulting services can help

Upgrades

Plan and carry out a successful upgrade to the latest release of SAP Analysis for Microsoft Office – so you can take advantage of the new features and capabilities right away.

- Plan
- Upgrade

Identify the upgrade paths

Download the Product Availability Matrix to review upgrade paths for SAP Analysis for Microsoft Office.

Download the matrix now*

Plan the upgrade

Refer to section 4 of the Administrator Guide for important information about SAP Analysis for Microsoft Office installation and upgrade planning.

Download the admin guide*

View the product road map

Refer to the SAP IT Operations Analytics road map to see how the technology is planned to progress over time.

Download the road map

Download SAP Analysis for Microsoft Office

Get technical release information*

Download installations and upgrades*

Download support packages and patches*

Ask the Community

Visit the SAP Analysis for Microsoft Office community for the latest technology news and updates. Ask questions, post comments, and discuss issues.

Visit the community

Need additional help with your upgrade? Contact SAP Digital Business Services or SAP Enterprise Support services

Find an SAP partner to help with your upgrade

Support

Get the support you need to keep SAP Analysis for Microsoft Office running at peak performance. Our experts can help you maximize the value of your software, take advantage of new business models and capabilities, and more.

Troubleshoot and Maintain

Find solutions to known issues. Stay up to date with technical planning resources and software updates. See more >>

SAP Support resources

Search for SAP Notes & Knowledge Base Articles

Get technical release information for SAP BusinessObjects Analysis 2.3 for Microsoft Office

Download the latest support packages and patches

View your existing license keys or request additional keys

Open a Support Incident when you need technical assistance from SAP

Product Documentation for SAP Analysis for Microsoft Office 2.3 SP1

What's New

Installation, Configuration, Security and Administration Information

End-User Information