Skip to Content
Author's profile photo Tammy Powlas

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Daniel Klein
      Daniel Klein

      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.

      Author's profile photo Stephen Hobbs
      Stephen Hobbs

      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... 🙂

      Author's profile photo Cathy Moore
      Cathy Moore

      You can disconnect from Analysis by going to Developer tab > COM add-ins and unchecking the Analysis box

      Author's profile photo Stephen Hobbs
      Stephen Hobbs

      Yes, very true! But try training a user to do that. Logoff / Disconnect option has been around since BEx 3.5 so well overdue...

      Author's profile photo Mansi Dandavate
      Mansi Dandavate


      What is the planned GA date for Analysis for Office 2.3.

      Also when will the trial version be available for us to try the new features ?

      Author's profile photo Daniel Klein
      Daniel Klein

      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.

      Author's profile photo Mansi Dandavate
      Mansi Dandavate

      Hi Daniel,

      I did not get what you meant by CW 21 ?

      Also do you know how can I be part of the beta program.



      Author's profile photo Stephen Hobbs
      Stephen Hobbs

      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...

      Author's profile photo Former Member
      Former Member

      I tried CancelPopupDelay but that doesn't work. Does it work for anyone else?

      Author's profile photo Joost Peeters
      Joost Peeters

      Hi Steffen,

      how did you get hold of a copy of version 2.3?

      As far as I know it will only be released next week.

      Best regards,


      Author's profile photo Michael Hamm
      Michael Hamm

      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.



      Author's profile photo Former Member
      Former Member

      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,


      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      James - from my side, it is too soon to say or comment on this.  I would give it a few days

      Author's profile photo Christian Sass
      Christian Sass

      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?



      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      Is it possible to connect the EPM plug-in directly to a SSAS Cube? I saw this feature in the PAM...




      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Damian - I am not using the EPM plug-in; I recommend you create a new discussion

      Author's profile photo Former Member
      Former Member 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!

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      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