SAP Analysis for Microsoft Office Road Map Webinar Recap

[TammyPowlas]

 



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&A

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?