Skip to Content
Personal Insights
Author's profile photo Gajendra Moond

SAP Analysis for Office for SAP Analytics Cloud – Observations

Introduction

This blog post shares the initial observations on accessing SAP Analytics Cloud content via SAP Analysis for Office.

 

Landscape

SAP Analysis for Office: 2.8.100.92864

SAP Analytics Cloud: 2020.21.14 / 1.00.202021.03.1604608439

Microsoft Office 365ProPlus

 

Observations

  • Both Regular and Live Data connections are available for creation

 

  • Only SAC models are available as DataSource not the Stories

 

  • Model level variables, if any, show up upon selecting the model. Variables can also be called and updated by clicking on “Prompts” button in the ribbon. Variants cannot be saved.

 

  • Version and Account are displayed by default in the output. Both the dimensions can neither be removed from output nor can be moved to Filter

 

  • As shown in the output above, only Measures’ description cannot be changed

 

  • Only booked data can be analyzed. There is no provision for planning on unbooked data.

 

  • Members, properties(attributes) and associated hierarchies show up and are available for selection and output display

 

  • Version dimension cannot be removed from the output but can be set to “No display”

 

  • When data is changed, unlike regular input forms, only “Recalculate” icon is activated and not the “Save Data” icon. The reason being that SAC-P expects input at any level and will need to check once for disaggregation and hence need to be recalculated first. However, if you change data and recalculate but do not save it and change the numbers again and hit “Save Data” instead of “Recalculate”, the system will recalculate as part of save. Hence, the last value will show up after save.

 

  • When clicked on “Save Data”, it triggers the save but no success/failure message is being displayed. However, data did save.

 

  • Data input is supported at node level. Value can be entered in the “Result” column or a node in the hierarchy. “Save Data” in SAP AO is equivalent of “Publish Data” in SAC-P. When a value is entered and recalculated, the recalculated numbers reflect in SAC-P as well

 

  • The above behavior is the reason that in SAP AO, there is no option to revert input back to saved state but to the previous consistent client state.

 

  • The story in SAC-P and the SAP AO workbook both were open at the same time for same data scope and no data locking happened.

 

  • In terms on key-figures, you cannot add Calculation, Advanced Calculation or Dynamic Calculation. However, you can add Restriction.

 

  • Comments are not supported. The comments entered in SAC-P story do not show up in SAP AO and comments entered in SAP AO are read only and restricted locally to the document.

 

  • There is no provision to call a Data Action configured in SAC-P. Since it is an equivalent of Planning Function/Planning Sequence, it seemed possible but then the options were greyed out and it did not allow to add any.

 

  • The other features seemed to work fine in the present case. This included:
    • Refresh/Reset and Pause Refresh
    • Filter
    • Style
    • Chart
    • Add New Lines (Read only) – New members cannot be added via SAP Analysis for Office. Do so in SAC-P
    • Smart Copy/Paste
    • Prompts, Filter, Sort, Hierarchy and Calculations (Only Restriction)
    • Undo/Redo
    • Design rules
    • VBA works fine (Only basic APIs were tested)

 

  • There is no Lifecycle Management for SAP AO workbooks. It remains a local document only and cannot be transported.

 

Final thoughts

  • This is a good offering and could address the planners’ need for Excel front end to enable them to perform data input by leveraging their local spreadsheets
  • Following features could be a nice addition:
    • Provide an option to launch a story in SAP AO directly from SAC-P
    • End to end comments integration
    • Change of cell color upon data change in SAP AO same as in SAC-P
    • Ability to call Data Actions from SAP AO

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Iver van de Zand
      Iver van de Zand

      very nice write up Gajendra ! I will pick up with our product experts reviewing your final thoughts and recommendations

      Author's profile photo Jeanne BIGONNET
      Jeanne BIGONNET

      Hi Gajendra,

      thanks for your input.

      Please have a look to SAP Analysis for Microsoft Office Road map  from SAP Analysis for Microsoft Office community page  HERE  .

      As you can see , we do not plan to enhance planning capabilities on SAP Analysis for Microsoft Office connected to  SAP Analytics Cloud data source.

      SAP Analysis for Microsoft Office continues to be a key add-in for multiple data sources like BW, BPC, S/4, Group Reporting.  It can also be used with SAP Analytics Cloud. However, most planning enhancements for an add-in connecting to SAP Analytics Cloud will be delivered on SAP Analytics Cloud add in for Microsoft Office.

      Indeed, for Excel planning scenarios connected to SAC data , we are positioning a brand new Cloud solution , SAP Analytics Cloud add in for Microsoft Office. This offer is available on the market  since last May 2020 and its fully integrated into SAP Analytics Cloud.

      To know more about it , please see:

      SAP Analytics Cloud add in for MS office - Community page & blogs & FAQ  – Click HERE

      SAP Analytics Cloud add in for MS office   – See it in action! – Click HERE

      Best Regards,

      Jeanne Bigonnet

      Author's profile photo Gajendra Moond
      Gajendra Moond
      Blog Post Author

      Thank you Jeanne. I am aware of the SAC add-in for MS add-in. However, it is only delivered via Office store and cannot be downloaded via SAP support portal. This is an issue with organizations with strict security policies which completely block Office store access. If the same add-in can be provided via SAP support portal for installation, that would really help.