Skip to Content

What is new in Analysis Office 2.3 – ASUG Webcast Summary

This was an ASUG webcast given by SAP yesterday

As always things in the future are subject to change


Source: SAP


Figure 1: Source: SAP

Figure 1 shows what is new in Analysis Office 2.3

There is a new Table design rule editor

Enhancements for BW – Report to Report Interface framework, with Analysis Office as a receiver so you can jump from Design Studio to Analysis Office.

Dynamic RRI targets are enabled.

API enhancements include save data back to planning backend

Cancel log running queries

Full dpi support – size of characters

Logoff button to logoff system, particularly for testing reasons

Additional refresh mode – to include new master data in refresh

You can upload a list of filter values from a file


Figure 2: Source: SAP

Table Design Rule editor – there is a new tab for the rules and you can filter and edit some of them.


Figure 3: Source: SAP

For only BW 7.50 SP4 due in July, you can create restricted measures in the client.

You can define a measure and a filter condition in the dialog


Figure 4: Source: SAP

You can cancel long-running queries; 5 seconds is the default

You will get a pop-up to cancel the query


Figure 5: Source: SAP

You can logoff from the components tab

It is hidden as SAP considers it a more of a technical button

You can also replace a system here (last entry)


Figure 6: Source: SAP

The roadmap will be updated after 2.3 is GA

2.3 features are shown in the middle column of Figure 6

Plans for the future- create restricted measures in an easier way; possibly combine queries and create butterfly reports

Also looking to do things around grouping – personal grouping

Sheet protection is being worked on for the Q4 release

Also working on commentary framework with cell-level comments

Question & Answer

Q: Contains a Plug-In for EXCEL & POWER POINT. An Date/Roadmap when we wil be able to embed into WORD documents..? Timeline to move all former BOBJ LIVE OFFICE functions into Analysis Office..?

A: See current slide -to be fixed in later release

Q: Just curious why is LiveOffice not listed?

A: That is part of future convergence – today’s webcast covers 2.3, the next release.

Q: We do not use BPC, to use 2.3 do we need to be on BW7.4 SP15 or BW7.5 SP4? Or will it work on our current 7.3 version?

A: It should work on current 7.3 version. The Version listed was for embedded – so if you are not planning it is not required

Q: What does “Upload list of filter values” mean?

A: Upload from a text file to a filter

Q: If you upgrade to A4O 2.3 on the destop, should you also upgrade the A4O BIP server add-on to version 2.3? What versions of BIP does the A4O BIP server on-add support (for example, is BIP 4.1 SP6 compatiable with the A4O 2.3 BIP add-on)?

A: Minimum BI4.1 SP5 or 6 – not sure

Q: Have you seen issues of using the plug-ins with Excel 2013?

A: issues should be shared with SAP Support.

Q: Upgrading users to most recent version of Analysis for office require someone typically user with admin rights doing installation, executing .exe files. I am wondering if new version of Analysis Office offer automatic upgrade options to most current vers

A: No, not yet

Q: Do the plug-ins support SSO kerberos authentication?

A: yes, couple of SSO protocol – depends on what asking – from BI to HANA – no, only SAML

Q: We are using standard bpc 10.1 and analysis for bw. If we upgrade to 2.3, we still have these tool separate or we can use the combined tool

A: No separate installation

Q: does 2.3 is going to support office 365 or 2016?

A: supported in 2.2 latest SP

Q: What is a SAP strategy regarding publishing AO Workbook if we have SAP BW and BO Platform? If it depends on AO licence?

A: not sure of question – scheduling is available on BI platform

Q: Can we use AO for BO Universe?

A: Not yet – use Live Office

ASUG Annual Conference Sessions next week:

A3748 ASUG Influence Council: SAP BusinessObjects Analysis
A3916 A3916 The Walt Disney Company’s conversion from BEx to BusinessObjects Analysis
A3755 A3755 SAP BusinessObjects Analysis Office – The Converged Road Ahead


Take the BARC Survey: Take the BARC BI Survey 2016 – Chance to win Amazon Vouchers

You must be Logged on to comment or reply to a post.
  • Wow, this is one of the rare releases where I am looking forward to all new/planned features!

    I will definitely go for it in CW 21.

  • Great to see the long awaited and much requested Cancel and Logoff buttons! Although why the Logoff isn't actually a button on the ribbon bar like the EPM version I don't know!! Currently the only way to log off the BW / BO connection is to close the entire Excel session - closing the workbook has no effect. Still, beggars can't be choosers... 🙂

    • planned for CW 21, refer to my first comment.

      Trial version? I think you have to be part of the beta program to test it before GA.

        • Ramp-Up's are available here but there are no active ones for Analysis at the moment.

          CW is Calender Week 21 - so some time week commencing 23rd May. It did say in the presentation the end of May...

  • AO 2.3 seems to be available via the SMP. The documentation (user guide, administrator,..) is not yet available. I am still try to figure out if all fixes of 2.2 SP3 are included in 2.3.



  • Deploying A-Office to all our users in a large global enterprise organisation is tricky to do all at once.

    Are there any compatibility issues between reports saved in 2.2 v's 2.3? If I were to save a report in 2.3, would we notice any issues for a user still running 2.2 if they open that same report?

    This question is around both A-Office and EPM

    Many thanks,


  • Hi Tammy,

    I use EPM and analysis regularly but I've no idea what is meant by "new user experience for planning formulas"... could you give me a hint?



  • /
  • Any idea why that link doesn't work? I am trying to review the new features of 2.3 via interactive tutorials and videos. In the past that link has worked. Thanks!

  • Carter - there are still open issues migrating documents; in the meantime try to find it using a cache.  You can report this as an issue at using the "Using SAP' tag