If you are using the HANA system, it is possible to create HANA views for selected types of DataProviders using SAP HANA Smart Data Integration or SAP HANA Smart Data Access.

Prerequisites for HANA SDI

The provisioning of offloaded data to the HANA view is using the following components.

SAP HANA Smart Data Integration and SAP HANA Smart Data Quality
- Version 1.0 SP03 Patch 11 (1.3.11) for SAP HANA 1.0 SPS 12 and higher
HANA DP Agent 2.0
- Install the Data Provisioning Agent
SNP OutBoard™ Data Tiering SDA+ HANA native add-on transport

Setup for HANA SDI

As soon as you met the prerequisites, you need to do the following:

Install the Data Provisioning Agent
Configure the Data Provisioning Agent
Register Adapters with SAP HANA
- Deploy and register ABAPAdapter
Add Remote source in HANA studio
- Add SAP system where SDA+ is installed

Setup for HANA SDA

Add Remote source in HANA studio

Useful links

Install and Configure the Data Provisioning Agent

SAP HANA Academy - SDI: ABAP Adapter [SPS 11]

Not supported types of DataProvider

HANA views can be created for all types of DataProvider except the following types:

Tables
- HANA native
- DDIC
InfoProviders
- Write Optimized DSO

Creation of view

In order to be able to access offloaded data of DataProvider, you need to create a HANA view. You can do it by creating this report:

Go to main SDA+ transaction /DVD/OFF
Select menu Other
Choose Expert tools
Execute /DVD/OFF_ANA_H_CREATE_HNA_OBJS - Create HANA view for DataProvider

Report execution parameters

Parameter name

Parameter name
HANA DB connection	Connection name to HANA database (leave empty if you want to use primary HANA database)
Schema	Name of the database schema
Remote source	Remote source defined on HANA database that points to the current SAP system
DataProvider Name	Name of DataProvider for which we want to create a view

Object names are generated with the following names:

Object kind	HANA object name pattern

Object kind	HANA object name pattern
Virtual table name	<Remote source>_<DataProvider Name>_VT
Aggregation with pruning condition	<Remote source>_<DataProvider Name>_CS.AGGR_FILTER
Calculation scenario (for reading data)	<Remote source>_<DataProvider Name>_CS

If you want to get the list of DataProviders for which the HANA view was already created, use the search help in a view deletion report or read table /DVD/OFF_ANA_H_S using transaction SE16.

The functionality will create the following calculation scenario:

Pruning condition

Pruning condition is vital for good performance of existing queries that will be also using offloaded data. This condition will restrict reading data from an underlying virtual table if the user reads data with a certain filter. This filler will be intersected with the pruning condition if the result is not empty set data will be read otherwise the virtual table is not accessed. Currently, it is possible to generate two kinds of pruning conditions.

Update of pruning condition

The condition will be automatically updated after the following DataProvider events:

Offload
Reload
- Including selective reload by Writer 3.0

Manual update of pruning conditions shouldn’t be necessary. If you need to update it manually as a workaround, repeat the creation of a view with the same parameters.

Default

By default pruning condition is set the same as uniting of all offloading request conditions of DataProvider.

Less equal from MAX values

Maximal values of specified fields of DataProvider are combined into conditions with the less equal operators.

Let's have fields from FIELD_1 to FIELD_N and function <MAX(FIELD_X)> - the maximal value of field FIELD_X in offloaded data, the condition will be generated as follows:

FIELD_1 <= <MAX(FIELD_1)> AND FIELD_2 <= <MAX(FIELD_2)> AND … AND FIELD_N <= <MAX(FIELD_N)>

Fields selection

Fields that will be used for the generation of pruning conditions can be set as DataProvider specific setting HANA_OBJ_PRUNNING_FIELD in CSV format.

Example: FIELD_1;FIELD_2;FIELD_3

Deletion of view

If you don’t want to use the created HANA view anymore, you can delete it with a deletion report. You can find it attached to the main SDA+ transaction.

Go to main SDA+ transaction /DVD/OFF
Select menu Other
Choose Expert tools
Execute /DVD/OFF_ANA_H_DELETE_HNA_OBJS - Delete HANA view of DataProvider

The program contains only one execution parameter for the DataProvider name, for which the HANA view should be deleted.

Please be sure that the HANA view that you want to delete is not used in HANA anymore. If you delete a view that is further used, dependent objects become inconsistent.