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

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

The column-store configuration can either be an explicit configuration for a particular cube or an implicit

configuration using the system default. Valid configuration values are:

 "NONCLUSTERED"

for cubes having a non-clustered column-store index

 " " (an empty field)

for cubes not having a column-store index

Note: You may also see in SE16 the configuration value "NOT_SUPPORTED". This indicates that a cube was explicitly

configured to use the column-store. However, it cannot use it, because it includes a key figure with high precision.

The configuartion values are stored in table MSSSTORAGE in field TEXT.The field TABNAME contains the

name of the e-fact table for an explicit column-store configuration of a cube. The system default is also

stored in table MSSTORAGE with TABNAME = "&GLOBAL_EFACT"

In the example above, all cubes are configured implicitly to use the column-store, except for the following

four cubes: COPY_BNE, COPY_BPE, PERF_BTE, PERF_BTF.

Cube 0CCMSAMEM (with e-fact table /BI0/E0CCMSAMEM) is configured to use the column-store index due

to its explicit configuration in addition to the system default. It is useful to store the explicit configuration to

keep the cube unchanged, even if you will change the system default in the future.

If there is no row with TABNAME = "&GLOBAL_EFACT" in MSSSTORAGE, then the system default is, not

to use the column-store index.

By pressing F3 (green arrow back), you can return to the main screen of report MSSCSTORE

Configure single cube

In the tab Process single cube you have to enter the cube name (not the name of the e-fact table) that you

want to configure. To get a list of all cubes, you can use the F4 help. Alternatively, you can type the cube

name manually in the input field.

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

Žádné komentáře

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