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

SAP analytics Cloud, see latest news from Microsoft Office integration

With the latest Q3 2021 release, you can benefit from SAP Analytics Cloud new model type in Excel, to cover complex requirements. This includes the flexibility to plan or report in Excel using a large number of currencies.

We also introduced the option to “Show repetitive member names” in the grid which fasten integration with Excel formulas or Pivot table creation.

New Model Support in SAP Analytics Cloud, add-in for Microsoft Excel

You can now use models of the new model type “Model with Measures” for your analyses and planning.

So it is now possible to retrieve and display data created on a New model type for Analytics and Planning scenarios.
Data contained in the New Model type as Measures ( decimal, integer, exception of aggregation….), Calculated Measures, Conversion Measures and dimensions can then be consumed in Excel environment .

Amounts can be retrieved in Local currency (LC) , defined Group currency (GC) or converted in to any desired currency. Complex calculations from the model can also be retrieved.

New option “Show Repetitive member names” in SAP Analytics Cloud, add-in for Microsoft  Office table.

On the builder pane, end-user can now choose to show repetitively Dimension’s member names in the table.

This will help the end-user to benefit from Excel capabilities, e.g. it will support smoothly integration with Excel Index formulas or Pivot table creation on top of SAP Analytics Cloud Data as no header cell will remain empty in the grid.

 

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vibhav Nallan
      Vibhav Nallan

      Great article! Could you please let me know when this add-in will support models using a BW Live or SAP Data Warehouse Cloud Live connection?

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

      Hi,

      Yes ,great news ! SAP Data Warehouse Cloud Live connection is planned to be released to customer by end of this week ( around Oct 6). Then  you will benefit from the add-in  Excel strengths on top of DWC sources.

      Next live source we do plan to support is  S/4HANA Cloud. Others sources as BW are in our backlog too but not for mid -term direction. You can have a deeper look in our road map  .

      Best

      Jeanne

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

      SAP Data Warehouse Cloud live connectivity is available now ! See this blog. for further details.

       

      Author's profile photo Vibhav Nallan
      Vibhav Nallan

      Hi Jeanne, one other question. Does this add-in support models in DWC with Input Parameters? Appreciate any light you could shed on this.

       

      Regards,

      Vibhav