Analysis for Microsoft Office

[puneetchawla]

Hi Team

need your urgent help

The client currently runs the report in BOBJ edition for Analysis for Office using hana calculation views as the source and wants to switch to SAC

1) Can we use the existing version of Analysis for office to connect to SAC if yes/no how to proceed

2) We do have microsoft add in for SAC and analysis for ms office edition for SAC whats the difference between these two.. as its slightly confusing

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex

[N1kh1l]

puneetchawla

AFO BOBJ edition can connect with SAC from 2.5 onwards. See details below.

2460065 - Integration of SAP Analytics Cloud in Analysis Office - SAP ONE Support Launchpad

AFO for SAC edition does not include Powerpoint and word integration. It enables you to analyze and plan with data sources from SAP BW, SAP BW/4HANA, SAP HANA and SAP Analytics Cloud . SAC license should allow usage of AFO SAC edition only

Details for AFO SAC edition is here.

https://help.sap.com/docs/SAP_ANALYSIS_OFFICE_CLOUD/b25c777a2c8c4e3da2f472cce24f289c/b8845aebf9a9436...

SAC Add-in is separate Add-in specifically built to consume SAC Models in Excel front end with support for specific formulas to read data like SAPGETDATA(), SAPGETDIMENSION() etc.

Also support for Data Action is available for planning models which AFO does not have. SAC Add-in is still very nascent and features get added with every QRC release. I feel its more suited for planning use case in SAC.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE

Hope this helps !!

Nikhil

[puneetchawla]

Thanks Nikhil

Couple of inputs needed, appreciate ur help

1) given the case above, in the existing setup of BOBJ AFO, if the plan is to get rid of BOBJ, can the existing AFO edition available with BOBJ will still be useful to connect to SAC models (live and import) or in this case we will have to go with SAP Analysis for Office SAC edition

2) currently in BOBJ AFO setup, there are alerts, whats the provision if using SAC with standard edition of AFO or using AFO SAC edition

3) Can grid pages cover all the functionality of afo for analytical purposes, no planning

[N1kh1l]

puneetchawla

My response below.

1. AFO BOBJ edition licensing is not free, so once you get rid of BOBJ completely you might have to think about the AFO Full edition as it cannot be licensed separately. AFO SAC edition should come with SAC licensing so I think You can switch to AFO SAC if the plan is to phase out BOBJ completely and no users using any other plugin of Analysis currently.

2. Not sure what you meant by alerts but SAC does have thresholds feature. Also AFO full edition and SAC edition differ on Powerpoint integration, BI platform services and BPC related plugins.

3. Do you mean grid pages of SAC story? I don't think grid pages can offer same analytical capabilities what AFO (any version) can offer.

Please refer to the below 2 blogs for more details

https://blogs.sap.com/2021/02/19/understanding-the-various-analysis-for-microsoft-office-versions/

https://blogs.sap.com/2021/02/23/extending-the-reach-of-sap-analytics-cloud-data-with-microsoft-offi...

Hope this helps !!

Please upvote/accept the answer if it helps

Nikhil