search

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

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 19
  • Tabulka s obsahem
  • KNIHY
    • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 9
Using SQL Server 2012 Column-Store with SAP BW
SAP COMMUNITY NETWORK scn.sap.com
© 2012 SAP AG 10
Configuring Column-Store in SAP BW
To use the column-store for SAP BW cubes, you first have to define the cubes, which should have a column-
store index on the e-fact table. This definition is stored in an SAP Data Dictionary table. The next step is to
convert the e-fact table by dropping unnecessary B-Tree indexes and creating the column-store index. You
can perform both steps either separately or within a single job using SAP report MSSCSTORE.
Defining cubes with Column-Store index
The Data Dictionary table MSSSTORAGE contains SQL Server specific storage parameters and global
settings. For each e-fact table using the column-store, there is a row in table MSSSTORAGE. You can use
report MSSCSTORE to change the settings in table MSSSTORAGE.
Note: Table MSSSTORAGE contains additional rows that are not related to the column-store. Do not modify the content
of table MSSSTORAGE manually. Always use report MSSCSTORE.
Converting cube according to definition
Defining the column-store index for an SAP BW cube is very fast, since it only modifies the SAP Data
Dictionary. Actually converting a cube can take some time. Therefore, we recommend running the
conversion always as a batch job. During the conversion to the column-store, several b-tree indexes are
dropped and a column-store index is created. When converting back to the row-store, the b-tree indexes
have to be re-created. Actually, converting the cube is nothing else than repairing the indexes of e-fact table
according to the definition stored in table MSSSTORAGE.
Note: Creating indexes, in particular b-trees, requires a significant amount of system resources: CPU, memory, I/O and
data and log space on the database. In a typical BW system, process chains drop and create indexes the whole
day. To reduce the required transaction log space, it might be a good idea to set the SQL Server recovery model
to Bulk-logged. Keep this in mind when setting up your backup strategy for the database of your BW system.
There are several ways to convert a BW cube from row-store to column-store, and vice versa:
Report MSSCSTORE
Using SAP report MSSCSTORE is the easiest way to convert the BW cube. SAP strongly recommends
running the report as a batch job. MSSCSTORE is described in detail below.
Activate empty cube
If an SAP BW cube is empty, a cube activation creates all database tables and indexes dependent on the
configuration in MSSSTORAGE. Therefore, you can simply convert an empty cube by activating it in SAP
transaction RSA1.
Zobrazit stránku 9
1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 18 19

Komentáře k této Příručce

Žádné komentáře

Zubehör für die Luft Handbücher

Wählen Sie Ihre Marke Zubehör für die Luft aus, um Benutzerhandbücher und Anleitungen herunterzuladen

Markenlste für Handbücher nach Kategorie Zubehör für die Luft
Marken Top Modelle
Airaid                               450-610 310-506 200-543 540-539-P Andere Kategorien
Dwyer                               P4 GFM2 DFMT PUX Andere Kategorien
Mahle-rti                               VCX-1 CSC10 MCX-2F (Rev C) VBB100 Andere Kategorien
Sb-filters                               Cold Air Intake Kit - Cotton Filter 75-5068 Cold Air Intake Kit - Cotton Filter 75-5019 Cold Air Intake Kit - Cotton Filter 75-2524 Cold Air Intake Kit - Cotton Filter 75-5025 Andere Kategorien
Caleffi                               534 131 573 6151 Andere Kategorien
Paasche-airbrush                               AUT BUHF-PL L-PL D500 Andere Kategorien
Rainbow-electronics                               KXО-82 MAX5093 MAX8723 KX-7 Andere Kategorien
Ross-controls                               SERPAR AND CROSSFLOW DOUBLE VALVES SERIES 35 3_2 VALVES SERIES DM2 D SILENCER_RECLASSIFIER DRIP LEG DRAINS Andere Kategorien
Labconco                               Gel Dryer 4330150 Guardian 500 Airflow Monitor Guardian Jr. Airflow Monitors 4865001 CentriVap Mobile Systems 7812014 Andere Kategorien
Solare-datensysteme                               Smart Energy mit Solar-Log Solar-Log Handbuch SMS Konfiguration Solar-Log Solar-Log WEB Classic 2nd Edition Andere Kategorien
DuraVent                               PolyPro Flex Installation DuraStack Installation PolyPro Flex PolyPro Andere Kategorien
Badger Meter                               ORION AMR/AMI Hardware Solutions for Gas Utilities ReadCenter Gas Meter Endpoints Andere Kategorien
Texsport                               14203 Double Mantle Insta Lantern 14215 Propane Heater 14226 High Output Dual Burner Piezo Igniter Propan 14206 Dexule Dual BurnerPropane Stove Andere Kategorien
Hobbywing                               XRotor-40A Platinum-100A-HV-V3 FlyFun-6A Platinum-50A-V3 Andere Kategorien
Gastroback                               46010 Design Vacuum Sealer 46011 Design Pro Vacuum Sealer 42801 Design Eggcooker 46007 Design Vacuum Sealer Plus Andere Kategorien
Lingenfelter                               L650140709 Lingenfelter Cadillac CTS-V Air Intake L650070105 Lingenfelter C6 Corvette Air Intake 200 L650172012 Lingenfelter Camaro ZL1 Air Intake Duct L650400493 Lingenfelter F-Body SuperTube Air Intak Andere Kategorien
Bell-gossett                               G95858H Circuit Setter Plus “RF” Balance Valves G95873N Circuit Setter Plus Balance Valves With NP V59075B Low Flow Model UBYL Y-Strainer Combination V1000520 Ultra Setter Pressure Independent Control Andere Kategorien
Wichita-clutch                               LKT Clutch or Brake CCB - Combination Clutch Brake Unit LK Brake Motor Brakes Andere Kategorien
Gamo                               MP9 Blowback Pistol P-25 Blowback Tactical Compact Target Pistol PT-80 Andere Kategorien
Chemglass                               CLS-3855 CLS-3857 AF-0304 CG-2025 Andere Kategorien
  • Qasair LOEWE Rain Bird Kentrox Cables Unlimited
  • RCA Nástěnné držáky pro ploché obrazovky Dodge Auta Epson Faxy MSI Notebooky Black & Decker Vařiče rýže
  • Activision Amazing Spider-Man Philips SHB5250BK/00 Shuttle SK22G2 MSI MS-7376 Samsung GX-20
  • Supermicro X10SRi-F Uživatelský manuál Electrolux EN3881AOX Uživatelský manuál Atlona AT HD590 Uživatelský manuál Acer Aspire 5730ZG Uživatelský manuál Premier Mounts PTM Uživatelský manuál

    • © 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.022 s |
    Manymanuals.com Manymanuals.de Manymanuals.fr Manymanuals.it
    Manymanuals.pl Manymanuals.cz Manymanuals.es Manymanuals-pt.com