Skip to Content
Product Information
Author's profile photo Steffen Heine

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.

What’s next?

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.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Frederic Cincet
      Frederic Cincet

      Liked and shared. Thanks.

      Author's profile photo Shailendar ANUGU
      Shailendar ANUGU

      Nice Blog Steffen!!

      Author's profile photo Shamsi Anis
      Shamsi Anis

      Hi 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.

       

      Thanks

      Anis Shamsi

      Author's profile photo Steffen Heine
      Steffen Heine
      Blog Post Author

      Hi Anis,

      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, Steffen

      Author's profile photo Shamsi Anis
      Shamsi Anis

      Hi Steffen,

       

      Thanks for reply.

       

      Awaiting for contact.

       

      Thanks in advance.

       

      Regards

      Author's profile photo Jerry Janda
      Jerry Janda

      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.

      Kind regards,

      --Jerry

      Author's profile photo Shamsi Anis
      Shamsi Anis

      Noted with Thanks.

      Author's profile photo Mike Schiebel
      Mike Schiebel

      Hi,

      on step before (Select Datasource) you have to switch to the "Tree View".
      Icon on the top right.

      Kind Regards

      Mike

      Author's profile photo Mihir Jha
      Mihir Jha

      Hi Steffen,

      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 ...

       

      Any help?

      Best regards, mihir

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      Nice information!

      Author's profile photo Reinaldo Abe
      Reinaldo Abe

      Thanks for blog.

      Is this part of SAC license bundle (BI, Planning standard/professional)?

      Author's profile photo Harald Anton Mueller
      Harald Anton Mueller

      Hi Steffen,

      is there any update to the "save-workbook-to-cloud-tenant" functionality you mentioned. Is this possible now? Thanks!

      Regards,

      Harald

      Author's profile photo kevin gu
      kevin gu

      Hi  Steffen,

      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!!!