SQL Server 2014 Columnstore: Released for SAP BW

• First published on MSDN on Mar 23, 2015 by Martin Merdes.
• 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 and in https://launchpad.support.sap.com/#/notes/2116639
• The performance impact of SQL Server Columnstore is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073

SAP generally released SQL Server 2014 for SAP NetWeaver two weeks ago. As of last week, the SQL Server 2014 In-Memory Optimized Columnstore is generally available for all supported SAP BW releases. The required SAP BW Support Packages are described in detail in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SQL-Server-Column-Store-for-SAP-BW-Status-and-Release-Planning/ba-p/367854.

SQL Server 2014 Columnstore can now be used in three scenarios within SAP BW:

• Read-Only Columnstore on the e-fact table of SAP BW cubes and aggregates in BW 7.x

• Writeable Columnstore on f-fact and e-fact table of SAP BW cubes and aggregates in BW 7.x

• Columnstore Optimized Flat Cube in BW 7.4

The documentation for the Columnstore in SAP BW is available at https://scn.sap.com/docs/DOC-62873 and here:

The documentation for the Columnstore Optimized Flat Cube is available at http://scn.sap.com/docs/DOC-63091 and here: