SAP Knowledge Base Article - Public

3723279 - Is there a conversion tool for Analysis for Office workbooks to SAP analytics cloud add-in?

Symptom

  • Classic Planning Model workbooks in Analysis for Office (AFO) need conversion to SAP Analytics Cloud (SAC) add-in, pointing to the new SAC model.
  • Heavy calculations are referenced in other Excel tabs linked to AO workbooks.
  • Existing SAC add-in workbooks pointing to the Classic model require switching the data source to the new SAC model type.
  • Users seek a workaround or the fastest method to convert AO workbooks to SAC add-in without rebuilding from scratch.

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Cause

  • The technical basis of Analysis Office and SAC add-in differs significantly (e.g., direct vs tunnel connection, BICS vs Firefly).
  • Not all features available in Analysis Office are supported in SAC add-in.

Resolution

  1. A migration/conversion tool from Analysis Office to SAC add-in is not available.
  2. Users are encouraged to vote for the request on the influence portal to prioritize development of a migration tool. https://influence.sap.com/sap/ino/#/idea/278332/?section=sectionDetails" SAP Influence Portal /a 
  3. As of now, feature development for SAC add-in is prioritized over migration support investigation.

See Also

Understanding the Various Analysis for Microsoft Office Versions
https://community.sap.com/t5/technology-blog-posts-by-members/understanding-the-various-analysis-for-microsoft-office-versions/ba-p/13486536 

SAP Analysis for Microsoft Office - Standard vs. SAP Analytics Cloud edition
https://community.sap.com/t5/technology-blog-posts-by-sap/sap-analysis-for-microsoft-office-standard-vs-sap-analytics-cloud-edition/bc-p/13567933 

Comparison of SAP Analysis for Microsoft Office (SAC edition) vs. SAC add-in for Microsoft Excel-
https://community.sap.com/t5/technology-blog-posts-by-sap/comparison-of-sap-analysis-for-microsoft-office-sac-edition-vs-sac-add-in/ba-p/13783155

SAP BPC Move to SAC: MS Office/Excel add-in
https://community.sap.com/t5/technology-blog-posts-by-sap/sap-bpc-move-to-sac-ms-office-excel-add-in/ba-p/13571153

SAP Analytics Cloud, add-in for Microsoft Office
https://pages.community.sap.com/topics/cloud-analytics/ms-office-add-in

Keywords

analysis for office, AFO, SAP analytics cloud, SAC add-in, workbook conversion, classic model, new model, data source switch, migration tool, influence portal, BICS, Firefly, feature development , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , How To

Product

SAP Analytics Cloud 1.0