Product Information
SAP Analysis Office + SAP Analytics Cloud add-in for Microsoft Office Road Map Updates
This was from a webcast last month. The usual legal disclaimer applies; things in the future are subject to change.
Below are some notes
Source: SAP
What is needed for do-it-yourself analytics, according to SAP:
1. Quick access to any data. Relational, OLAP, unstructured, cloud, etc. and the ability to clean the data and transform it to apply to business scenarios.
2. Need to be able to explore and understand the data to find hidden insights, looks at the data in different ways, find out what things influence business outcomes. Need to be able to communicate our findings out to other people in the form of tables, visualizations and stories.
3. Need to use that data to plan and predict the next steps. Need to quickly understand the best next course of action, and how those actions (and different actions) may affect business.
And we need this all in one place in an integrated experience that is super fast and agile.
SAP feels they are close to releasing features in the cloud that brings all of this together in a single, turn-key experience for anyone. (source: SAP)
Source: SAP
SAP Analysis Office has more than 1 million users
SAP wants to work on quality and stability
What I also learned in a webcast last week is that Analysis for Office is built in .NET technology which is in maintenance on the Microsoft side.
Source: SAP
SAP Analytics Cloud, Add-In for Microsoft Office is SAP’s primary MS Office planning front end solution moving forward
Source: SAP
Mass data entry mode – helps in performance
Sort members in the grid
Future – Q1 – ranking
Smart member selector
Deliver every 4 weeks
Subset of Question & Answer:
Q: What about analysis office publications, email distribution to non-SAC users? We send thousands of emails with excel attachments to external users. How do we do this going forward without BI platform?
A: SAC backend you can use scheduling, but not with excel, schedule stories and export pdf but not excel. Not planned for SAC.
Q: Is there BexGet support on the Cloud version? How to migrate complex workbook content. Yes we still use bex analyzer workbooks too
A: Not yet, the migration from Bex to Analysis Office needs to be done, it is a part of SAP road map, hoping for May or June.
Q: Will there be SAP Data Warehouse Cloud support for AO (Analysis Office)?
No, it was on the road map but SAP removed it, because now SAP really wants to support DWC (Data Warehouse Cloud)with this new SAC add-in. Not with AO.
Q: Will there be any additional enhancements to AO Desktop? For example, the ability to filter based on measures or advanced sorting with native HANA is sorely missing (like we can do with BEx today).
A: Yes, you may have seen the few enhancement plans for AO. SAP will continue to develop feature reading. It will be 1 or 2 maximum features per year. The development has not stopped.
Related:
Also please join me in March for SAP Insider’s Data & Analytics 2021.
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.
Dear Tammy,
Upcoming improvements to SAC MS add-in for cloud sounds very promising and for us, designers, will save us a lot of time. However, I don't find a way to save an Excel workbook on SAC tenant that I can later reference inside a Calendar Task. It should be automatically logged in and the context should be passed from the Calendar Task ( as the old BPC does). This feature is key for planning processes, otherwise, even though you guys improve the add-in, there's no way to connect it to the tenant. Do you think this feature is in the roadmap? if it is, could you estimate a delivery date for it?
Thanks & Regards,
Natalio Pluzzer
Hi Natalio - I don't work for SAP; I am a customer. Regarding the features, I recommend submitting an influence request at influence.sap.com
I forgot to add - thank you for reading and commenting.
My bad Tammy,
My apologies!
Regards,
Natalio.
Hi! I can't find any information related to the Analysis for Office in the roadmap. There is only information about the SAC, add-in for Microsoft. Could you please let us know which is the vision and strategy of SAP on the Analysis for Office? Where can you see its roadmap?