SAP NetWeaver Business Warehouse and SAP Business Explorer

This section describes all the new functions, enhancements and changes for SAP NetWeaver Business Warehouse (BW) and SAP Business Explorer (SAP BEx) for Support Package Stack 05.

SAP HANA Database as a Database for SAP NetWeaver BW

Function	Type of Change	Description
Data Warehousing: Modeling
In Memory-Optimized InfoCube	New	You can now create standard InfoCubes that are optimized for use with SAP HANA database. More information: In Memory-Optimized InfoCube
In-Memory Optimized DataStore Object	New	You can now create standard DataStore objects that are optimized for use with SAP HANA database. More information: In-Memory Optimized DataStore Object
Data Warehousing: Data Warehouse Management
Data transfer process	Enhanced	If you are 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 (from any schema) in the SAP HANA database to BW (and therefore in the BW schema) and continue editing the data in BW. More information: Transferring Data Using DB Connect
analytic manager
SAP HANA Publishing Models	New	You can publish data models that you have created in 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
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

More information: Using the SAP HANA Database

Data Warehousing: Modeling

Function

Type of Change

Description

Integration with SAP BusinessObjects

Enhanced

Integration with SAP BusinessObjects Information Steward (as of Release 4.1) now also makes it possible to perform impact analyses and data lineage at the field and InfoObject level.

More information: Integration with SAP BusinessObjects

Data Warehousing: Data Warehouse Management

Function

Type of Change

Description

Data Archiving Process

Enhanced

You can now delete near-line requests from near-line storage.

More information: Deleting an Archiving Request from Near-Line Storage

Authorizations

New

New Authorization Objects in Object Class RS:

S_RS_WSPAC: Authorizations for Working with BW Workspaces
S_RS_AO: Authorizations for Working with SAP BusinessObjects Analysis, edition for Microsoft Office

Deleted Authorization Objects:

None

New Role Templates:

The following role templates have been added for working with BW Workspaces:

BW Workspace Administrator (S_RS_TWSPA)
BW Workspace Designer (S_RS_TWSPD)
BW Workspace Query User (S_RS_TWSPQ)

Changed Role Templates:

Portal role com.sap.ip.bi.bi_showcase has been enhanced.

Deleted Role Templates:

None

New Roles:

For the business user, role SAP_BW_WORKSPACE_DESIGNER is provided.

Analytic manager

Function	Type of Change	Description
CompositeProvider	Enhanced	You can now analyze join conditions in the CompositeProvider editing transaction. More information: Extended Checks
Indexing BW Data in SAP NetWeaver BW Accelerator	Enhanced	You can index the characteristic hierarchies for a hierarchy basic characteristic in BWA (see Indexing BW Data in SAP NetWeaver BW Accelerator).
Easy Query	New	Easy queries allow external access to queries (for more information, see the overview in Open Analysis Interfaces). To activate an existing query for external access, it must be generated as an easy query. You can do this by selecting the By Easy Query option in the query properties on the Advanced tab page for the query in question in BEx Query Designer (see Query Properties). When you save, the system starts saving the easy query in the background. The system creates the corresponding SOA configuration profile for the generated easy query based on the SOA standard settings. You can then use the easy query as a SOAP service. You can obtain an overview - and manage - your easy queries in the Easy Query Manager transaction (EQMANAGER) in BW (see Managing Easy Queries).
Set Planning Function Type Key Figure Values	New	You can use function type Set Key Figure Values to set values for key figures and distribute them according to reference data (see Setting Key Figure Values).

Generic Tools and Services

Function

Type of Change

Description

BW Metadata Search in the Embedded Search/SAP NetWeaver Enterprise Search

New

If you are using the Embedded Search from the SAP NetWeaver Application Server or SAP NetWeaver Enterprise Search, you can use these applications to find BW metadata objects.

More information: Using SAP NetWeaver Enterprise Search for the BW Metadata Search