Take advantage of SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud
Already a while ago we introduced the SAP Analytics Cloud edition of SAP Analysis for Microsoft Office, our popular Microsoft Excel and Powerpoint add-in. This edition is compared to the full edition limited regarding the SAP BusinessObjects platform, SAP BPC and EPM capabilities, but it allows everyone to use it as part of the SAP Analytics Cloud license including all core analysis functions.
This enables SAP Analytics Cloud users to analyze and visualize their data directly in Microsoft Excel and enrich it with Excels well known formulas and functions. Since the SAP Analysis for Microsoft Office 2.8 release it is not only possible to explore acquired data models, also the live connections such as SAP BW, SAP HANA or SAP S/4HANA can be accessed. With the latest 2.8 SP2 even SAP BW releases less than 7.5 SP16 are fully supported.
5 steps to get started:
1. Configure your direct live connection in SAP Analytics Cloud:
2. Download and install the latest SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud: Link
3. Start Microsoft Excel and select the Analysis tab. Insert a data source for analysis and per right click create a new connection to your SAP Analytics Cloud tenant. Make sure to enable the live data connection checkbox:
4. After logging on to SAP Analytics Cloud you will find the direct live connections of the tenant:
5. Double-click on it, authenticate at the source system, search for your favorite BEx query, ABAP CDS or SAP HANA calculation view and start analyzing:
Details about using SAP Analysis for Microsoft Office we provide in our User Guide. Further technical information you can find in the Administrator Guide.
Of course, users also want to save and share their insights with others. Currently it is only possible to save the workbook via the Microsoft Excel standard options. Our next goal is to save workbooks directly in the SAP Analytics Cloud file repository and make use of the collaboration, security and sharing functions SAP Analytics Cloud is providing.
Liked and shared. Thanks.
Nice Blog Steffen!!
Thanks for nice Blog, i follow the same but got stuck at last step, i can't find my data cubes or any detail, can you please help me how to find or which step i am missing.
looks like the SAP Analytics Cloud logon worked well, just the models/queries are not showing up. Couldnt find an email address in your profile, so could you please send me a personal message with more step-by-step details please.
Thanks for reply.
Awaiting for contact.
Thanks in advance.
Inclusion of a personal email address violates our rules of engagement, so I had to delete that from your comment.
To message Steffen, please go to his profile, follow him, and once he follows you back, you'll see a "contact" button on his profile. Clicking on that will allow you to message each other.
Noted with Thanks.
on step before (Select Datasource) you have to switch to the "Tree View".
Icon on the top right.
The link to download the software plugin in step 2 is not showing up anything , please be noted that i have S user account with enough software download rights ...
Best regards, mihir
Thanks for blog.
Is this part of SAC license bundle (BI, Planning standard/professional)?
is there any update to the "save-workbook-to-cloud-tenant" functionality you mentioned. Is this possible now? Thanks!
i found an update of AO 2.8 for multiple value filter in the same dimension. i want to know how to use this function。 thanks!!!