%3CLINGO-SUB%20id%3D%22lingo-sub-367872%22%20slang%3D%22en-US%22%3ESQL%20Server%202014%20Columnstore%3A%20Released%20for%20SAP%20BW%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-367872%22%20slang%3D%22en-US%22%3E%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EFirst%20published%20on%20MSDN%20on%20Mar%2023%2C%202015%20by%20Martin%20Merdes.%20%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThis%20blog%20post%20might%20be%20outdated%20by%20now.%26nbsp%3BThe%20latest%20documentation%20regarding%20SQL%20Server%20Columnstore%20on%20SAP%20is%20available%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%3C%2FA%3E%20and%20in%26nbsp%3BSAP%20Note%202116639%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThe%20performance%20impact%20of%20SQL%20Server%20Columnstore%20is%20described%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%3C%2FA%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3ESAP%20generally%20released%20SQL%20Server%202014%20for%20SAP%20NetWeaver%20two%20weeks%20ago.%20As%20of%20last%20week%2C%20the%20SQL%20Server%202014%20In-Memory%20Optimized%20Columnstore%20is%20generally%20available%20for%20all%20supported%20SAP%20BW%20releases.%20The%20required%20SAP%20BW%20Support%20Packages%20are%20described%20in%20detail%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FSQL-Server-Column-Store-for-SAP-BW-Status-and-Release-Planning%2Fba-p%2F367854%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FSQL-Server-Column-Store-for-SAP-BW-Status-and-Release-Planning%2Fba-p%2F367854%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3ESQL%20Server%202014%20Columnstore%20can%20now%20be%20used%20in%20three%20scenarios%20within%20SAP%20BW%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3ERead-Only%20Columnstore%20on%20the%20e-fact%20table%20of%20SAP%20BW%20cubes%20and%20aggregates%20in%20BW%207.x%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EWriteable%20Columnstore%20on%20f-fact%20and%20e-fact%20table%20of%20SAP%20BW%20cubes%20and%20aggregates%20in%20BW%207.x%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3EColumnstore%20Optimized%20Flat%20Cube%20in%20BW%207.4%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20documentation%20for%20the%20Columnstore%20in%20SAP%20BW%20is%20available%20at%20%3CA%20href%3D%22https%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-62873%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-62873%20%3C%2FA%3E%20and%20here%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%2094px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F88302i19AA96F1D1F93DF6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EThe%20documentation%20for%20the%20Columnstore%20Optimized%20Flat%20Cube%20is%20available%20at%20%3CA%20href%3D%22http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-63091%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Fscn.sap.com%2Fdocs%2FDOC-63091%20%3C%2FA%3E%20and%20here%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%2094px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F88303iB7F9B42988E8A9BB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-367872%22%20slang%3D%22en-US%22%3E%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EFirst%20published%20on%20MSDN%20on%20Mar%2023%2C%202015%20by%20Martin%20Merdes.%20%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThis%20blog%20post%20might%20be%20outdated%20by%20now.%26nbsp%3BThe%20latest%20documentation%20regarding%20SQL%20Server%20Columnstore%20on%20SAP%20is%20available%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%3C%2FA%3E%20and%20in%26nbsp%3BSAP%20Note%202116639%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThe%20performance%20impact%20of%20SQL%20Server%20Columnstore%20is%20described%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%3C%2FA%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-367872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdministration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ebw%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecolumnstore%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENews%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft


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-S....

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: