Analysis Office lnstallation and Update

SAP 关于excel插件的安装（AO)
安装包请留言或者私信我（属实是暂时还没有搞明白怎么把安装包放进来！）
如有不对或者不严谨的地方欢迎交流指正！

1 - General Information

Please find the PAM details for Product Version SBOP ANALYSIS MS OFFICE 2.8 here, also in PDF version.
Hardware & Software requirements for Analysis, edition for MS Office see note 1466118.

For MS Office 2016 installations, refer to the SAP note below, which describes a known issue introduced by MS Office update:
→ [2670331 - Analysis Office Compatibility issues after Excel 2016 update

2 - Analysis for Office client tool

2.1 For the installation steps, check To install SAP BusinessObjects Analysis, edition for Microsoft Office
2.2 For silent installation / uninstallation, check SAP Front End Installation Guide.
2.3 For custom packages of Analysis for Office, check Configuring Files With SAP Setup
2.4 For checking the installation, run command ‘nwcheckworkstation’, as explained in Wiki page How to run the Installation check tool

Follow steps below to download the latest version of Analysis for Office:

• Access this page
  – For MS Office 32 bit, download file AOFFICE28SP15_0-70004974.EXE (SP15 Patch0 for ANALYSIS OFFICE CLIENT 2.8);
  – For MS Office 64 bit, download file AOFFICE28SP15_0-70004973.EXE (SP15 Patch0 for ANALYSIS OFFICE CLIENT 2.8);

Analysis Office Client versions

Future Release:

Currently there is no plan for a AO 2.9 release. Instead there will be frequent SPs for AO 2.8.
This will not have any impact on the support, which has been announced in the Product Availability Matrix until 2027.

Note that there is a component included in Analysis for Office tool, which is responsible for the communication with the backend. This component is called BI Consumer Service (BICS).
BICS 2.0 is used in Analysis Office until 2.4 BICS 3.0 is used in
Analysis Office from 2.5 onwards

Whenever opening in AO 2.4 version(or lower), a workbook that was saved using AO 2.5 or higher version, the warning message below will occur:
“XML stored with a newer BICS version (XML version 3.0, client version 2.0)”

It means that some issues might occur, since new versions can contain improvements and new functionalities.
Opening workbooks saved with 2.4 or lower version using AO 2.5 or higher version should never be aproblem. This is why the recommendation is to always use new and higher versions to open workbooks saved in old versions. See SAP note 2546926.

Currently the AO BIP ADD-ON is only available for Windows. There is no version available for others operating systems (e.g. Linux).

3 - Why test with latest AO patch?

3.1 Investing the time to locate the error which is already solved with current patch is not very useful. Thus testing with latest patch is very important.
3.2 We understand that AO patch cannot be rolled out to thousands of users every quarter/month. But it is recommended to install the latest AO patch on one test PC to test the issue.
3.3 Installing a new AO patch on a test PC is neither time consuming nor complicated. It takes less than 10 minutes.
3.4 If confirmed that the issue is solved with latest AO patch, then this will save a lot of time that is needed with incident creation (by customer) and analyzing the issue (by customer & SAP Product Support).
3.5 It is only possible to provide a correction based in the latest patch. Therefore, even if an error is occurring in lower patch, the solution cannot be provided for that lower patch.
3.6 in contradiction to ABAP correction, AO correction cannot be provided as code-snippets, thus the complete AO patch needs to be installed. Even if emergency hotfix patch is released, the solution will be a complete update of the AO patch.
3.7 Generally, multiple errors are corrected in each AO patch. Important errors are documented in SAPNOTE, but NOT ALL. This means that the issue might be already solved in the latest AO version but no SAPNOTE is available.