Column store index type in SAP BW 7.4

[Former Member]

Hi,

We upgraded SAP BW 7.02 to SAP 7.4. We use SQL Sever 2012 Database.

Now I want to implement Column-store index in SAP BW 7.4,because this feature is embedded till SAP BW 7.31. Please let me know how to achieve it?

REgards,

Bilal

[Sriram2009 · Accepted solution]

Hi Bilal

Could you refer the SAP Note for Index compression

1459005 - Enabling index compression for SQL Server

BR

SS

[divyanshu_srivastava3 · Accepted solution]

Hi Bhat,

Please refer - 1771177 - SQL Server 2012 column-store support for SAP BW

Regards,

[Former Member · Accepted solution]

Thanks alot Divyanshu

[former_member206446 · Accepted solution]

If I may ask, what SP were you on with BW 7.02 when you went to SQL Sever 2012? We are looking at migrating to SQL Sever 2012 and are currently on BW 7.02 SP06, but also want to upgrade to BW 7.4 SP09 to run on MS SQL Server 2012.

Thank you,

Kurt