Skip to Content

Hi everyone,

I would like to share with you some best practices for the installation, configuration and usage of SAP BusinessObjects Analysis, edition for Microsoft Office (AKA “Analysis for Office”) .

This document is for those who are starting to use Analysis for Office but can also help those who are already familiar with the tool, since it can be used as a guideline and reference.

As a starting point to use the Analysis for Office tool, it is very important to check the Administrator Guide, which includes details regarding the installation, the settings and the supported scenarios. It is also recommended to check the User Guide which contains information related to the usage of the tool and its functionalities. Both guides are available on the link below:

SAP Analysis for Office Help Page

Analysis for Office is a really flexible tool, allowing integration with SAP NetWeaver, Business Intelligence Platform (BIP) and HANA. It is recommended that you follow the specific guides on the link above depending on the desired scenario for your company.

In order to check if your environment supports Analysis for Office, please check carefully the Product Availability Matrix (PAM) on the link below, where you will find information regarding operating system, MS Excel and MS Powerpoint versions and other requisites:

Product Availability Matrix for SAP Analysis for Office

In case you need more details or face any issue during Analysis for Office installation, configuration or usage, please read the important SAP notes and links below:

SAP Note # 1466118 – Hardware & Software requirements for Advanced Analysis

SAP Note # 1739153 – SAP BW Backend requirements for Analysis Office 1.3 or higher

SAP Note # 1906657 – Analysis Office Message Checklist

SAP Note # 2134836 – Checklist for Scheduling of Analysis for Office Workbooks

Wiki – Memory consumption and result set limit in Analysis for Office

In case you have any question during the installation and configuration process or questions related to user experience, we recommend you to use this space on SAP Community Network, where you will be able to find further information and exchange experiences with other customers and professionals.

If there is any functionality that is missing or should be improved in Analysis for Office, you can check the SAP note below and visit our Idea Place, which is the main channel for feature request in this tool:

SAP Note # 1879237 – Enhancement Request for Analysis, edition for MS Office

Last but not least, SAP recommends to always use the latest version of Analysis for Office, since improvements and corrections for Analysis for Office are delivered by SAP through support packages. Therefore, we recommend that you check periodically the SAP note below which contains the release schedule, in order to make sure that you always use the latest version:

SAP Note # 1518359 – SAP BusinessObjects Analysis Office Release schedule

If you have any questions regarding this document, please do not hesitate to leave your comment below.

Best Regards,

Filipe Zeuch

SAP Active Global Support

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply