Skip to Content

Alexander Peter, Product Owner for Analysis Office, provided this webcast to ASUG yesterday.

Since the discussion covers future versions, this is subject to change.


Figure 1: Source: SAP

Figure 1 shows that BEx tools are in maintenance mode.  There is not an immediate need to go off BEx clients but no new innovation.

Innovation comes with the Analysis clients.

Content with BEx Analyzer – conversion support exists today in Analysis Office.


Figure 2: Source: SAP

Analysis 1.4 release is smaller than 1.3 as SAP focused on improving performance.  SAP launched a performance project to review performance challenges from end to end. 

Alex said there are two collective notes to help you identify things on backend to streamline communication between server and client.

Main feature was broadcasting on BI Platform, another gap for BEx Analyzer– for legal reasons can’t release GA .  SAP chose the BI platform to use the scheduling features.  Broadcasting is planned for Q3.

GA for 1.4 is planned for May.

SAP has enchanced interoperability with Design Studio – in 1.3 you could copy a data source and insert it in Design Studio.  Now it is extended to be an automatic transformation to Design Studio – crosstab, chart, and components into an iPad application.  The scenario is to have a prototyping tool in Analysis Office and can use it to prototype a dashboard.

Strengthen BI platform support – if you store it in Launchpad ad start it from the Launchpad – before only Excel opens.  It didn’t know about Analysis Office workbook.  SSO wasn’t honored.  Now solved in with Analysis Office 1.4 and BI4.1 platform

Waterfall charts not available in native Excel so they have added them to the toolbar in Analysis Office 1.4.

With the ASUG Influence Council, SAP prioritized features.  After broadcasting query designer was a the top. 

You can open the Query Designer from Analysis Office 1.4 .  You can reset data source to query designer

With the read mode feature you can change from reading from the cube or the master data.

Time-dependent hierarchy at the given key date is now available in 1.4.

Data refresh – before 1.4, when press refresh, render cross tabs but not show the latest data – re-rendered data – had to leave Excel and open it again.  With 1.4 have a real data refresh.

They have added a member selector for mass data


Figure 3: Source: SAP

Figure 3 was not covered during the webcast, but it gives you an overall direction.  Today is version 1.3, planned innovation is Analysis Office 1.4.

Subset of Q&A:


Q: Will AA 1.4 allow us to create or design Queries in BW?

A: The Query Designer remains the tool to create queries in BW.‑


Q: Will AA 1.4 finally have LogOn / LogOff button?

A: No plan for a logoff button… but I am aware that AA can hold onto connections for an extended period so this issue is being investigated.‑


Q: is it possible to connect to Essbase cubes directly?

A: Not from Analysis Office‑

A: … but Yes with Analysis OLAP‑

Q: is AA 1.4 compatible with BOBJ 4 SP5?

A: It is platform independent‑


Q: What is the comparability of AA 1.4? We are on BI 7.0 and BOBJ XI3.1 sp 3.

A: It is platform independent – there are some features dependent on BW version but overall it is platform independent.‑


ASUG Annual Conference

Alex is presenting at ASUG Annual Conference regarding the ASUG Influence Council.  Below is a list of other ASUG Analysis-related sessions for the conference:

To report this post you need to login first.


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

  1. John Coudriet


    we have started reviewing BOA and noticed it is on the slow side in prompt screen and I noticed release 1.4 has performance improvements.   Would these improvements cover the prompt screen?

    1. Tammy Powlas Post author

      Hi John – I don’t think Alex went into that level of detail.

      Would you please post this on the discussion area and hopefully someone from SAP will reply?



  2. Former Member

    Thanks Tammy.

    Unfortunately AAO still haven’t good RRI with ERP systems, only with web-GUI, instead Bex.

    Alex please fix this situation, because it’s showstopers.

        1. Tammy Powlas Post author

          I am pretty sure as we saw Alex Peter from SAP present this last week at ASUG Annual conference

          .UNX support for Analysis Office is not in the 1.4 release – see Figure 3 above – it is in Future Direction (DSL)

          1. Former Member

            ok, supporting unx universes in A-Office – next logical step, and it will significantly extend A-Office posibilities.

            And will promote the popularization of BO BI products!

  3. Former Member

    Hi Tammy,

    In your note above you mentioned that Alex talked about collevtive notes for performance. – do you thave the Note Numbers handy



    1. Tammy Powlas Post author

      Hi Srinivas – I don’t have those; perhaps take a look at OSS and search under the Analysis Office component?



  4. Former Member

    Can Analysis Office be used with non SAP datasources or SAP Business Suite applications, other than SAP BW?  If so where can additional information be found.  Thanks.

  5. Former Member

    Hi Tammy,

    This is a great update.

    As it says Analysis for office 1.4 will be available from 3rd Quarter, is it available now?

    Out client is looking for option of Broadcasting of workbooks using Analysis for MS Office.



    1. Tammy Powlas Post author

      Analysis Office 1.4 is available now (SP3) but broadcasting is not yet available – that is coming to BI4.1 through a feature pack, planned for some time in Q4 of this year

  6. Former Member

    Hi Tammy,

    is it possible to surpress messages upcoming from the left corner(warnings, information message,…). It is friendlier for the user. Is that available like in BEx Analyzer under Global settings  like Display messages automatically and only if it is clicked you will get the messages prompted.

    Thanks ind advance for your reply.



Leave a Reply