Dynamic Precision BPC 7.3 Bedienungsanleitung PDF herunterladen (Seite 11)

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

Repair indexes

You can repair the indexes of all tables of a cube in SAP transaction RSA1 -> Manage -> Performance. As a

matter of course, the index repair takes into account the definition in table MSSSTORAGE.

There are two buttons that both start a batch job for the index repair:

 Repair DB Indexes (Now)

 Create DB Index (Btch)

There is only one difference between the two buttons. Pressing the first button starts the batch job

immediately. When pressing the second button, you can schedule the batch job at any time.

BW Process chain

Almost all processes in SAP BW are running as batch jobs within BW process chains. Most customers

include the process types "Delete Index" and "Generate Index" in their process chains. The process type

"Generate Index" performs an index repair. It therefore automatically converts the cube from row-store to

column-store (and vice versa), dependent on the current configuration in MSSSTORAGE.

Therefore, the easiest way to convert a cube to column-store is the following:

1. Configure the cube for using the column-store in report MSSCSTORE

2. Convert the cube automatically during the next process chain (at night) that contains the process

type "Generate Index" for this cube.

1 2 ... 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Keine Kommentare

Dynamic Precision BPC 7.3 Bedienungsanleitung Seite 11