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
- A migration/conversion tool from Analysis Office to SAC add-in is not available.
- 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
- 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
SAP Knowledge Base Article - Public