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

Extending the reach of SAP Analytics Cloud Data with Microsoft Office front end Webinar Summary

Figure 1 Source SAP

SAC = SAP Analytics Cloud

AO – SAP Analysis for Office

Figure 2 Source SAP

The legal disclaimer applies; things in the future are subject to change.

Figure 3 Source SAP

SAP Analysis Office is an on premise product

Two editions of SAP Analysis Office – differences are based on the license

Different PAM’s and different connectivities

Use SAC AO, cannot access BW

Figure 4 Source SAP

Focused on quality and stability; it is a mature product

Invest on SAC live connectivity

Future direction – want to remove differences AO Standard and AO SAC

Store on SAC repository – planned

Figure 5 Source SAP

Plans for H1 this year

Improve AO for SAC edition and reduce gap with standard edition

Access to repository, BW repository – connect to SAC, reopen workbook, or migrate from BEx to AO using AO for SAC

Retrieve document from BI Platform after logged on to SAC

Future direction – store workbooks on SAC repository

Figure 6 Source: SAP

Available for online version of Excel and desktop

Supports Windows and Mac

Later support different devices like the iPad

Integrated with SAC; integrated with processes from SAC

Today support SAC models on acquired data

Workflow starts in Excel, access model, create workbook

Based on MS Office strengths; part of SAC subscription

Available for BI/Planning SAC customers

Figure 7 Source SAP

Part of SAC license

Not intended to replace Analysis for Office

To obtain this add-in tenant needs to be on Cloud Foundry

Figure 8 Source: SAP

Figure 9 Source SAP

Figure 10 Source SAP

Product is new, GA last May

Features are delivered every 4 to 6 weeks

Q1 this year:

For planning – unbooked data (plan on a new product) – plan to deliver in 2 weeks to customers

Keep formula – Excel formula

Member selector enhancements – search for member if you have a large dimension

Support ranking – top 10 customers

Q2 this year – “SAPPHIRE” time frame

New universal model – new SAC planning model – want to read this model in Excel

Currency – show default/local

Flexibility to retrieve data – GetData – focus on data to retrieve

Option to repeat members, useful if you want to create pivot tables

Plan to offer keyboard shortcuts for faster data entry

Future direction

Support planning comments

Execute data actions

Asymetric reporting – fine tune what you would like to see

Integration with SAC story

Platforms – connect to live sources (can’t do it today) – plan to support SAP Data Warehouse Cloud as a live data source

Figure 11 Source SAP

Positioning – AO is a mature product, several customers, remains key part for SAP, key add in for BW, BPC, S/4HANA on premise; not plan to invest in new capability

For SAC planning scenarios, do not recommend AO; recommend using add-in for MS Office

This add-in is not a successor for SAP AO

For a guided solution, use SAC Analytics Designer

____________________________________________________________________

Replay: https://event.on24.com/wcc/r/2976910/8D9185310C9BEB0DFBE239D7A40C7D5D

Slides https://on24static.akamaized.net/event/29/76/91/0/rt/1/documents/resourceList1554139728268/webinar.pdf

Related:

*Free* pass to SAP Insider event next month: SAP Insider’s Data & Analytics 2021 (and S/4HANA and Cloud Administration).

Link: http://bit.ly/3o6PRR9

To join for free, use code POWLASPASS (case sensitive)

To use the code: Select the “All Access Pass” option on the registration page. Complete the form and click “Next.” There will be a second summary page, click next. You’ll be automatically directed to a third page where you can input my personal code under discount code and be granted full access to the event at no cost

_________________________________________

Learn more in SAP’s Ingo Hilgefort  new book, Mastering SAP Analytics Cloud, Empower your Business Users, is now available at Amazon.  It’s a comprehensive book, 991 pages long, covering personas. tutorials, how to use it, how to use it with other SAP products.  I highly recommend this book.  It covers this product as well.  It also includes certification tips for SAP Analytics Cloud.  I posted a review here.  Ingo covers the SAC add-in for MS Office in this book.

 

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.