Dynamic Precision BPC 7.3 Bedienungsanleitung PDF herunterladen

SAP COMMUNITY NETWORK scn.sap.com

© 2012 SAP AG 1

Using SQL Server 2012 Column-

Store with SAP BW

Applies to:

SAP Business Warehouse 7.0 and higher running on Microsoft SQL Server 2012 and higher.

Summary

SQL Server 2012 introduced an additional storage format for data. Besides the normal row-oriented store,

there is a column-oriented store as well. To make it as transparent as possible for database administrators

and applications, the new column-store was implemented as a new index type: non-clustered column-store

index. Therefore, a single table can use both stores side by side.

The column-oriented store is optimized for aggregating mass data, while the row-oriented store can be used

optimal when accessing just a single row. SQL Server 2012 column-store support has been integrated into

SAP BW and was down-ported to all common SAP BW releases:

 SAP BW 7.0 (SAP NetWeaver 7.0)

 SAP BW 7.01 (SAP enhancement package 1 for SAP NetWeaver 7.0)

 SAP BW 7.02 (SAP enhancement package 2 for SAP NetWeaver 7.0)

 SAP BW 7.11 (SAP enhancement package 1 for SAP NetWeaver 7.1)

 SAP BW 7.3 (SAP NetWeaver 7.3)

 SAP BW 7.31 (SAP enhancement package 1 for SAP NetWeaver 7.3)

In all these SAP BW releases you can benefit from increased query performance and reduced disk space

requirements of the column-store.

Author: Martin Merdes

Company: Microsoft

Created on: October 2012

Updated on: December 2012

Author Bio

Martin Merdes is a Senior Software Development Engineer at Microsoft. Since 1996 he has been working in

different technical functions for Microsoft at SAP Germany: Support Engineer, Senior Consultant, Technical

Account Manager, Premier Field Engineer and Software Development Engineer. Since 2009 he is

responsible for the porting of SAP BW on Microsoft SQL Server.

1 2 3 4 5 6 ... 18 19

Inhaltsverzeichnis

Seite 1 - Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 1 Using SQL Server 2012 Column-Store with SAP BW Applies to: SAP Business Warehouse 7.0 and hig

Seite 2 - Table of Contents

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

Seite 3 - © 2012 SAP AG 3

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 11 Repair indexes You can repair the indexes of a

Seite 4 - © 2012 SAP AG 4

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 12 Report MSSCSTORE You can start SAP report MSSC

Seite 5 - © 2012 SAP AG 5

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 13 The column-store configuration can either be a

Seite 6 - © 2012 SAP AG 6

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 14 The next step is to choose the column-store co

Seite 7 - © 2012 SAP AG 7

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 15 Configure system default In the tab Set defaul

Seite 8 - © 2012 SAP AG 8

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 16 Administration Configuring Resources To ensure

Seite 9 - © 2012 SAP AG 9

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 17 Checking column-store property Using report MS

Seite 10 - © 2012 SAP AG 10

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 18 Related Content Column-store indexes, describe

Seite 11 - © 2012 SAP AG 11

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 19 Copyright © Copyright 2012 SAP AG. All rights

Seite 12 - Report MSSCSTORE

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 20

Seite 13 - © 2012 SAP AG 13

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 3 Column-Store in SQL Server 2012 The SQL Server

Seite 14

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 4 For using the column-store with SAP BW, you nee

Seite 15

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 5 Usage of Column-Store In SAP BW each cube has t

Seite 16 - Administration

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 6 SAP Data Dictionary Support Generally, the SAP

Seite 17 - © 2012 SAP AG 17

SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 7 Fields: Consistent with the runtime object Fld Name Position Data Type Length Decimals Not

Seite 18 - Related Content

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 8 Customer Experience with SAP BW using the colum

Seite 19 - Copyright

Using SQL Server 2012 Column-Store with SAP BW SAP COMMUNITY NETWORK scn.sap.com © 2012 SAP AG 9 Aggregates By creating a fully optimized aggreg

Kommentare zu diesen Handbüchern

Keine Kommentare