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
- Installation step: To install SAP BusinessObjects Analysis, edition for Microsoft Office
NOTE: If using BW as platform, ensure that SAP GUI is installed in the client PC (see here how to install). Refer to chapter "SAP BW" under "Supported BI Platforms" in Administrator Guide.
- For Silent installation / uninstallation of client tool please see SAP Front End Installation Guide.
- For custom packages of Analysis for Office, see Wikipage Configuring Files With SAP Setup
- To check the installation run 'nwcheckworkstation' as explained at wikipage. How to run the Installation check tool
- See note 1518359 for Release schedule.
- Follow steps below to download the latest version of Analysis for Office:
- Access this page
-- For MS Office 32 bit, download file AOFFICE28SP09_0-70004974.EXE (SP09 Patch0 for ANALYSIS OFFICE CLIENT 2.8);
-- For MS Office 64 bit, download file AOFFICE28SP09_0-70004973.EXE (SP09 Patch0 for ANALYSIS OFFICE CLIENT 2.8);
Analysis Office Client versions
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.
|2.8 SP12||-||Planned (CW 47, 2021). See note 3051730|
|2.8 SP11||-||Planned (CW 39, 2021). See note 3051741|
|2.8 SP10||-||Planned (CW 30, 2021). See note 3051755|
|2.8 SP9||2.8.900.96586||Released (CW 23, 2021). See note 2993498 (Contains EPM Add-in SP38 patch 5. See SAP Note 3043664) - latest 2.8 version|
|2.8 SP8||2.8.800.96347||Released (CW 14, 2021). See note 2993475 (Contains EPM Add-in SP38 patch 4. See SAP Note 3011303)|
|2.8 SP7||2.8.700.95947||Released (CW 06, 2021). See note 2993485 (Contains EPM Add-in SP38 patch 3. See SAP Note 3001963)|
|2.8 SP6||2.8.600.95340||Released (CW 48, 2020). See note 2927196 (Contains EPM Add-in SP38 patch 2. See SAP Note 2954008)|
|2.8 SP5||2.8.500.94986||Released (CW 41, 2020). See note 2924400 (Contains EPM Add-in SP38 patch 1. See SAP Note 2951215)|
|2.8 SP4 patch 1||2.8.401.94659||Released (CW 35, 2020). See note 2959437|
|2.8 SP4||2.8.400.94350||Released (CW 31, 2020). See note 2924387 (Contains EPM Add-in SP38. See SAP Note 2920897)|
|2.8 SP3 patch 1||2.8.301.94265||Released (CW 29, 2020). See note 2948273|
|2.8 SP3||2.8.300.93887||Released (CW 22, 2020). See note 2917177 (Contains EPM Add-in SP37 patch 1. See SAP Note 2902111)|
|2.8 SP2 patch 1||220.127.116.11748||Released (CW 18, 2020). See note 2919308|
|2.8 SP2||18.104.22.168367||Released (CW 14, 2020). See note 2679436 (Contains EPM Add-in SP37. See SAP Note 2825503)|
|2.8 SP1||22.214.171.124864||Released (CW 05, 2020). See note 2679485 (Contains EPM Add-in SP36 patch 1. See SAP Note 2854019)|
|2.8 SP0||2.8.000.92058||Released (CW 48, 2019). See note 2679473 (Contains EPM Add-in SP36. See SAP Note 2778197)|
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 a problem. This is why the recommendation is to always use new and higher versions to open workbooks saved in old versions. See SAP note 2546926.
3 - Analysis Office Add-On for SAP BI Platform
- Installation step: To install the Analysis BI platform Add-On for Scheduling for the Analysis Plug-in
- See note 1518359 for Release schedule.
- Follow steps below to download the latest version of Analysis for Office BIP Add-On:
- Access this page with the latest version of AO BIP ADD-ON in SAP Software Center
-- Download the file BIPADDON09_0-70005071.ZIP (SP09 for ANALYSIS OFFICE BIP ADD ON 2.8)
Currently the AO BIP ADD-ON is only available for Windows. There is no version available for others operating systems (e.g. Linux).
4 - Why test with latest AO patch?
- 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.
- 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.
- Installing a new AO patch on a test PC is neither time consuming nor complicated. It takes less than 10 minutes.
- 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).
- 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.
- 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.
- 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.
5 - SAP Ramp-Up
Ramp-Up is SAP's early adoption program for customers who want to go live with SAP's software innovations as soon as possible. For more information about it click here. Any issue accessing Ramp-Up version of software on the SMP, please log a message under Component: XX-SER-SAPSMP-SWC.
Link to this page: http://wiki.scn.sap.com/wiki/x/j41IGQ