Flat Cube became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Flat-Cube-became-default-in-SAP-BW/ba-p/368151 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP…


Columnstore became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Columnstore-became-default-in-SAP-BW/ba-p/368149 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP…


Improve SAP BW Performance by Applying the Flat Cube

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Improve-SAP-BW-Performance-by-Applying-the-Flat-Cube/ba-p/368125 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Overview SAP released the Columnstore Optimized Flat Cube over two years ago. We want to give a brief explanation of the benefits and advantages of using the Flat…


Customer Experience with Columnstore on ERP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-Experience-with-Columnstore-on-ERP/ba-p/368118 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SAP released the report MSS_CS_CREATE a few months ago. Using this report, customers can create an additional Nonclustered Columnstore Index (NCCI) on any SAP ERP table. This…


Customer experience with SAP BW FEMS-Pushdown

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-experience-with-SAP-BW-FEMS-Pushdown/ba-p/368084 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html A few months ago we released a new SAP BW statement generator, which increases BW query performance for complex queries containing FEMS filters, see https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/06/bw-queries-by-factors-faster-using-fems-pushdown. In the…


Parallel Processing in SAP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Parallel-Processing-in-SAP/ba-p/368079 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html New generations of CPUs do not provide any significant single-thread performance improvements. Instead, the number of logical CPU cores is increasing with each new CPU generation. You…


Performance evolution of SAP BW on SQL Server

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html In SAP customer support, we still see several customers running old SAP BW code that cannot leverage the improvements we delivered within the last years. In this…


BW Queries by factors faster using FEMS-pushdown

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/BW-Queries-by-factors-faster-using-FEMS-pushdown/ba-p/368018 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Complex SAP BW queries often contain FEMS-filters. These filters used to be applied on the SAP application server, which was not very efficient. A new SQL statement…


Recent SAP BW improvements for SQL Server

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Recent-SAP-BW-improvements-for-SQL-Server/ba-p/368010 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Over the course of the last few months we implemented several improvements in SAP BW. We already blogged about two improvements separately: https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/14/simplified-and-faster-sap-bw-process-chains https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/25/improved-sap-compression-tool-msscompress In this blog…


Improved SAP compression tool MSSCOMPRESS

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Improved-SAP-compression-tool-MSSCOMPRESS/ba-p/368001 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SAP program MSSCOMPRESS is a tool for reducing disk space usage of SAP NetWeaver based systems. In addition, it is often used as a monitoring tool. MSSCOMPRESS…