Show TOC

Notes about Transferring Data from SAP HANA Using ODPLocate this document in the navigation structure

Use

You can use Operational Data Provisioning (ODP) to connect the SAP HANA database of an ABAP system as the source system to the BW system. Communication is performed using RFC. With the ODP context for SAP HANA (HANA), analytic views, calculation views and associated attribute views are provided for replication into BW. This allows you to perform calculations in the SAP HANA database on the views, before they are loaded into BW. These calculations could be currency translations and restricted key figures or key figures calculated before aggregation for example, or joins and unions.

The data transfer with DB Connect is based on SAP HANA tables however. You can find out more about DB Connect under Transferring Data with DB Connect.

Selecting SAP HANASAP HANA Views via Operational Data Providers in DataSource Maintenance

In the DataSource maintenance transaction, use an operational data provider to select which SAP HANA view you want to transfer the data to the BW system from. You can tell which SAP HANA modelling view can be selected from the name and description of the operational data provider (see below in ODP Naming Conventions and Length Restrictions for Technical Names).

Operational data providers are determined from SAP HANA views as displayed in the table:

SAP HANA-View

Semantics of the operational data provider (describes the type of the data to be transferred)

Restrictions/Notes

Analytic View

Transaction Data/Facts

  • Calculated columns in the analytic view are only taken into account during extraction if they calculate before aggregation (setting in SAP HANA Modeler).

  • Attributes in an attribute view that is linked with analytic view's Data Foundation (navigation attributes of the analytic view) are ignored during extraction.

Calculation View

Transaction Data/Facts

  • Calculated key figures in the calculation view are only taken into account during extraction if they calculate before aggregation (setting in SAP HANA Modeler).

Attribute View

Master Data/Attributes

-

The description mapping for an attribute in a calculation or attribute view is used to determine a text ODP.

Texts

-

ODP Naming Conventions and Length Restrictions for Technical Names

ODP Names:

ODP Descriptions:

The descriptions of the ODPs are taken over from SAP HANA. If there is no description for a SAP HANA view in SAP HANA, the BW system uses <package name>/<name of the view in SAP HANA> as the description.

Authorizations

In the SAP HANA database, analytic privileges are used to define which users are allowed to view which data records for analysis purposes. Analytic privileges are persisted on the BW system and in the SAP HANA database.

The SAP HANA database is accessed using the BW database user (SAP<SAPSID>). To access a view in SAP HANA, this user requires the corresponding analytic privileges and the authorizations for the corresponding schema. In the BW system (ABAP), the access by the user performing the extraction is controlled using authorization object S_RS_ODP_H. The authorization object can control access at SAP HANA package level and at view level. We recommend using the authorization object. If the user performing the extraction does not have authorization object S_RS_ODP_H in his/her profile however, s/he can still perform the extraction if there is a user with the same name with the required analytic privileges in SAP HANA.

To analyze the data replicated into BW, the user executing the query requires the corresponding analysis authorizations. You can find out more about defining and assigning analysis authorizations under Analysis Authorizations.

Constraints

Transferring data from the SAP HANA database with ODP is not supported for the following:

  • Hierarchies in attribute views

  • VirtualProviders based on the data transfer process

  • Real-Time Data Acquisition