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.