Dynamic Precision BPC 7.3 Manual do Utilizador descarregar pdf (Página 4)

Using SQL Server 2012 Column-Store with SAP BW

SAP COMMUNITY NETWORK scn.sap.com

For using the column-store with SAP BW, you need at least cumulative update 2 for SQL Server 2012.

However, we recommend installing service pack 1 instead (which contains all fixes from CU2). You can

download the service pack from http://www.microsoft.com/en-us/download/details.aspx?id=35575.

Column-Store Support in SAP BW

SQL Server 2012 Column-Store support has been back-ported to SAP BW 7.0. There is no need to upgrade

the SAP BW system to a newer release. Not even is it necessary to apply an enhancement package (7.01,

7.02 etc.). However, you have to install a minimum support package stack in order to benefit from the

column-store.

SAP BW

Support Package Stack (SPS)

Release to Customers (RTC)

7.0

27 (SAP_BASIS SP27, SAP_BW SP29)

2012-07-26

7.01

2012-08-13

7.02

2012-09-03

7.11

2012-08-14 not yet supported for SQL Server 2012

7.3

2012-10-02

7.31

2012-10-22

Note: SQL Server 2012 is not yet validated by SAP for SAP NetWeaver 7.11. Once SQL Server 2012 is supported for

NetWeaver 7.11, you will find more information about the minimum SAP support package in SAP note 1651862.

Prerequisites for SAP BW

1. You first have to apply the minimum Support Package Stack as listed in the table above.

2. After that, you have to import the correction instruction of SAP note 1771177 using transaction

SNOTE. The correction instruction contains report MSSCSTORE (see below). It further contains

several improvements, which are not contained in the support packages mentioned above.

3. Finally, apply service pack 1 of SQL Server 2012 (or any newer service pack of SQL Server 2012)

Note: When applying the correction instruction of SAP note 1771177, you will get the message “Object can only be

created in SAP package” (for report MSSCSTORE). Confirm this message by pressing the OK button.

SAP note 1771177 always contains the newest correction instructions that are required for the column-store.

Therefore, you should apply this note even if you are running a newer SAP support package stack as listed above.

1 2 3 4 5 6 7 8 9 ... 18 19

Sem comentários

Dynamic Precision BPC 7.3 Manual do Utilizador Página 4