Skip to Content
Product Information
Author's profile photo Jeanne BIGONNET

Announcing SAP Analytics Cloud, add-in for Microsoft Office!

We’ve combined the best of Microsoft Excel and SAP Analytics Cloud.

 

The SAP Analytics Cloud, add-in for Microsoft Office is now generally available.

Many businesses tell us that one of the biggest challenges with their data is having no single source of truth, but they still use the Excel interface every day. Why not have the best of both worlds?

 

Introducing the new SAP Analytics Cloud, add-in for Microsoft Office. We have partnered with Microsoft to co-innovate on the Office 365 suite, opening a playground for you to plan, analyze, and simulate your data.


“SAP Analytics Cloud is one of the first major enterprise planning applications to have a seamless integration with Excel for web and desktop in the Office 365 Suite. This exciting partnership brings together the best of Excel and SAP Analytics Cloud for customers.”

– Brian Jones, Head of Product, Microsoft Excel

You can now choose your preferred interface while having all the benefits of SAP Analytics Cloud with no additional cost. All you need is an SAP Analytics Cloud license and you can easily download the add-in today with no maintenance required.

ENGAGE ONLINE OR ON DESKTOP*

Planning and analyzing data can be challenging when you are doing it in silos. With the tightly integrated Office add-in with SAP Analytics Cloud, you can collaborate at work, at home, or on the road with the ease of switching to an online or desktop version in Excel. Use your choice of Mac or PC platform. Aligning plans and having deeper analysis with a single source of truth in SAP Analytics Cloud has never been easier.

PLAN, ANALYZE, AND SIMULATE

Make timely, data-driven, and more confident decisions in a familiar Excel experience, while incorporating powerful analytics tools to make plans, budget, forecast, and simulate future outcomes on multiple versions. Simply interact with your data and save it back into SAP Analytics Cloud planning models. Experience the power of data-driven decision-making in one place.

LEVERAGE YOUR DATA FROM SAP ANALYTICS CLOUD

With the freedom to drill down, expand, and filter your SAP Analytics Cloud data in Excel you can build custom calculations with external data, expand hierarchies, generate ad hoc reports and intuitively create ratios and trace data to the KPIs that matter most to you.

SEE IT IN ACTION

Tightly integrated with SAP Analytics Cloud, you can now leverage the Excel interface you have come to know so well. Enjoy the best of both worlds.

“The new add-in is easy to deploy, use, maintain, and will give you a view of your data you haven’t seen before”

-Tammy Powlas, Senior Business Analyst, Fairfax Water

GET STARTED TODAY

With an SAP Analytics Cloud license and Microsoft Excel 365, you now have free access to the application through the Microsoft store instantly.

For a step by step walk through, access the guide for add-in installation.

Thinking of trying SAP Analytics Cloud? Visit us online and try it today.

ANY QUESTIONS

Please feel free to see already posted questions here or ask your own question about SAP Analytics Cloud, add-in for Microsoft Office.

Blog written by Jeanne Bigonnet and Chris Chan

*Note: Support of Excel desktop version of Windows platform within Office 365 will require semi-annual channel currently planned by Microsoft in July 2020.

Assigned tags

      31 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Frédéric Cincet
      Frédéric Cincet

      This sounds promising. What about the positioning of this tool compared to Analysis for Office Cloud edition ?

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Frederic,

      it’s a completely new offer , separated from Analysis for Office SAC edition, with a separate road map and life cycle.

      Actually we have the two  solutions to use excel on top of SAC depending on customer’s scenarios:

      – Analysis for office for SAC  : On premise ( product installation required) and  windows environment only, but mature solution offering a large analytics capabilities and planning basics.

      – SAC add in for MS office : Desktop & Cloud solution based on Office 365 with no installation required as the add in is provided via MS store , Windows or Mac support , fully integrated into SAC ,  brand new offer, so offering for now less capabilities , but with a strong roadmap for 2020+ ,  including strong planning capabilities.

      Best

      Jeanne

      Author's profile photo Balazs Hajdu
      Balazs Hajdu

      Could you please make the "guide for installaion" public? Currently I get a "403 forbidden" error. Thank you!

      Author's profile photo Eva Isele
      Eva Isele

      Please use this link:

      Deploy and publish the add-in as administrator

      It'll be replaced soon in the text.

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi I have updated the site with the correct link. Please Check. Regards Jeanne

      Author's profile photo William Yu
      William Yu

      A great milestone for SAC!  Partnership with Microsoft looks promising as well!  Looking forward for more capabilities to come!

      Author's profile photo Jose Barnils
      Jose Barnils

      Amazing, finally the feature that most of our customers were willing to have in their SAC solution. Thanks!

      Author's profile photo Ambrish Parihar
      Ambrish Parihar

      That is great news... Mean Analysis for office excel(AFO) guys will now easily work on SAC also.....But one thing that we need to improve is that plugins should be stable and not disable again and again. Users are facing this as Major challenge. Please take it as suggestion if we can do something for that like Bex.

       

      Regards,

      Pradeep

      Author's profile photo Deepu Sasidharan
      Deepu Sasidharan

      Great addition for SAC!

      When is the Live Data Connectivity for BW/4, S/4, HANA etc. planned.  Roadmap blog doesn't provide much details.

      https://www.sapanalytics.cloud/product_updates/office-add-on-future/

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi Deepu ,

      currently SAC add-in only supports replicated data. We have in our road map for this year to support Live Data Warehouse Cloud connectivity .

      As future direction, we would like to  connect other live sources as HANA (Cloud) .

      Best

      Jeanne

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      hi,

       

      So , where we can get this Add-in. From Microsoft pages or we have some link in SAC pages?

       

      Manuel Robalinho

      Author's profile photo Anil Neupane
      Anil Neupane

      This is great news. I think if SAP can clarify if this addin is enhancement within Analysis for Office (AfO) or is entirely new add-in.

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi Anil,

      it's a completely new offer , separated from AO .

      Actually we have the two  solutions to use excel on top of SAC depending on customer’s scenarios:

      - Analysis for office : On premise ( product installation required) and  windows environment only, but mature solution offering a large analytics capabilities and planning basics , connected to SAC but to BW, HANA, BPC as well….

      - SAC add in for MS office : Desktop & Cloud solution based on Office 365 with no installation required as the add in is provided via MS store , Windows or Mac support , fully integrated into SAC ,  brand new offer, so offering for now less capabilities , but with a strong roadmap for 2020+ ,  including strong planning capabilities.

      Best

      Jeanne

      Author's profile photo Shyam Uthaman
      Shyam Uthaman

      One feature that I could do is do an opendoc drill from SAC to webi detail reports. Will there be a way to drill into AO from SAC?

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi Shyam,

      Please note, SAC add in is a brand new offer, completely different from Analysis for Office ( AO) .

      Currently the workflow starts in  SAC add-in connecting to SAC model ( replicated data). Nevertheless, in the future we want to support the capability to jump from SAC to Excel (SAC add in)  and we have it in our road map.

      Best

      Jeanne

      Author's profile photo Shyam Uthaman
      Shyam Uthaman

      When you say SAC model ( replicated data), I assume this doesn't work for Live models then ..right?

      Author's profile photo Balazs Hajdu
      Balazs Hajdu

      Have you experienced “HTTP status code forbidden” while setting up PowerShell?

      Our IT can not “Set-OganizationAddInService” for our computers, we  have to do it on our laptops individually.

      Thanks for your support!

      BR

      Balazs

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi

      I see a mistake in your screenshot in the SAC tenant URL :

      because the tenant started with ""https://https://...". I'm not sure if this is the reason for the error but you should remove one of the https in the command.

      If it does not solve your issue , please create a ticket on  LOD-ANA-OF-MS component.

      Best Regards

      Jeanne

       

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      Nice. Good idea!

      Author's profile photo Jonathan Mortlock
      Jonathan Mortlock

      It is my understanding that this doesn't work for tenants in the US2 data center as it isn't Cloud Foundry. I find that extremely disappointing tbh that we have a system that is no longer supported by some of the latest functional enhancements, including this add in and scheduled publications.

      Author's profile photo Salvatore Talerico
      Salvatore Talerico

      Hi Jeanne,

      are there any updates regarding the Excel desktop version of Windows? Is there a specific date when it will be released?

      Thanks in advance,

      Salvatore

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi Salvatore,

      the plan is to get it built on  MS Semi annual version delivered by Microsoft in July. So our current plan is to get it available in our add in in August delivery time frame.

      Please do not consider that as a strong commitment as we are still working on it and we have a strong dependency with Microsoft delivery.

      Best Regards

      Jeanne

      Author's profile photo Rahul Taneja
      Rahul Taneja

      Hello Jeanne,

      I am working on a PoC for SAC Add in for Office 365.

      Is it possible to jump from an SAC story to SAC add in using the filters which were applied in the story?

      I see that in the roadmap, seamless integration from SAC story is mentioned, not sure if this is related to my question.

      Regards,

      Rahul

      Author's profile photo Laura Milla
      Laura Milla

      Hi,

      I'm trying to install add-in for Microsoft Office
      but when I try to follow the steps the detailed on help.sap (https://help.sap.com/viewer 2b73edbc8f8f4189a36bc7a2e038185c/cloud/en-US/db2f874261824d63adb3ca198f65ce55.html)

      to set up the tenant some errors appear and I can't solve them.

      Attach in this message a screenshot with the errors.

      Could you assist me in this topic?
      Thanks,

      Author's profile photo Jitendra Kumar
      Jitendra Kumar

      What all places where we can download SAP analytics cloud for office?

       

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Please read  on line  Help , 

      Basically you can deploy the Add in for yourself if you have the permission or via the MS admin team of your company , who can deploy it centrally via the MS 365 ad lin console.

      Best

      Jeanne

      Author's profile photo Kevin Yang
      Kevin Yang

      Hi Jeanne

      awesome introduction!

      I also meet the permission issue when I want to enable this add-in for a use case. you mentioned the MS admin team. do you have a DL or contact link for that, I am from internal SAP.

      Thx

      Kevin

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      hi Kevin ,

      Please check our jam page and sign up for the distribution list mentioned there – you should get the add-in very soon after that automatically.

      In case of further questions related to the tool, go back to me. Best Jeanne

      Author's profile photo Kevin Yang
      Kevin Yang

      Hi Jeanne

      Thanks for your information. it works now. great

      Best Regards

      kevin

      Author's profile photo Dharma Teja Atluri
      Dharma Teja Atluri

      Given SAP has both on premise AFO for Excel and SAC on cloud for reporting for the clients, what if a client wants only AFO Excel and doesn't want the SAC licenses.

      Is there an option for client just to use AFO for Excel for their reporting?

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET
      Blog Post Author

      Hi ,

      yes you can use AFO on top of BW or other data sources included in your license if you have one . SAC subscription is only needed if you would like to use SAC.

      Best

      Jeanne