Select language:

SAP HANA Database as Database for SAP NetWeaver BW

Use

SAP HANA is now available as a database for SAP NetWeaver BW.

You can find an overview of SAP HANA as a database for SAP NetWeaver BW in the documentation under "Using SAP HANA Database".

The following sections provide an overview of the changed, enhanced and new functions:

Data Warehousing: Modeling

Function

Type of Change

Description

SAP HANA-Optimized InfoCube

New

You can now create standard InfoCubes that are optimized for use with the SAP HANA database. You can also convert existing InfoCubes.

More information: SAP HANA-Optimized InfoCube

SAP HANA-Optimized DataStore Object

New

You can now create standard DataStore objects that are optimized for use with the SAP HANA database. You can also convert existing DataStore objects.

More information: SAP HANA-Optimized DataStore Object

Remodeling

Enhanced

The remodeling functionality also supports SAP HANA-optimized InfoCubes and SAP HANA-optimized DataStore objects. More information:

Remodeling an InfoCube

Remodeling a Data Store Object

VirtualProvider

New

A new InfoProvider is now available: the VirtualProvider based on an SAP HANA model.

More information: Creating VirtualProviders Based on a SAP HANA Model

Data Warehousing: Data Warehouse Management

Function

Type of Change

Description

Data Transfer Process

Enhanced

When using SAP HANA database, data changes on the database are initially saved in a delta index. You can use the Trigger Database Merge setting on the Update tab page in the data transfer process to stipulate that the data is transferred to the main index once the request has been processed. If this is not advisable for whatever reason (load distribution for example), you can integrate the database merge into a process chain using the new process type Trigger for Database Merge .

More information: Triggering a Database Merge

DB Connect

Enhanced

You can use DB Connect to replicate data to BW (and the BW schema) from any schema in the SAP HANA database.

More information: Transferring Data Using DB Connect

Analytic Engine

Function

Type of Change

Description

Publishing SAP HANA Models

New

You can publish data models that you have created in the SAP HANA database in the BW system.

More information: Publishing SAP HANA Models

Analytic Index / CompositeProvider in APD

Enhanced

To create analytic indexes and CompositeProviders, you previously needed a BW accelerator. You can now also do this if you have a SAP HANA database.

BW Workspace

New

BW Workspaces allow business users to create new models using central data from the BW system and local data, and to react quickly to new and changing requirements.

More information: BW Workspace

Operations in the SAP HANA Database

Changed

Calculating the exception aggregation for a single key figure in SAP HANA database is now also possible for conversions before aggregation, but is no longer possible for quantity conversions.

More information: Operations in BWA

Planning Applications Kit

New

The SAP NetWeaver BW planning engine can either have read access to the SAP HANA database or can use internal routines in the SAP HANA database for in-memory optimized planning using the ABAP Planning Applications Kit.

More information: Planning Engine