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

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

Configure system default

In the tab Set default for all cubes you can configure the default for all new BW cubes. You can use one of

the following options:

 Use Column-Store index

Use the column-store for cubes that do not have an explicit configuration.

Technically, it adds/updates the entry in MSSTORAGE for TABNAME = "&GLOBAL_EFACT" with

PARNAME = "COLUMNSTORE" and TEXT = "NONCLUSTERED"

 Use B-Tree indexes

Do not use the column-store for cubes that do not have an explicit configuration.

Technically, it adds/updates the entry in MSSTORAGE for TABNAME = "&GLOBAL_EFACT" with

PARNAME = "COLUMNSTORE" and TEXT = ""

In addition to the system default, you may also modify existing explicit configurations at the same time:

 Set cube definition to default

Overwrites existing explicit configurations with the new default value. As a result, all cubes are

configured identically.

Note: SAP BW automatically creates an explicit column-store configuration entry (in table MSSSTORAGE) based on the

system default, each time the indexes of a cube are checked or created. This implementation ensures that already

existing cubes keep their column-store configuration once you change the system default. As a result, table

MSSSTORAGE might contain hundreds of rows.

The options Deact. aggregates for CS cubes and Repair indexes of all cubes work the same as

described for the single cube configuration. However, the options have effect on all cubes of the system,

even if their column-store configuration was not changed.

Note: There is no option in report MSSCSTORE to activate aggregates when configuring the cubes to use b-tree

indexes. This decision was made for two reasons: Firstly, customers often have defined some aggregates, which

are deactivated by default. Secondly, creating the aggregates can take a significant amount of time. Therefore,

customers should schedule the aggregate creation using a process chain, if needed.

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

Žádné komentáře

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