Dynamic Precision BPC 7.3 Instrukcja Użytkownika Pobierz pdf (Strona 17)

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

Checking column-store property

Using report MSSCSTORE, you can configure the column-store property of a BW cube in SAP DDIC. At the

same time, you can create the column-store index on the database (repair the indexes of the cube).

However, you cannot check the actual status of the indexes here. For this purpose you can use different

SAP reports:

DBACOCKPIT

When checking the database indexes of the e-fact table in SAP transaction DBACOCKPIT (as of SAP

NetWeaver 7.3), you can see the column-store as a new compression type: COLUMN

MSSCOMPRESS

Report MSSCOMPRESS is used to change the compression type of database indexes. This report has been

extended to get an overview of all your column-store indexes in the system. You can filter for tables that

have a column-store index, and check the index size. However, you cannot use this report to change the

column-store property of a table, since COLUMN is technically not simply a compression type. For this you

have to run report MSSCSTORE, which deletes the needless b-tree indexes on the database and in SAP

DDIC when creating the column-store index.

1 2 ... 12 13 14 15 16 17 18 19

Brak uwag

Dynamic Precision BPC 7.3 Instrukcja Użytkownika Strona 17