search

Dynamic Precision BPC 7.3 Manuale Utente Pagina 2

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
  • Pagina
    / 19
  • Indice
  • SEGNALIBRI
    • Valutato. / 5. Basato su recensioni clienti
Vedere la pagina 1
Using SQL Server 2012 Column-Store with SAP BW
SAP COMMUNITY NETWORK scn.sap.com
© 2012 SAP AG 2
Table of Contents
Column-Store in SQL Server 2012 ..................................................................................................................... 3
Space Saving .................................................................................................................................................. 3
Query Performance ......................................................................................................................................... 3
Fast Index creation .......................................................................................................................................... 3
SQL Server restrictions ................................................................................................................................... 3
Column-Store Support in SAP BW ..................................................................................................................... 4
Prerequisites for SAP BW ............................................................................................................................... 4
Usage of Column-Store................................................................................................................................... 5
SAP BW restrictions ........................................................................................................................................ 5
Key figures with increased precision ............................................................................................................................ 5
SAP system upgrade to 7.3 ......................................................................................................................................... 5
BW Transport Connection ............................................................................................................................................ 5
SAP Data Dictionary Support .......................................................................................................................... 6
Index Layout in SAP DDIC .............................................................................................................................. 6
Index layout on database with CS-index ...................................................................................................................... 6
Index layout on database without CS-index ................................................................................................................. 7
Customer Experience with SAP BW using the column-store ............................................................................. 8
Space Savings ................................................................................................................................................ 8
Query Performance ......................................................................................................................................... 8
Aggregates ...................................................................................................................................................... 9
BW compression ............................................................................................................................................. 9
Configuring Column-Store in SAP BW ............................................................................................................. 10
Defining cubes with Column-Store index ...................................................................................................... 10
Converting cube according to definition ........................................................................................................ 10
Report MSSCSTORE ................................................................................................................................................ 10
Activate empty cube ................................................................................................................................................... 10
Repair indexes ........................................................................................................................................................... 11
BW Process chain ...................................................................................................................................................... 11
Report MSSCSTORE ....................................................................................................................................... 12
Current configuration ................................................................................................................................................. 12
Configure single cube ................................................................................................................................................ 13
Configure system default ........................................................................................................................................... 15
Administration ................................................................................................................................................... 16
Configuring Resources.................................................................................................................................. 16
SQL Server memory .................................................................................................................................................. 16
SQL Server parallelism .............................................................................................................................................. 16
Checking column-store property ................................................................................................................... 17
DBACOCKPIT ............................................................................................................................................................ 17
MSSCOMPRESS ....................................................................................................................................................... 17
Related Content ................................................................................................................................................ 18
Copyright........................................................................................................................................................... 19
Vedere la pagina 1
1 2 3 4 5 6 7 ... 18 19

Commenti su questo manuale

Nessun commento
  • Argent Data Systems Chore-Time Visus Brilix Electrolux Rex
  • Sekonic Misurazione, test & controllo Olympus Dock station per dispositivi portatili HP Software di riconoscimento ottico dei caratteri (OCR) Graco Aerografi elettrici Insignia Videocamera
  • Activision Prototype 2 Philips AJ130/12 Acer EB321QUR Acer TravelMate 8371G Electrolux EOG2102AOX
  • Casio YA-P10 Manuale Utente Olympus C-500ZOOM Manuale Utente KitchenAid KHIAS 87700 Istruzioni per l'uso Hampton Bay KP1896-NHK Guida di Installazione