FAQs - Extending the reach of SAP Analytics Cloud ...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
This blog post will answer the FAQs from the webinar “Extending the reach of SAP Analytics Cloud with Microsoft Office front ends” presented and answered by Jeanne Bigonnet. This webinar presented the new add-in for SAP Analytics Cloud to connect with Microsoft Office applications. For a detailed presentation and demonstration, please watch the webinar here.
Q:How does this add-in compare to Analysis for Office? When should we use them?
A: You can find a detailed answer in the last part of the following blog.
Q: Is there any compelling reason for an existing SAP Analysis for Officestandard edition customer to move to or utilize SAP Analysisfor OfficeSAP Analytics Cloudedition?
A: If you’re already using SAP Analysis for Officestandard edition, there is no need to change your version. Using SAP Analysis for Officefor SAC edition is useful for SAP Analysis for Office netnet customers who are wanting to only connect to SAP Analytics Cloud as a data source.
Q: What are the options of connecting to S/4 OP, Cloud, and BW4HANA?
A: S/4 Cloud connectivity is currently not supported – please visit theSAP Analysis for Office road map in the webinar. For S/4OP or BW4HANA you can use SAP Analysis for Officestandard edition, as described in thisblog.
Q: Which Analysis for Office Version do I need to have to connect Analysis for Officeto SAP Analytics Cloud?
A: You can use SAP Analysis for Officefor SAP Analytics Cloudedition if you are only connecting SAP Analytics Cloud as a first entry source, or you can use SAP Analysis for Officestandard edition if you’re connecting to different BW/HANA and SAP Analytics Cloud sources.
Q: When will the customers be able to store and to schedule Analysis for Office report publications on the SAP Analytics Cloud platform?
Q: Does this new add on come with SAP Analytics Cloud licenses?
A: Yes, it does.
Q: How can I access this add-in?
A: Please seethe“Deploy the Add- in" section of this webpage.
Q: What versions of excel will the add-in work with?
A: The add-in will work with on Excel desktop apps (on both Mac and Windows) as well as on Excel Online. For supported versions, please see this page.
Q: Can I export data out of SAP Analytics Clouddirectly to Excel or do I need the SAP Analytics Cloud Analytics for Officeadd-in to do that?
A: Currently, the workflow starts with the Add-in in Microsoft Excel365, where you connect your SAP Analytics Cloud tenant and select your model (acquired data) to create your table.
Q: Can you blend the data from multiple models into a single report using this add-in?
A: Currently, it is not possible to insert different models in the same sheet, but you can create a workbook with different models on different sheets and blend it using Excel capabilities.
Q: Can the current version of either excel add-ins (Analysis for Office or SAP Analytics Cloud add-in) use a save data formula to specify the intersection to save the data to?
A: Using SAP Analysis for Office with BPC or BI IP you can use this formula. It is currently not supported on top of SAP Analytics Cloud, however, we have it in our road map for SAP Analytics Cloud Add-in in thelong-term direction.
Q: Is it possible to run Analysis for Officefor Microsoft and the SAP Analytics Cloudadd-in for MicrosoftOffice on the same device at the same time?
A: Yes, this will work as they are based on different technologies which will not interfere with each other.
Q: Where does the SAP Analytics Cloud Data Analyser stands when compared to the new SAP Analytics CloudExcel add-in? Are there new developments for the Data Analyser?
A: The SAP Analytics Cloudexcel add-in product states in the MicrosoftExcel environment on premise and on web version.
Q: Can we presently save an Excel report using the SAP Analytics Cloud add-in to be saved into the SAP Analytics Cloudrepository?
A: There is no direct capability to store workbooks in SAP Analytics Cloud repository for now. We have it in our long-termroad map, but for now, you can store it on a shared drive.
Q: Is it possible to create hierarchies and define formulas in Excel to reflect in SAP Analytics Cloudusing Analysis for Office?
A: In SAP Analysis for Office, you can connect SAP Analytics Cloud data, retrieve the hierarchies created and create your own calculations on top of it.