

For SAP Analytics Cloud we only support grand total and percentage grand total as in case of the HANA live connection. This will also be supported with the upcoming Analysis for Office 2.8 release. In Analysis for Office also other calculations like percentage of total (%CT) or query total and also totals for x or y axis are available. We also added for the custom formulas created on the fly in for Analysis for Office and SAP Analytics Cloud the calculation of GrandTotal(GT) and % GrandTotal (%GT). GrandTotal and % GrandTotal in custom formula This is the same as in the query designer for backend modelled exception aggregation. Depending on the aggregation type you have at maximum 5 dimension you can choose to where the exception aggregation acts on. As for HANA live connections one can in the calculation editor now choose custom aggregations for BW live connections. It will also be adopted by SAP Analytics Cloud and is planned for wave 22. Now with 7.50 SP16 we brought this function also down to the NW BW customers. We already mention the custom aggregation being available for SAP Analysis for Office with the upcoming release 2.8 in the previous blog ‘ Improvements of BW/4HANA Analytical Engine in Q1 2019 with BW/4HANA 2.0’.

Let us have a glimpse on each of the topics in detail.Ĭustom Exception Aggregation for Analysis Office and SAC on the fly
#GISTO ADD TAG DRIVER#
The main driver for those innovations is the SAP Analytics Cloud integration. In addition, we are now with BW/4HANA 2.0 SP 4 and NW BW SP16 shipping those new features.

Those features we now brought down also to NW BW customers with NW BW 7.50 SP16. For details read the blog ‘ Improvements of BW/4HANA Analytical Engine in Q1 2019 with BW/4HANA 2.0’. The last improvements in the analytical engine of BW/4HANA were shipped with BW/4HANA 2.0.
