Dynamic Precision BPC 7.3 Uživatelský manuál stáhnout pdf (Strana 14)

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

The next step is to choose the column-store configuration for the given cube by pressing one of these radio

buttons:

 Use Column-Store index

Creates the explicit configuration: use the column-store for the cube.

Technically, it adds an entry in MSSTORAGE for the e-fact table of this particular cube with

PARNAME = "COLUMNSTORE" and TEXT = "NONCLUSTERED"

 Use B-Tree indexes

Creates the explicit configuration: use not the column-store for the cube.

Technically, it adds an entry in MSSTORAGE for the e-fact table of this particular cube with

PARNAME = "COLUMNSTORE" and TEXT = " "

 Use current system default

Deletes the explicit configuration for the cube.

Technically, it deletes the entry in MSSSTORAGE for the e-fact table of this particular cube

In addition, you can select the following check boxes:

 Deact. aggregates for CS cubes

If the configuration results in using the column-store (by either an explicit configuration or the system

default), then the BW aggregates of this particular cube are deactivated. They are still defined in

SAP BW. However, the database tables of the aggregates are dropped on SQL Server, which results

in further disk space savings.

 Repair indexes of this cube

Repairs all indexes of the chosen cube according to the configuration in MSSSTORAGE

To start the process, you have to press the button Execute (F8). However, when selecting one of the two

options above, it is strongly recommended starting the process as a batch job. Therefore, you have to

choose Execute in Background (F9) from the Program menu.

To check the status of the background job and to view the job log files, use SAP transaction SM37.

Alternatively, you can press the button SM37. In this case you can return to the main screen of report

MSSCSTORE by pressing F3 (green arrow back).

Note: The main screen of report MSSCSTORE has two tabs: Process single cube and Set default for all cubes. When

executing the report (in dialog or background), the outcome depends on the currently visible tab. To configure a

single cube, you must execute the report while tab Process single cube is visible. To change the system default,

the tab Set default for all cubes has to be the active tab.

When creating a report variant, you can set parameters for both tabs at the same time. Therefore, SAP does not

recommend creating variants manually for report MSSCSTORE. Instead, you can simply press F9 to schedule the

report with an automatically created, temporary variant that uses the chosen options on the active tab.

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

Žádné komentáře

Dynamic Precision BPC 7.3 Uživatelský manuál Strana 14