Dynamic Precision BPC 7.3 Manuel d'utilisateur Page 2
- Page / 19
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
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
- Using SQL Server 2012 Column 1
- Store with SAP BW 1
- Table of Contents 2
- © 2012 SAP AG 3 3
- © 2012 SAP AG 4 4
- © 2012 SAP AG 5 5
- © 2012 SAP AG 6 6
- © 2012 SAP AG 7 7
- © 2012 SAP AG 8 8
- © 2012 SAP AG 9 9
- © 2012 SAP AG 10 10
- © 2012 SAP AG 11 11
- Report MSSCSTORE 12
- © 2012 SAP AG 13 13
- Administration 16
- © 2012 SAP AG 17 17
- Related Content 18
- Copyright 19
© 2020, manymanuals.fr. Tous droits réservés | 0.096 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels