Analysis for Office 2.1 SP2 on SMTP
As some of you know, SAP delivered Analysis for Office 2.1 SP2 on SMTP today and we will have some interesting correction on the support package.
The performance and tuning are the two topics most important on my opinion, as we need the information faster as we can to take decisions.
The SAP notes below explain the correction for performance and tuning delivered with 2.1 SP2, starting with performance tuning when using formulas SAPGetData, SAPSetVariable, SAPSetFilter:
2196082 Performance Tuning – SAPGetData
2172656 Performance Tuning: SAPSetVariable
2166895 Performance Tuning: SAPSetFilter
And related to formulas, when you were running a workbook with some non AO formulas, you had a performance delay and it got fixed by the SAP note:
2201473 Long initial loading time of workbooks with many sheets containing non AO formulas
Other two notes that I consider important when thinking on performance, you can check below:
2207583 AO 2.x: Improve performance when using copy&paste for planning queries data cells
2161226 Analysis Office: unnecessary calls when opening document from BIP
We also got some corrections related to the launcher, SSO and BIP connections as described below:
2205238 Launching a document from BIP does not work
2204798 Password change of NetWeaver user not accepted
2205436 Analysis Office: error on opening workbook when document caching is used
2201633 First time SSO logon prompts for user and password
2195816 Launching Open Dialog leads to an exception with the message “Root element is missing”
2192668 AO 2.1: Automatic SSO logon to BIP for workbooks containing data sources located on the BIP
2196610 Password change functionality not available in Analysis Office with SAP HANA Info Access Service (InA)
2179383 Launch BEx Query Designer functionality in Analysis Office fails
2175698 Launcher: A document with the same name is already opened.
For any delivered date question, you can refer to SAP release schedule note below:
1518359 SAP BusinessObjects Analysis Office & BIP Add On Release schedule
For more correction delivered on Analysis for Office 2.1 SP2 can be found at the SP note 2164363.
I hope that this can help.