Skip to Content
Product Information
Author's profile photo Tammy Powlas

SAP Analysis for Microsoft Office Road Map Webinar Recap



Source: SAP

Last roadmap webinar for 2018!


Source: SAP

Working on fixes; moved new release to Q2 next year


Source: SAP

Legal disclaimer applies; things in the future are subject to change


Source: SAP

Moving to the cloud


Source: SAP

Main use cases for Analysis for Office


Source: SAP

“already converged” client


Source: SAP

Have a query, add some calculations, restricted measures, so you don’t have to go back to the query

Axis sharing/table grouping – if you have 2 crosstabs and want to make them a single one and link the data

SAP GetData functionality – the sales value for region/year

New mode for SAP GetData, refresh, regenerate from back end


Source: SAP

You can add master data planning with 2.7


Source: SAP

(just covered in OpenSAP BW/4HANA course)


Source: SAP

Deployment options

Integration into SAP Analytics Cloud


Source: SAP

SAP Analytics Cloud is a strategic product

Scenarios are above; VLOOKUP for connecting 3rd party data, more sophisticated formatting, offline use case


Source: SAP


Source: SAP


Source: SAP

Options to do more in an Excel environment


Source: SAP


Source: SAP

GA since June 2018


Source: SAP

Q2 2019 – intensify integration with SAP Analytics Cloud

Live connections with BW is planned

Planning – add actions, create new data

Connect to Analytics Cloud repository

Support MS Office 2019

Support cloud based S/4HANA; now can only connect to on-premise using RFC technology

SAP GetData enhancements for hierarchies

Repeat headers in crosstabs – many want to do this

(updated last week)

Further out – continuous improvement for planning, asymmetric reports – generic product vision further out


Q: Sometimes with Query Designer sometimes refresh

A: With Analysis Office, remove close connection with BEx Query Designer; give end user more options in tools

Give more to end user

You can still jump to query and change something and refresh

Q: Broadcasting workbooks in BW/4HANA

A: Only doing this via the BI Platform; this provides the services

BW/4HANA does not have the complete NetWeaver structure

Q: Conversion of IT workbooks – from Analyzer

A: option to convert existing workbooks; some services from SAP COE to do mass conversions of workbooks – possible by a service

Q: When will Analysis Office 2.8 be available?

A: Plan is Q2 next year


What do you think?

Assigned Tags

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


      Thanks for great summary.

      Was there any mention of Universe connectivity in v2.8?

      I am sure I have seen it on the previous Road Map, being planned for v2.8

      Was there any reasons given for the delayed release of v2.8 (was expected Nov-18)?


      Many thanks, Lukasz

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

      Hi Lukasz - I don't see Live Office listed on the Analysis Office roadmap


      I'll let SAP answer themselves about the 2.8 release - as you know everything in the future is subject to change.  You can also ask at this upcoming webcast - BI: What's new in Analysis Office? - register with your email address.

      Author's profile photo Giulia Martielli
      Giulia Martielli



      I still don't see any Universe Connectivity feature on the roadmap nor in any other mentions on the web.

      I am sure I have seen it in the previous roadmaps -->


      Did you have any answer about it from SAP?


      Thank you.



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

      Hi Giulia - I don't work for SAP but for universe access I believe they recommend using Live Office

      Author's profile photo Vadim Zaripov
      Vadim Zaripov

      I wonder, with SAP's ever growing partnership with Apple, why we still don't have AfO for MS Office on Mac?

      Is there a particular reason?

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

      Hello Vadim - thank you for reading and commenting

      This is a good question for SAP; I recommend asking it at (I don't work for SAP)