Skip to Content

Hi All,

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.

Diego Ferrary

To report this post you need to login first.

10 Comments

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

  1. Michael Tocik

    Hi Diego,

    Thank you for the article very useful.

    Some of the notes you mention are not yet released.

    2172656

    2166895

    Any idea when they will be available?

    (0) 
  2. Lynn Peter

    Thank you Diego for the informative article. 

    We have downloaded the new support pack for a few of our testers and when we exit Excel (we are on version 2010) it crashes. I have logged a ticket with SAP support. Has others experienced this that you are aware of?

    (0) 
  3. RAKESH KHATAI

    Hi,

    I installed the AA 2.1 SP02. As per the user guide the the Worksheet Type option is no longer in Sheet Options but in the EPM Pane. But I do not see the Sheet Options in the EPM Pane.

    Capture.JPG

    (0) 
  4. Sunil Narahari

    HI Diego,

    We are unable to see the Save Data button or recalculate in AO 2.1. We have not yet installed SP2.

    The input form opens in change mode and allows us to insert data. however, we have no option to save data. Currently when I try to close the worksheet, I get a prompt to save data and it does save it.

    Regards

    Sunil

    (0) 

Leave a Reply